Open(); Sql Data Adapter da = new Sql Data Adapter(sql Select, conn); Data Set ds = new Data Set(); // define update logic for the data adapter // load data from the data source into the Data Set da. Fill(ds, "Orders"); // start the transaction Sql Transaction tran = conn. It can be used to fill the Data Set and update the data source.String conn String = "Data Source=(local); Integrated security=SSPI;" "Initial Catalog=Northwind;"; String sql Select = "SELECT * FROM Orders"; Sql Connection conn = new Sql Connection(conn String); conn. Begin Transaction(); // associate transaction with command builder command objects cb. Finally, the statement is added to a // Namespaces, variables, and constants using System; using System. Ensure that strings, dates, and any other fields are properly delimited when values are substituted for parameter names in the , the solution remains fundamentally the same if you use your own custom updating logic.
The My SQLData Adapter also includes the Select Command, Insert Command, Delete Command, Update Command, and Table Mappings properties to facilitate the loading and updating of data.
Please be aware that the Data Column class allows only Int16, Int32, and Int64 to have the Auto Increment property set.
If you plan to use autoincremement columns with My SQL, you should consider using signed integer columns.
In the main form, i have a Data Grid View which binded to a Data Set.
So i can make changes to the customer details, and when i press save, it changes the value in the datagridview of the main form manually, like this I've tried many ways, using the update Command, parameter method, and also the Updatecommand with the hardcoded SQL string method.