Introduction:
in this article,i am going to demostrate how to do the insert,update,delete in gridview data control and i am going to explain step by step with screenshots.

Main:
To insert, update or delete data using the GridView control we need to first configure the data source. The steps for configuring the data source are simple. Go to the design view of your web page and drag-and-drop the SqlDataSource control and select configure data source option.

Click Advance tab,and select generate insert,update and delete option button,

Now the sqldatasource look like below,

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NETPROGRAMMINGHELPConnectionString %>" DeleteCommand="DELETE FROM [EMPLOYEE] WHERE [EMPLOYEEID] = @EMPLOYEEID" InsertCommand="INSERT INTO [EMPLOYEE] ([EMPLOYEEID], [EMPNAME], [DESIGNATION], [SALARY], [DEPARTMENT]) VALUES (@EMPLOYEEID, @EMPNAME, @DESIGNATION, @SALARY, @DEPARTMENT)" SelectCommand="SELECT [EMPLOYEEID], [EMPNAME], [DESIGNATION], [SALARY], [DEPARTMENT] FROM [EMPLOYEE]" UpdateCommand="UPDATE [EMPLOYEE] SET [EMPNAME] = @EMPNAME, [DESIGNATION] = @DESIGNATION, [SALARY] = @SALARY, [DEPARTMENT] = @DEPARTMENT WHERE [EMPLOYEEID] = @EMPLOYEEID"> <DeleteParameters> <asp:Parameter Name="EMPLOYEEID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="EMPNAME" Type="String" /> <asp:Parameter Name="DESIGNATION" Type="String" /> <asp:Parameter Name="SALARY" Type="String" /> <asp:Parameter Name="DEPARTMENT" Type="String" /> <asp:Parameter Name="EMPLOYEEID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="EMPLOYEEID" Type="Int32" /> <asp:Parameter Name="EMPNAME" Type="String" /> <asp:Parameter Name="DESIGNATION" Type="String" /> <asp:Parameter Name="SALARY" Type="String" /> <asp:Parameter Name="DEPARTMENT" Type="String" /> </InsertParameters> </asp:SqlDataSource>

Now refer this sqldatasource into gridview datasourceID,

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="EMPLOYEEID" DataSourceID="SqlDataSource1" CssClass="netprogrammingviewcss" > <Columns> <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" /> <asp:BoundField DataField="EMPLOYEEID" HeaderText="EMPLOYEEID" ReadOnly="True" SortExpression="EMPLOYEEID" /> <asp:BoundField DataField="EMPNAME" HeaderText="EMPNAME" SortExpression="EMPNAME" /> <asp:BoundField DataField="DESIGNATION" HeaderText="DESIGNATION" SortExpression="DESIGNATION" /> <asp:BoundField DataField="SALARY" HeaderText="SALARY" SortExpression="SALARY" /> <asp:BoundField DataField="DEPARTMENT" HeaderText="DEPARTMENT" SortExpression="DEPARTMENT" /> </Columns> </asp:GridView>

Now go to gridview properties and enable edit,select and update,

Thatsit!

Conclusion:
Hope this helps,
Happy Coding.