Well, your tips on debugging were good, and I'm sure they will come in handy a lot in the future, but my central question is still a mystery to me. As far as I can tell the code is idential the first time it goes through and the second time. Here's the code again: this.sqlDataAdapter.Fill(dataSet2.tblData); this.dgClaimsExperience.DataSource = this.dataSet2.tblData; this.tabctrlTabControl.Enabled = true; It's crashing on the first line when it goes through the second time. The only other difference is that the CommandText of the sql command gets edited a little bit (so that it's drawing a different set of data from the database the second time around). Any ideas how to work around this? -stormin The ends can never justify the means. It is the means that determine the ends.

I've seen this with the task list and some search results when I have auto hide on the container. I hover over the name and it refuses to expand until I expand one of the other items and click the push pin icon. I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

Something like this should work: DataGridColumnStyle dgcs = MyDataGrid.TableStyles["MyTableName"].GridColumnStyles["MyColumnName"]; MyDataGrid.TableStyles["MyTableName"].GridColumnStyles.Remove(dgcs); It's a little more efficient if you keep a reference to the table style and column style objects that you're using so that they don't have to be looked up each time, but the above code should work.

I do this frequently. UcInfo = new ucInfo(this); // Instantiate the UC UcInfo.Parent = pnl01; // Assign the panel as the UC parent UcInfo.ShowLookup = false; // I have preprossing in the UC that I want executed pnl01.Height = UcInfo.Height + 8; // In this case, I'm adjusting the size of the parent panel to the hieght of the UC UcInfo.Dock = DockStyle.Fill; // Now dock the UC into the panel pnl01.Dock = DockStyle.Top; // Position the panel on the form ... // There can be other preprocessing you might need done on the UC. pnl01.Visible = true; // Now show the panel

If it's a local instance of MSDE, use the following command: osql -E -i filename.sql The -E switch indicates to use Windows authentication, and the -i filename.sql indicates which file contains the statements to run. Run osql /? to see other options. -- LuisR Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog! The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Thanks, I'm downloading it now. Hopefully it will help. The ends can never justify the means. It is the means that determine the ends.

Well, I'm glad I have been able to be of some slight assistance so far. I was happy to see in the other thread (MSDE 2000) some of the same information we've been talking about. So what it looks like you may have to do at this point is try to log in using an administrator password. The default administrator user name is "sa" and the default password is usually blank, "sa", or "password". I hope you changed that during installation, but if you didn't, then you can try one of those suggestions. Once you log in as an administrator, you may want to set up some logins right away, such as the ComputerName\Administrators group with full privileges. I really feel bad for you that you are working with MSDE as your first experience working with SQL Server, because although the engine is great and powerful, there is no graphical help and you have to do everything using SQL Commands. Larger ramp-up time than normal. The good news is there's very comprehensive documentation called SQL Server Books On-Line at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp?frame=true[^] which gives you syntax for all the SQL Queries you could ever wish to do. Let's take a SQL Server Authentication example: Add the login 'SusanH' to the SQL Server instance EXEC sp_addlogin 'SusanH', 'SusanHsPassword' Give 'SusanH' some permissions GRANT CREATE DATABASE, CREATE TABLE TO SusanH Now let's look at a Windows Authentication example: Grant permissions to an existing domain account EXEC sp_grantlogin 'MyDomain\SusanH' -or- EXEC sp_grantlogin 'MyComputerName\SusanH' I'm not completely sure if these are proper samples that will work, however I think you get the idea and can take it from here by looking through the transact-sql reference documentation. They give the syntax for the statements at the top, examples at the bottom, and links to 'see also' topics. Good luck.

The @@identity method is absolutely safe. The value returned is the identity of the record last created within the same database session, e.g. with the same database connection. If two users create a record each at exactly the same time, they still have separate database sessions, so the id returned to each user is the id of the record that that specific user created. --- b { font-weight: normal; }

What's it look like in your browser, in FF1.06 and IE6 the area is tiled with a letter image. Anyone else seeing the same?

If you use the class in asp.net, or from more than one program running at the same time, there will be more than one thread using the same class. If you have a static reference in the class that is not thread static, it will be shared by every thread that uses the class. That means that when one program connects to a database, and then another program connects to a second database, both programs will be using the second database. Also when one program closes the connection, the other program will stop working. --- b { font-weight: normal; }

Maybe you are forgetting to set the connection string in the OleDbConnection object. -- LuisR Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog!

Thanks for responding. I ran the debugger and double-checke that the theParent object is not empty. It's not. The value I get for it is: Benefit_Select_Application.frmCostTracker frmSetupNewCostTracker01.theParent Trying to track down the problem I also tried adding the line: MessageBox.Show(theParent.hasSetupCostTracker.ToString()); in the cancel button method to see if I could at least access the value of the hasCostTracker variable. I got this error: Cannot pass 'Benefit_Select_Application.frmCostTracker.hasSetupCostTracker' as ref or out, because 'Benefit_Select_Application.frmCostTracker.hasSetupCostTracker' is a marshal-by-reference class I have no idea what a "marshal-by-refernce" class is. OK - while I was typing this message I tried something else, and now it works. I copied the line from the constructor (theParent = (frmCostTracker)this.MdiParent;) into the cancel button method. So now it works. But I'm still curious, do you know why the exact same code successfully initializes the reference in the cancel_button method but not in the constructor (there's only 1 constructor). Thanks for your help. The ends can never justify the means. It is the means that determine the ends.