- 1). Create a GridView shell. The following code provides a very basic GridView in ASP:
<asp:gridview runat="server">
</asp:gridview> - 2). Add the datakey property. The datakey is commonly matched with the primary key of the table retrieved from the database. In this example, the employee's ID is used:
<asp:gridview datakeynames="EmployeeID" runat="server">
</asp:gridview> - 3). Enter the datasource. The datasource is another element on the page that is configured in Step 4. This source is used to create an update query that changes properties of the employee:
<asp:gridview datakeynames="EmployeeID"
datasourceid="myDataSource"
runat="server">
</asp:gridview> - 4). Create the data source. This source uses the datakey setup in the GridView to update the employee record:
<asp:sqldatasource
updatecommand="Update Employee set firstname=@firstname where employeeId = @EmployeeId"
runat="server">
</asp:sqldatasource>
previous post