Jeremy Balliston's Q&A profile

• Visual Basic Best method for exporting a DataGridView to Excel

  I have a datagridview(DGV) which contains data based on a user selections from a pre-defined dataset In point form: User starts program program builds datatable user opens file and program read all data from file into the dataset.datatable user defines the data they want to see program displays datagrid based on dataset.datatable and user choices. (basically it displays the whole dataset and removes unwanted columns\records) I want to be able to export the datagrid to excel (not sure which method yet). I have tried the excelexporter component i found somewhere on the msdn forums (it exports the data to look exactly like ...Show All

• Windows Forms Dbl click btw rows in grid?

  Hi, Some time double click between rows on data grid cause UnHandeled exceptions. Any body experianced this  How could avoid/ignore that Can you catch Application.ThreadException or AppDomain.UnhandledException  ...Show All

• SQL Server Cannot connect to a named instance of SQL 2000 or 2005

  Hi, I am struggling connection to a named instance of SQL 2000 (SP4) from another machine but without any success. I get an error message saying that the server does not exist or access is denied .   The security configuration in this named instance is the same as the default instance (also 2000) and the remote machine can connect to it successfully.   I also configured the aliases in Client Network Utility in the client machine and set the server (machine) name and the port number used by the instance - but no help.   I use osql and Query Analyzer to connect to it, but I cannot connect by any o ...Show All

• Windows Forms Combobox multiple columns

  Is there a way to display multiple columns in a combobox (like access) Thanks   ThE_lOtUs wrote: http://www.google.com/search hl=en&lr=&q=vb.net+multiple+columns+in+a+combobox Check the first link http://www.codeproject.com/vb/net/multicolumncombo.asp :) Those are ok, but when you inherrit from textbox en use a captionles form (in this case with a Datagrid) as editor you can make any kind of combobox-ish kind of controls. I did something simular and worked great ...Show All

• Visual Studio Error 1402 Installing VS 2005

  am getting the error "Error 1402 could not open HKEY_LOCAL_MACHINE \Software\Classes\Interface\... \ProxyStubClsId. Verify that you have sufficient access to that key, or contact your support personnel. My UserId has admin rights so I don't think that access rights are the problem. Logged under the local admin account and tried again. Same error. Someone posted that there could be installation problems if the organization name was left blank during installation. This was in fact the case. Changed this using regedit, but this didn't help. Same error. Please help! Error Log is below: [04/28/06,15:13:37] Microsoft Visual ...Show All

• Visual Basic Webbrowser_OnNewWindow - e.cancel event help needed

  Hi, I am having trouble with using the NewWindow part of the webbrowser control. What i need my program to do is refresh webbrowser.refresh the website once an open popup window is closed. First i managed to use the NewWindow event to enable a timer which attempted to check if the window was still there but i dont know how to use the e.close Event Arguments from Webbrowser_OnNewWindow in the timer_tick event. Any suggestions Thanks in advance, Shadow ...Show All

• Visual C# Is it possible to serialize to XML with comments?

  Topic says it all pretty much. I simply want my xml-serialized objects to have comments in the XML, so that a user glancing at the XML knows whats what. Something like this: < xml version="1.0" encoding="utf-8" > <Settings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <!-- Various user information --> <UserInformation> <Name>John Doe</Name> <Address>1234 Nowhere Blvd.</Address> <!-- Direct relatives, just a simple comment --> <Children> <ChildName>Jane Doe</ChildName&g ...Show All

• SQL Server Recover SDF-File

  Hi, we're using SQL Server CE 2.0 on our CE 4.2 device (mobile scanning device). In some cases, the application freezes and the user must perfom a cold boot. After the cold boot, the database is some kind of corrupt - the application can't build up a new connection and a "Fatal Applicatio Error ...." is thrown. If you try to connect to that SDF-File via the Query Analyser Tool, it also throws an exception .... "DBInitiliaze".... Do have anyone an idea whats wrong with the SDF-File and more important: How could we recover such files - most times there is already business data stored, which would be than lost... Thanks WilliBald ...Show All

• Visual C# Decode URL string in C# (not ASP.Net)

  Hi, I'm writing a program in C# 2.0 and I enable people to drag and drop a file link from the browser to my program and my program downloads the file. The problem is that the file URL string is encoded (ie some characters are encoded to %num). I want to decode this chars to normal chars. In ASP I saw there is an option to do it, but on regular program I couldn't find how to do it. string s = "%49%20%64%6F%6E%27%74%20%6B%6E%6F%77%20%77%68" ; s += "%6F%20%69%73%20%6D%6F%72%65%20%69%67%6E%6F%72%61%6E" ; s += "%74%20%2D%20%47%65%6F%72%67%65%20%42%75%73%68%20%6F" ; s += &quo ...Show All

• Visual C# How can I convert string representation of Color object to Color object

  I try to save Color object in my App.config file. I write Color.ToString() to config file, but how can I convert loaded color to Color object You can use Color.FromName() if your color always one of the named colors. You can also save int (Color.ToArgb()) and load from int (Color.FromArgb()). Also you can try ColorCoverter class to convert from string to color. ...Show All

• Windows Forms ListView Question

  Hi folks. I've been playing around with ListView's for the first time and I'm having troubles getting my head around ListViewSubItems. Basically, I'm wondering if there's any way to add and/or change a sub-item by just specifying it's column and row numbers listView1.Items[Row].SubItems[Column] Will give you the ListViewSubItem at row/column. Keep in mind that the SubItems[0] actually is ListViewItem itself. To add you will have to do it in the order you want them to appear. listView1.Items.Add("Row1"); listView1.Items[0].SubItems.Add("Sub item 1.1"); listView1.Items.Add(&quo ...Show All

• Visual C++ XML Documentation /doc option

  The title of my post is broader than this specific question, but I'd thought I'd make this a general thread about this topic. My issue: I'm getting warning c4633 when I try to use the <param> tag in an XML comment on main(argc, argv). Apparently, the compiler is trying to match my parameter (argc) to one in a different main function. I am doing this with the simplest possible program: ///<param name="argc">a count</param> int main(int argc, char* argv[]) {return 0;} and I get this warning: warning C4633: XML document comment applied to 'main(System.Int32,System.SByte!System.Runtime.CompilerServices.IsSignUnspecifiedByte**) ...Show All

• Visual C++ arrow, delete and number keys don't respond.....

  Using VS2005 C++ beta 2 every now and then I can't use my delete, backspace, arrow keys or my side number pad while working in the VS enviornment.  I thought that I might have lost focus but the carret is still blinking where I was last at, and if I type the numbers or letters on my main keyboard then I can do things...  The worse is I can't delete.  At first I thought this was just in debug mode but it now started happening while just coding.  I can't tell you what I do to make it stop... usually I do build or do a rebuild or even shut down VS and reopen it. I had the same problem in 2003 but none of the above sug ...Show All

• Visual Studio Express Editions Whats going wrong here?

  Hi Folks, Could someone please take a look at : http://pastebin.com/657314 I am not sure what I am doing wrong. All the errors and code are their. Thanks -Al On this line vtElevationGrid::LoadFromASC("C:\\Documents and Settings\\Al\\My Documents\\FLIR Targetting\\gx20tm.asc" , ); At the end there is a comma , before ) Either you should not have the comma there or you should have something behind it if a second parameter is required. ...Show All

• Smart Device Development .NET Studio 2005 and Windows Mobile for Smartphone 2003 SE

  I have been looking around a bit, and fiddling on Visual Studio 2005 and I have had no success yet. Is there a way to make an application that is solely compatible with Windows Mobile for Smartphone 2003 SE using VB .NET 2005 Just wondering since I know VB .NET 2005 is .NET 2.0 and I think Smartphone 2003SE is .NET 1.0 compatible. Any help on the matter would be greatly appreciated. (had none of these problems of .NET compatibility when I was back using embedded visual tools 3.0 back in the old days ) Yes, by choosing Smart Phone 2003 project type. VS 2005 supports development for both NETCF V1 (SP and PPC only) and V2. Please m ...Show All