As you proceed, remember that updating data is not the same process as entering new data.
For information about entering new data in a database, see the article Add one or more records to a database.
Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.
Large updates become much easier to perform when you understand some of the basic principles of database design.
In my previous tutorials, I’d explained about how to bind data to gridview, how to get connection string, gridview inline insert update delete, difference between executereader executenonquery executescalar and other more cracking tutorials on Grid View, Asp.net, SQL Server here.
To explain further about how to bind data in gridview and perform insert update and delete operations, we need to create database table to read data and bind retrieved resultset to gridview, so simply execute following script to sql query editor to create database table and then add few records manually or download complete example code with script at the end of the page. Best practice is to use parameterized query to perform select, insert, update or delete operations instead simple sql statements.
Remember these facts about database objects and design as you proceed.When you design a database table, you select a data type for each of the fields in that table, a process that helps ensure more accurate data entry.