You can even enforce data integrity using the Unique Constraint and Foreign Key Constraint objects.
The simple example below uses only one table, but you can use multiple tables from different sources if you need them.
Or is there a way to update the database table using the "update query statement" again the point is how to write the update statement for any value changes in the data grid view ?
I am using Sql Data Adapter to update my data Table which I had queried from Database in another method and in that method there were columns, Status and Is_processed which were updated. See https://msdn.microsoft.com/es-es/library/datarowstate(v=vs.110)for possible states. After filling the Data Table you can call Data Table.
You can create your own unique views of a database using Data Set.
Relate Data Table objects to each other with Data Relation objects.
Thanks, Rich I think I figured this out (because I finally got it to work). NET application by specifying command syntax at design-time and, where possible, through the use of stored procedures.You must explicitly set the commands before calling Update.I have the below code where I'm trying to update a database from the c# grid view change made in windows application.... Could anyone point me in the right direction to solve this issue ? I presume there might be an issue with binding and the select command statements...