Add edit update gridview

Return dt. End Function. Add Functionality. On click of the add button the following method is called up, which simply sets the textboxes empty and displays the modal popup by calling the AJAX ModalPopupExtender. Show ;. The screenshot below displays the modal popup shown to the user when the Add button is clicked. Edit Functionality. On click of the Edit button in the GridView row the following method gets called up which simply fills the textboxes with respective values.

Parent, GridViewRow. Cells 0. Cells 1. Cells 2. The screenshot below displays the modal popup being shown to the user when the Edit Button is clicked.

Updating the records. The following method gets called up when the Save button the modal popup is clicked. The following method simply calls the stored procedure AddUpdateCustomer described later. Text ;. GetData cmd ;. GetData cmd. The following stored procedure is used to Add and Update the records in the database.

The stored procedure first checks if the record exists in the table. If the record exists then the table is simply updated else a new record is inserted in the database. FROM Customers. The screenshot below describes the data being saved into the database table. You will notice that a progress bar is being displayed until the data is updated in the database.

Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. Try using custom button on gridview. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 3 months ago. Active 9 years, 3 months ago.

Viewed 7k times. OleDb Imports System. EventArgs Handles Me. Load If Not Page. If Not Me. IsPostBack Then. End If. End Sub. Private Sub BindGrid. ConnectionStrings "constr". Fill dt. End Using. Inserting records to GridView. The following event handler is executed when the Add Button is clicked. The name and the country values are fetched from their respective TextBoxes and then passed to the SQL Query for inserting the record in the database.

Finally the GridView is again populated with data by making call to the BindGrid method. AddWithValue " Name" , name ;.

AddWithValue " Country" , country ;. Open ;. ExecuteNonQuery ;. Close ;. AddWithValue " Name" , name. AddWithValue " Country" , country. Editing and Updating GridView records.

CustomerId which is the primary key is fetched from the DataKey property of GridView while the Name and Country fields are fetched from their respective TextBoxes and are passed to the SQL Query for updating the records in the database. ToInt32 GridView1.

Values[0] ;. FindControl "txtName" as TextBox. FindControl "txtCountry" as TextBox. Rows e. DataKeys e. Values 0.