gpai's Q&A profile

• Smart Device Development SqlCeCommand

  I am having trouble getting a paramatized query to work. I can't seem to get the syntax right to get the correct result. If I leave out the WHERE clause it sums the whole table, but after i add it I get a null answer. SqlCeConnection conn = new SqlCeConnection ( "Data Source =FB7MobileDB.sdf;" ); conn.Open(); //SqlCeCommand cmd = new SqlCeCommand("SELECT SUM(Amount) FROM LineItem WHERE (LineItem.InvNum = @invnum)", conn);+ SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT SUM(Amount) FROM LineItem WHERE (LineItem.InvNum = @invnum)" ; SqlCeParameter param = null ; ...Show All

• SQL Server Does 'SELECT INTO' not work in SQL Mobile?

  I'm trying to programmatically create a new table that is a copy of another. The SQL statement I'm making is: "SELECT * INTO sensor_stream_temp FROM sensor_stream" and various combinations thereof (such as specifying the columns, etc) The error I keep getting is: There was an error parsing the query. [Token line number 1, Token line offset 10, , Token in error = INTO ] Is it not possible to copy a table using this statement *sigh* Thanks in advance for any help. -Dana OK, so it looks like "INTO" is not allowed in SQL Mobile; how do I make a copy of a table ...Show All

• Visual C# Help - how to create a minifest file for DLL assembly

  Hello, Does anyone have the experience of creating a minifest file for dll managed assembly All the information that I could find are for executables, for example, app.exe.manifest. But I need to create one for dll so that my dll can load the correct version of dependent assemblies. Thanks in advance You can try doing manifest injection like David mentioned. Here's a tutorial on how to do it. http://www.codeproject.com/dotnet/ManifestInjection.asp http://www.codeproject.com/dotnet/ManifestInjection2.asp Although it's doing it for an exe file, you should be able to do it for a dll file. Hope that helps. ...Show All

• SQL Server Reporting Service design for SOA based application

  ALL, I have a specific query around the implementation that I have in my application, details below-   I have modules in our application which are implemented as service , each   (applying SOA principle) and each have their own database.   There is some reporting functionality in each of the modules and we have architectural principle guideline not to make cross service database calls from a module, all the cross database calls should be made through service only.   Let's say database and service communicate as below-   Module A service talks to Database A only (to talk to Database B; Modul ...Show All

• Visual FoxPro Need experts opinion VFP 9.0 multiuser network app.

  Hi   We have hired a programmer to help me get up to speed on FoxPro 9.0. We are designing a replacement app for our old Clipper based DOS app. We have run into a problem and I would like a few opinons from you experts to see if we are on the right track.   This app will be based on a foxpro 9.0 database located on our LAN. It will have multiple users accessing it at the same time.   The general way we were setting up our client section is as follows.   There is a client form that has a list box that pulls in all records from our foxpro database client table. There is also a search box to locate all records that match ...Show All

• Visual Studio Adding nested types

  I'll like to add nested types within the class designer, how can I do that I found a reference to an add-in (PowerToys) but that's build for Beta2 ( http://www.gotdotnet.com/workspaces/workspace.aspx id=fe72608b-2b28-4cc1-9866-ea6f805f45f3 ), any updates for final release date for this add-in Thanks FYI - the PowerToys add-ins have been updated to work with VS 2005 RTM. You can find the updated version at this location: FYI - a new build of the PowerToys which works with Visual Studio 2005 final product release is now available from http://www.gotdotnet.com/workspaces/workspace.aspx id=fe72608b-2b28-4cc1-98 ...Show All

• Visual Basic Update SQL Table VS2005 VB.NET

  Hi All, I have been messing with some basic vs2005 apps... im having trouble updating a table however. Is it possible you can help me I have a form with a cbo binded to a dataset that I have. I use this to populate a couple of text box's on the form. If I make an edit and try to update the table using this code: Private Sub btnSave_Click( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles btnSave.Click Me .CustomerTableAdapter.Update(DsCustBasic.Customer) Me .DsCustBasic.AcceptChanges() End Sub   The dataset appears to change while the app is live, however I cant seem to actually write th ...Show All

• Visual Studio Team System Why ClassInitialize functions need to be static.

  I'm working in C++.  I'm not sure I understand how the XXXInitialize/Clean attribute is supposed to work. The ClassInitialize method is called before the class is created (the function need to be static).  The TestInitialize is called before each tests.  I need a way to Initialize/Cleanup class member.  When I tried to put this initilization in the class constructor, I discovered the constructor was called many time ( ).  The desctuctor is also never called, so I don't have a way to do clean up. This mean (if I understand well), I'll have to use static variable (ouch!) inside my class if I want to initialize it.&nbs ...Show All

• Visual C++ need help with wchar_t and chars

  UnregisterClass( "D3D Tutorial" , wc.hInstance ); I get the following error: .\Main.cpp(140) : error C2664: 'UnregisterClassW' : cannot convert parameter 1 from 'const char [13]' to 'LPCWSTR' Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast How Should i fix this Define it as a unicode code string. Prefix with L UnregisterClass( L "D3D Tutorial" , wc.hInstance ); Read more about MBCS and UNICODE and try to understand the difference. Read http://msdn2.microsoft.com/en-us/library/c426s321(en-us,VS.80).aspx ...Show All

• Visual Basic Write Games

  Can you write real 3D games with Visual Basic Can you write real 3D games with Visual Basic Absolutely! In fact, two of the developers on the Visual Basic team wrote a very cool multi-player tank battle game towards the end of the VS2002 product cycle to test the product out, which used 3D graphics extensively. Add a reference to the DirectX type library or GDI+ (I humbly suggest the former :-)), and you’re all set to start coding in 3D. Good luck! --Matt Gertz--* VS Compiler Dev Lead ...Show All

• Visual Studio Team System How to reuse a previous TS data server with a new TS application server?

  I have rebuilt the TS application server because it did not install correctly the first time.  My plan was to reuse the TS data server, but I get the following message when trying to install the TS application tier: "Setup has detected existing Team Foundation database on the specified machine.  The specified machine may already be configured to work with another Team Foundation application tier.  If you are trying to reinstall TFS please refer to the accompanying documentation on how to reuse this machine." Where or what file(s) contain the "accompanying documentation" on how to reuse the previous TS data server with my ...Show All

• Software Development for Windows Vista Question on <Glyphs> element

  Hi,    Was going throught the XPS specification. Noticed that the <Glyph> element can have a Fill attribute, but not a Stroke attribute. Also noticed that there is a <Glyphs.Fill> element. Wonder why stroke is missing for a <Glyphs> element. However did see that <Path> has both stroke and Fill attributes as well as the corresponding <Path.Fill> and <Path.Stroke> elements. Any reason stroking was omitted for <Glyphs> Please clarify. Version 1 of WPF does not support stroked Glyphs. The omission from XPS is intentional. Future versions may add this f ...Show All

• Windows Forms DataGridView doesn't refresh when calling refresh multiple times

  Hi everyone, I have a big problem with the datagrid, in an optionsdialog I change the grid.RowTemplate.RowHeight property. After changing I call the grid.Refresh() method. This works normal, the grid get's invalidated and refreshes it's layout. Now the problem occurs when the user opens the optionsdialog again, when he changes the RowHeight property again. the grid doesn't refresh anymore, you see it flickering but it stays the same. When I check the property on the grid, it is set correctly! Looks like a big bug in the DataGridView! Of course I could unbind and rebind again, this works. But it's not an option for me because I lose Column s ...Show All

• Visual C# net mail namespace and SMTP

  I know that this has been asked before, but I've tried all the answers and haven't found the answer yet. I'm trying to send email using C#. My code works great on my local machine - no problems.  But when I publish to my 2003 server, it won't send.  There are no errors, all the other scripts execute ok, but the email doesn't come through. Here's my code =====================         MailMessage mail = new MailMessage();         mail.From = new MailAddress(this.tbEmail.Text);         mail.To.Add("myemail@myhos ...Show All

• Visual Basic Browse button OpenDialog to TextBox

  I am putting together a WinForm VB.Net application in Visual Studio 2005 and on two forms I need to allow the user to click a "browse" button, choose a file, and have that file name fill the textbox upon the user clicking "open" from the dialog box. I can add the opendialog to the btnClick, open the dialog box and set the properties for a specific file type, but can't seem to get the file name moved to the text box. I have one form, txtFileName, btnBrowse, and that's it. Thank you!! Hi, Use this code : Dim TempOpenFileDialog As New OpenFileDialog 'Set TempOpenFileDialog prop ...Show All