Glen Bartlett's Q&A profile

• SQL Server Backup databases programatically.

  Hello 1. Sql Express supports SMO 2. If so How can I make a backup of a database programatically Thanks I found how do it.  but still waiting for the other answers. Its so easy, I love Microsoft Tools. using Microsoft.SqlServer.Management.Smo; namespace SMOTest {     class Program     {      static void Main()      {       Server svr = new Server();       Backup bkp = new Backup();       bkp.Action = BackupActionType.Database;       bkp.Database = "Adventur ...Show All

• 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

• Windows Forms GridView Collapsable view

  I'm looking for information on how to customize a control like the gridview to be collapsable by groups.  For example you can do just that with outlook 2003.  However I want to be able to do that with the Grid just so.  I'm not exactly sure where to start and I'm hoping someone would have a good starting point for me to look&nb ...Show All

• Smart Device Development Compact .NET, Windows.Forms.Button and MouseDown event?

  I'm right now evaluating the use of Windows CE and .NET Compact Framework (C#) for an industrial application (HMI) at my company. The development environment in general seems very nice (and especially, not to complicated - I personally have experience of programming, but the rest of the company doesn't, and the application should still be maintainable if I leave...). There is a big but, however. The Windows.Forms.Button class doesn't implement the MouseDown and MouseUp events. The functionality of "momentary" buttons is for us a must (ie buttons which activate some function only when depressed). For normal .NET environments (I s ...Show All

• Windows Forms Deployment identity does not match the description

  Hi, I have a ClickOnce project that had been working fine for several deployed versions. At some point something happened and I began getting errors when I tried to publish -- "Cannot publish because a project failed to build" (even though there were no build errors). and "SignTool reported an error 'Keyset does not exist.'" I couldn't resolve these issues, so I created a new project and imported the forms, classes, reports, etc. It works okay and will publish fine, but if I publish it to the original location, when a user runs the program and it tries to upgrade to the new version, they get "The deployment ide ...Show All

• Smart Device Development How to Display Modal Dialog?

  Basically, I have a fairly straightforward question. How to display a modal dialog form and then return to the calling form. Most of my experience to date is with VB6 and I'm probably just going about this the wrong way. I'm using the following code to display a Help|About dialog from a menu click. Fairly standard. private void mnuAbout_Click( object sender, EventArgs e) {    frmAbout frm = new frmAbout();    frm.ShowDialog(); } I'm assuming that the ShowDialog is modal, and that's how it differs fom the Show method. Maybe I'm all wrong about this. Anyway here's what happens. The About dialog appears, and when ...Show All

• Visual C# Visual C# beta 1 crashing - help please

  Hello everyone! Im a newcomer to .NET and C# and recently (about a month back) I had started using visual C# express edition 2005 beta . It worked just fine uptil about a couple of days ago. Two days ago, I started vc# express and chose 'New Windows Application' under File->New->Project. (1)Now, earlier this would have meant that the design view would have showed up. However,now vc# just opens a new project,displays the property window for the new project's form and does NOT display the form at all . If I choose form1->designer view , then vc# crashes with the following message- "An error report is being collected.This could take s ...Show All

• Windows Forms I need help with ClickOnce

  Hello, I have some general questions about ClickOnce. Before VS2005 I used ZeroDeployment under .NET Framework 1.1! Our customers liked the way of central installation on a server. Now, with ClickOnce, I published my Application in a local directory on my laptop. Then I added the published files to an Setup Project. When I now install this Setup on a customer server and I start the Setup.exe from a client, I get the error message, that the location \\xyz\Click Once could not be found. Can I use the ClickOnce in this way, or do I have to return to the normal MSI way Thx for help John John, ...Show All

• Visual Studio Express Editions what is visual basic???

  what is visual basic what is his work in windows, what you can do with it Sorry if the question sounds stupid, but i realy don't know! http://en.wikipedia.org/wiki/Visual_basic Hey Blair.... Thanks for the Cool Definition...... We are where we Come From...... Sometimes Good.... Sometimes Bad.... Cheers ...Show All

• SQL Server Snapshot agent can not connect to distributor

  I'm trying to set up merge replication between SqlServer 2000 and SqlMobile 2005. When I create the publication, I select merge replication for SqlServer CE. When I view the status of the snapshot agent, the error message is "the process could not connect to Distributor. The step failed". I've verified both SqlServer and SqlServer Agent are running under the same domain account (with admin access to the server). This domain account has full access to the snapshot shared folder. I've also run "exec sp_helpserver", which gives me the server name for both the name and network_name fields where id=0. I'm able to success ...Show All

• Visual Basic Windows Positioning on distributed software

  I noticed that when I complie an application and distribute it to my fans (My Family :) That the windows display differently depending upon the screen resolution of the client computer. Is there a property besides the center property of the form that I can use to assure that the program will look the same on all computers. A third party add-on, or something I'm over looking in the property settings of the form. Thanks in advance again.... ..Eric Your question is a little too generic, so if you can clarify a little bit that would be great.  In the meantime, here are some suggestions (I ...Show All

• SQL Server which one is better to use? (@@rowcount or using Exists)

  Hi all, I'm just wondering which one is better to use in stored procedure. Thanks (A) IF EXISTS( SELECT top 1 Country FROM tablename WHERE Country = @inCountry ) OR (B) SELECT top 1 Country FROM tablename WHERE Country = @inCountry IF @@rowcount<>0 There's no comparison between the two -- if you want to select the data back to the client then use the latter.  Otherwise, use some form of the former.  Note, I prefer not to use TOP or a column name, e.g.:   IF EXISTS( SELECT   * FROM tablename ...Show All

• .NET Development Convert from byte array to float...

  I have a 32 bit float represented by four bytes and I need to convert it to a float type, how   Thanks,   Devin thanks guys, that's neat to see thos examples as I will use at least two of them in the near future. ...Show All

• Visual C++ installer

  I have made a little application in visual C++ 2005 beta 2, and I want to use it on other computers, where visual C++ isn't installed. how can I make an installer of my application The way it used to be done in previous versions of visual studio don't seem to be implemented anymore. You can use WIX ( http://sourceforge.net/projects/wix/ ).  It lets you author setup programs in XML and is relatively easy to use. Hope this helps, -Ron Pihlgren  VC++ Testing ...Show All

• .NET Development Retrieving Units of Measure in use

  How do I determine whether the user is in a metric locale or inches locale The CultureInfo objects do not seem to have this property. Besides millimeters and inches, are there any other types used Thanks in advance. Interesting. Don't see how I missed that one. Oh well nevertheless given that it is there we can reverse engineer back to the underlying Windows API and sure enough you can get it through the GetLocaleInfo function. Fortunately however there is a .NET equivalent mechanism. The RegionInfo class has a property called IsMetric that will tell you. RegionInfo.CurrentRegion.IsMetric Ca ...Show All