Update Dataset from SQL Server
-
I have an application that loads a dataset into a drop down menu in a DataGridView. Separately you can add or remove information from the SQL server that the dataset is populated from. How do I update the dataset once the program is already running? (Assuming I have added information to the SQL table) I have played around, and it seems that the dataset may be complied when the app starts, I could be wrong. Any thoughts are appreciated, Adam
--Its not broken if it never worked.
-
I have an application that loads a dataset into a drop down menu in a DataGridView. Separately you can add or remove information from the SQL server that the dataset is populated from. How do I update the dataset once the program is already running? (Assuming I have added information to the SQL table) I have played around, and it seems that the dataset may be complied when the app starts, I could be wrong. Any thoughts are appreciated, Adam
--Its not broken if it never worked.
There must be some code that initially loads the dataset. You should figure out where that is. Once you have, you can call this code from somewhere else in your application to reload it.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
-
There must be some code that initially loads the dataset. You should figure out where that is. Once you have, you can call this code from somewhere else in your application to reload it.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
Yeah.... The DataGridView allows you to select the dataset in the "properties" window, and doesn't allow you access to the code behind it.. at least that I can find. I've tried all the datagridview.load .update and dataset.load .update combinations that I can think of, but none seem to have an effect. The program doesn't lock up, it just doesn't update the dataset.
--Its not broken if it never worked.