Database Table Update in a DataGridView without Writing Code

Sam Hobbs

The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: Database Table Update in a DataGridView without Writing Code

DataGridViewDatabase Table Update

9 Comments

Join the conversation! Your thoughts help the community grow.

Gordon Freeman9y ago
Please, show us the content of the DoSave() method
Hashim Shafiq11y ago
Nice
edelawit mekonen15y ago
i tried to delete a row and then save the change to the database after following your steps and creating all the things but i keep on getting this error .... "Update requires a valid DeleteCommand when passed DataRow collection with deleted rows." Is there anything i've missed? cuz i've tried it in a different way but the delete function doesn't work either way... please help
- Sam Hobbs15y ago
  Your data source has a query that is not simple so it is unable to generate a delete command. This is normal for queries such as a join where two tables are joined. You just need to supply a delete command.
Becky Finley16y agoedited
Hello! I've read your very helpful article and followed it step by step just as I've been doing for days now, but still my datagrid will not allow editing when it is deployed on my device. I'm using Merge Replication from the SQL Server 2008 to SQL CE 3.5 SP1 running on my Visual Studio C# coded app on the Emulator. I get the Server data displayed in the datagrid on the Device successfully, that is not a problem. But there is no way to edit it, and no empty row to add new data. Oddly enough, I'm missing the BindingNavigator and TableManager, however I do get the Datagrid on the form and underneath it there is "mainMenu", "sQL_CE_DATABASEDataSet", BindingSource, TableAdapter, and sQLCEDATABASEDataSetBindingSource. Why do you think I'm missing the BindingNavigator, and what could I be doing incorrectly? Thanks!
- Becky Finley16y ago
  BTW, I found out what the problem was. I'm creating a Smart Device App, not a Windows Form. I had later found out (hard to find info) that Smart Device Apps do not support the Navigator Bar; you have to code your own controls, basically. THATS what the problem was! Thank you for your response and help!
- Becky Finley16y ago
  That could be it, I've certainly been bouncing around in this app trying to make it work for awhile, and even using more than one DataSource for testing. I'll start a new project today and work with that. Thank You!
- Sam Hobbs16y ago
  Hello, Becky. I cannot be sure what the problem is but I will guess. I hope this helps someone, even if this is not relevant to you. The IDE supports only one navigation bar per form. You can add more navigation bars but if you add a bound control using the IDE in the manner I describe, it will only create one navigation bar. My guess is that you added a DataGridView then deleted it then added another one. The IDE probably got confused; eventhough there is only one bound control, it thinks there is more than one and did not create the navigation bar again. I am not sure what the solution is but I hope that by understanding what is happening you can fix it.
ahmed ali16y ago
Oh ! dear, thank you very much.