Database Table Update in a DataGridView without Writing Code

Sign in to leave a comment.

• GF

  Gordon Freeman9y agoPosted May 28, 2017, 3:43 AM

  Please, show us the content of the DoSave() method
• 

  Hashim Shafiq11y agoPosted Aug 21, 2015, 10:17 PM

  Nice
• EM

  edelawit mekonen15y agoPosted Feb 18, 2011, 2:45 AM

  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 agoPosted Feb 18, 2011, 3:39 AM

    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.
• BF

  Becky Finley16y agoeditedPosted May 18, 2010, 5:39 PMEdited May 18, 2010, 5:40 PM

  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!
  • BF

    Becky Finley16y agoPosted Aug 3, 2010, 11:51 AM

    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!
  • BF

    Becky Finley16y agoPosted May 19, 2010, 7:48 AM

    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 agoPosted May 18, 2010, 9:37 PM

    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.
• AA

  ahmed ali16y agoPosted Apr 1, 2010, 11:41 AM

  Oh ! dear, thank you very much.