How to insert,Update and Delete data using datagridview in. Editing, Updating and Deleting. • In Delete button click event Deleting the selected row. Updating, Deleting records using GridView. This article scope is limited to Updating and Deleting records using GridView and I am not. Editing GridView. Rolling Patch Oracle Data Guard.

I'll bind the GridView control with a database table using SqlDataSource. Meanwhile, you can go through the below link for an overview of how data binding is done using SqlDataSource.

Start Microsoft Visual Studio and select File ->New ->Web Site from the top menu. Add a new website and in the Default.aspx select the Design tab situated at the left bottom.

In the design mode, select the Toolbox. From the Toolbox, drag and drop a GridView and SqlDataSource control. Attach the GridView with the SqlDataSource control, the way we have shown the link above.

After you have run the website, you will see the GridView showing details of employees in tabular format. We have selected four columns from table. GridView Edit (Update) Row To edit data in a particular row, add AutoGenerateEditButton and set DataKeyNames='EmpID' to the GridView control. Boy Meets Girl 1994 Rapidshare. The DataKeyNames field will be used in the SQL query to edit the employee details. This will add an Edit link button at the beginning of all the rows in the GridView.

Clicking the link button will trigger a PostBack to the server requesting to edit the row values. As I have mentioned earlier, the GridView shows four columns and I want to edit selected columns only, let’s say, the Mobile Number and Email Address.

Therefore, first set ReadOnly='true' for the fields EmpID and EmpName. In, add the UpdateCommand property, which will have an SQL Update command or a procedure to update the selected row’s data. Add two parameters (or fields) inside property. Delete a GridView Row Similar procedure must be followed to delete one row at a time. Just add AutoGenerateDeleteButton='true' in the GridView control. In the SqlDataSource add the below property and parameter. There is hardly any code to be written to do these transactions.

All we need is to write the SQL queries according to our need. However, there is a drawback when deleting a particular row. If a user clicks the delete button, the page will post back the delete command and the query is executed, which deletes the entire row. ( Without any warning). It can be very disturbing if the row was mistakenly deleted. The lost data cannot come back.