Peter Ritchie's Q&A profile

• Visual Studio 2008 (Pre-release) Support for Group By, Having etc

  How sophisticated are the query capabilities for LINQ. Can a SELECT includes Group Bys, Aggregate Functions, Having Clauses. I have a sophisticated query which runs within the MS Access query designer, but running the same query using .NET OleDb provider results in an error. The query uses joins to selects which have group by and aggregate functions in them. The error message says there is an error in the Syntax after the From clause. So I'm thinking to return result sets back to VB.NET and use LINQ to further process the data into the final result set. The other alternative is use a lot more code to massage the data into the final result set which is going to be nasty. LINQ includes a whole r ...Show All

• SQL Server parameter boxes are empty

  Hi, I am have a reporting server which connects to a analysis server which connects to a sql server and a db2 server. I am using windows integrated security all the time except for the DB2 connection. That is a fixed username/password. Reporting server (RS), analysis server (AS) and sql server are all on the same machine. I created a local group and added the correct users to it. I gave that group browse rights on the reports so that works correctly. I created a role in AS and added that group to that role. Gave all read rights to that role. I created a login for that group on the SQL server and gave that group db_datareader role. When I connect as an administrator every reports runs fine. When the test user connects t ...Show All

• Visual Studio Team System Undoing exclusive checkouts

  All: My question/problem is this: A TFS user has a number of files checked out for exclusive checkout. The user has subsequently left the company. His domain user account has been deleted. We've tried a number of command line commands to unlock the files, undo the operation, delete the workspace etc. However these approaches all seem to require workspace/owner information, & are unable to find/process the workspace the files were checked out to. How can I undo/delete the checkout operation if the workspace or domain user account no longer exists Thanks in advance, Dave Riches What is the user name If you specify the workspace as just "workspacename", it will use your username instead of th ...Show All

• Visual Basic Problem whit publishing

  When publishing program to a computer thet don't have internet access and framework i found thet i have to include prerequisites. Becose prerquisites can't be downloaded from web in properties i specify thet prerequisites download from the same location as my application. When publishing start i got three errors: Error 1 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'DotNetFX\instmsia.exe' in item '.NET Framework 2.0' can not be located on disk. Error 2 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'DotNetFX\WindowsInstaller-KB893803-v2-x86.exe' in item '.NET Framework 2.0' can not be located on disk. See Help for more info ...Show All

• Visual Studio Express Editions Link Resource Image to PictureBox

  I have several pictures in the Resources File of my application, and have made several forms. What I would like to do is autogenerate a thumbnail on a button for each image, and when someone clicks on the thumbnail I would like it to open Form2 and fill the PictureBox with the appropriate image from the Resources File. I cannot figure out how to do this though, and so would appreciate any help that anyone can give me. 1) I would like my application to create a thumbnail of the appropriate JPG Image. 2) When someone clicks on the button / thumbnail I would like to open Form2 and fill the PictureBox with the appropriate image. I am able to open the form, but I cannot seem to open the image. 3) I would also like to know how to arrange it so t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Direct Answers For A Beginer

  Dear, I Am A Beginer In Game Development, But Professional In C# And C++.Net 2005. I Want To Start Learning 3D Game Development Where I Have 2 Main Questions: 1- C++, C++.Net 2005, Or C# Is The Fastest And The Powerfull Language For Creating 3D Application 2- What Is The Graphic Library I Have To Learn And What Are The Difference Between XNA, DirectX, And XNA Game Studio I Hope To Help Me In My 1st Steps. Thx Alot Dear, What I Want First Is To Be 1 Of The Professional 3D Game Developers. Second, I Want To Build My Own Virtual Reality System Which Represent Me And My Friends And Allow Us To Play Together Like "The Sims" Game, But Over A Network. ...Show All

• .NET Development System.NullReferenceException: Using DataAdapter.Fill

  I try to fill a dataset, with a dataadapter, I get the following error: {"Object reference not set to an instance of an object." } [System.NullReferenceException]: {"Object reference not set to an instance of an object." } System.Object: {System.NullReferenceException} _className: null _COMPlusExceptionCode: -532459699 _exceptionMethod: <undefined value> _exceptionMethodString: null _helpURL: null _HResult: -2147467261 _innerException: { } _message: "Object reference not set to an instance of an object." _remoteStackIndex: 0 _remoteStackTraceString: null _source: null _stackTrace: {System.Array} _stackTraceString: null _xcode: -1073741819 _xptrs: 1235480 HelpLink: null ...Show All

• Visual Studio Express Editions concerning media player

  renee where do I post pause button code wow that sounds complicated.....but first....this is my pause button........ then I thought I would like a back button......dont know if it should keep repeating last song or not, at the moment it just rewinds the current track to start......mmmm what do ya think pause button Private Sub btpause_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btpause.Click If WMP.playState = WMPPlayState.wmppsPlaying Then WMP.Ctlcontrols.pause() tmr.Stop() ProgressBar.Value = ProgressBar.Value btpause.Text = "paused" btpause.ForeColor = Color.Aqua Else If WMP.playState = WMPPlayState.wmppsPaused Then ...Show All

• Smart Device Development Is there a web server built into Pocket PC

  Does Pocket PC 2003 and 2005 contain a local IIS capable of running ASP or ASPX pages I picked up on a couple of sites that there might be one but couldnt get any further I am hoping to write a web app that automatically switches to the local IIS and local Sql CE when the device is disconnected from the network. thanks Thanks Ilya I was hoping to have a browser based application so I could use the same forms that we can generate when the server is connected. The problem is that a browser cannot update a local CE database without a web server in between (unless I write an activex ) ...Show All

• Visual Studio Team System Bug status in Team System

  In Team System, is there a way to edit the fields under Status   For example Priority is a status that shows up with numbers.  I would like to be able to modify it so the number displays something else, 1-cosmetic, 2 -minor/work around, etc... thanks, aaron Hi Aaron I am having the same problem could you please let me know in steps how to edit the list. Thanks ...Show All

• Visual C# QBE - Query by example tools

  Does anyone know of any good (free) QBE tools that can be integrated into a c# application. I dont really understand your environment and problem. If the information/data is stored in a Database, you can use expressions in the select queries to get a QBE result, for example: SELECT * FROM Documents WHERE title LIKE "%.NET%" Or when it is stored in Html documents for example you can use Xpath expressions to search trought documents and when it is plain text you can use Regex. There are so much options, but I there is no out-of-the-box solution like in ColdFusion for example that offers a full Verity Collections. But even there you need to generate your own expressions. ...Show All

• Visual C++ PostMessage() doesn't work while holding a dialog box

  here is the thing i am using PostMessage() to post several messages to a dialog box from several location this works just fine but when i am holding the dialog - e.g. dragging it - the dialog doesn't feel that a message is being sent i am using PreTranslateMessage() method to filter message so what is wrong with posting message to a dialog that is being hold - dragged - or if there is anything wrong, what is the solution for that thanks alot u guys First of all, avoid overriding PreTranslateMessage. If you really, reall need, and did it it, then take a look in it searching for long, looooong tasks when handling whatever message. ...Show All

• Visual C++ Floating point stack overflow

  My application works fine in VS2003, but in VS2005, it is producing an overflow of the floating point stack.  This seems like it must be a code generation error in the new compiler.  Has anyone else experienced this problem In the particular case I am looking at, I step through the instruction FLDZ in the disassembly window.  Instead of getting a zero in ST(0), I get 1#IND, and the SF and C1 bits are set in the x87 FPU Status Word.  The first time through this code it works OK, but this second time through, the FPU tags register shows that the stack is full before the FLDZ instruction. I hope you will consider a hot fix for this bug, and not wait for a service pack in the middle of 2006.  Of course, I ha ...Show All

• Visual C# ErrorProvider makes default language loosing properties...

  Ok, I have a very weird problem. I have a windows forms with some basic controls in it, textboxes, buttons, labels. with only one tab (very basic). My problem is when I'm switching language, i'm loosing control properties in my default language. Here's the behavious when the errorProvider is in my form. 1- I drop a combobox in my form (in the default language), change the dropdownstyle value to dropdownlist. 2- In the initializecomponent, I can see myComboBox.dropdownstyle = dropdownlist; If i switch to another language (IE: Spanish), I can see the myComboBox.dropdownstyle = dropdownlist again in the initilizecomponent. The problem is when i'm switching back to default language, it is adding the dropdownstyle in the sp ...Show All

• Visual Studio Express Editions Tutorial on adding dataset from access database programatically

  Hi, After moving over the 2005 Express I have always used the Add New Datasource wizard from VC#2005e to add datasets but I have run into some problems sometimes. Could someone please point me to a tutorial on how to add a dataset from an access database the good old fashioned way... programmatically Thanks ! Thanks and sorry for the basic questions. using System.Data.OleDb; I have added all your above code to declare and open the dataset globally, ie: after the public partial class parenthesis. I get all kinds of errors. it does not accept "=" for theOleDbCommand.Connection = new OleDbConnection(... it does not accept "this." in this .theDataAdapter ...Show All