NET 2.0 introduced a number of new Web controls designed for accessing and modifying data. NET 2.0's data source controls make it possible to retrieve, insert, update, and delete data without having to write the tedious dedata access code that was so commonplace in ASP. Previous installments of this article series have looked at returning, inserting, and deleting data using the Sql Data Source control. These controls can work in unison with the data source controls to facilitate inserting, updating, and deleting data.These controls allow page developers to declaratively access and modify data without writing any code to perform the data access. In this article we will examine basics of using the Sql Data Source and Grid View controls to update records from a database.
Open your instance of Visual Studio 2012, and create a new ASP. Name the project “MYSQLCRUDApplication ", as shown in the following figure: In the code behind file (cs) write the code as in the following. Now, enter the student data insert and Grid view Show Data. Now, select the Student then show the data Text Box and update the data shown in the Message box “Student Data update successfully”.
Now, delete the Student data shown in the Message box “Student Data Delete Successfully”. If you have any other questions then please provide your comments below.
The Edit button disappears and in its place Update and Cancel buttons appear.
Furthermore, the columns in the Grid View become editable, too.
In this article we will look at using the Grid View control to update data, although the Data List, Details View, and Form View controls are also suitable choices.