Luc, That did it. All I did was place lstTbls.DataSource = Nothing at the top of the subroutine. So whenever I changed databases it will disconnect the datasource, then clear the list box, and reconnect the datasource and repopulate the listbox. Thanks this helped a bunch. Quecumber256

Maximilien, Either they are "clueless" or greedy. Let us face a simple fact. My internet browser lets me block pop-ups and it is done using some type of software. It should be simple to block a piggybacked signal. If this keeps up I will start watching all my programs over the internet. This offers me two benefits: 1 - Limited commercials. 2 - No pop-up advertisements at the start or continuation of a program. Thanks for the reply, Quecumber256

I was afraid of that.

Quecumber256 wrote: How come I can't convert the intger 10 to string '10' using the ToString function provided by the .NET framwork? Good question why you can't. Your C# code works just fine for me. C# Discussion Board[^] Mark Salsbery Microsoft MVP - Visual C++ :java:

Well, actually your number is accurate, expressing the wrong physical quantity. :-D If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile. This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke [My articles]

Hi Dave: Thanks for the input. The experiment I'm running uses a 50 point font, which in turn produces an image large enough to know you are clicking on the character itself. The bitmap approch did occur to me as a possible solution, but considering the work involved producing 255 bitmaps, one for each ANSI character it didn't seem like it would be practical. Obviously there is a fundimental difference between shapes drawn using GDI+ and how GDI+ handles fonts. There has got to be some method out there that will allow me to capture the font, but so far my searches have produced ziltch. Quecumber256

Has a google search brought anything up? "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Dave: Thank you. I have had some discussions with our .NET developer here at the office and he put some things in perspective for me. For example: I drew a square on the windows form. That would be level 1. Next I drew a circle on top of the square, this is level 2. So if I click on the circle I have to have some routine that looks at the levels and sees where the cursor is pointing, which level it is on, and then place some kind of "visual handlers" around the object then use another routine to move it on the form. This helps me grasp the concept of what I'm trying to accomplish. Do you have any recommendations for books that cover graphics manipulation and programming for VB .NET? Thank you, Quecumber256

Bind the data source to the navigator control, then bind your textboxes and labels to the individual fields :-D "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Thank you for reassuring me I wasn't a dummy :-). I attached the entire form class just in case there was an issue with the data binding portion or something else. I have one other resource looking it over. If he can't find the problem then I'm being forced to use one of my complementry support intances. Thank you, Quecumber256

Cleako: I'm not sure if I understand you. The current method is the New_Binding subroutine I had at the beginning of the post. Do you want the whole form class? Code and all? Thanks, Quecumber256

Ok now knowing that you want to run this app disconnected. Your idea of the negative auto increment doesn't solve all your problems since I would assume you would have more then one person that would want to run the app disconnect. Now you would have two applications that both assigned -1 to a new row, you would still have the same problem. If you truely want to run the app disconnected, it doesn't matter what the id is in your app when it is disconnected, what matter is when the app syncs with the live database what do you do to get the correct ids. Again I think you are approaching this problem the wrong way. Focus on writing a stored procedure that inserts a new row in to the sql server. Then write your routine to use it when connected and to use some other stored procedure that syncs up the changes that would also use this insert stored procedure. Ben

On the UI form I bound the four textboxes to the four columns in the dataset. txtID is bound to RecID, txtOrdinal is bound to column Ordinal, txtCode is bound to column Code, and txtName is bound to column Name. This way when I navigate through the dataset I know which record I'm looking at. I read an artical this morning about setting the DataSet Autoincrement to -1 and 0. This is suppose to insure that the ID#'s differ between records added and records that were retrieve from the database. If I add new records using a negitive auto increment and records that are read into the dataset from a database will have positive increments it should take care of my overwrite and record disjunction problems. Thanks, Quecumber256

All you have to do is read the documentation on DataSet.GetChanges()[^]. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Thank you. I going to see if I can adapt it for my use. Quecumber256

I don't think that will be a problem with this particular application. This application is just a tool to help the administrator with data management. For-what-its-worth: Here is the T-SQL script for the table I'm having trouble with. CREATE TABLE Tool_Dev.dbo.tblBindings ([BindingId] INT IDENTITY (1,1) PRIMARY KEY, [BindingCode] CHAR(4) NOT NULL, [Ordinal] INT NOT NULL, [BindingName] VARCHAR(50) NOT NULL) Thanks, Quecumber256