01.<asp:GridView ID="Customers" runat="server" AutoGenerateColumns="False"
02. DataSourceID="CustomersSqlDataSource" DataKeyNames="CustomerId" ShowFooter="true"
03. onrowcommand="Customers_RowCommand">
04. <Columns>
05. <asp:TemplateField HeaderText="CustomerId">
06. <ItemTemplate>
07. <%# Eval("CustomerId") %>
08. </ItemTemplate>
09. </asp:TemplateField>
10. <asp:TemplateField HeaderText="FirstName">
11. <ItemTemplate>
12. <%# Eval("FirstName") %>
13. </ItemTemplate>
14. <EditItemTemplate>
15. <asp:TextBox runat="server" ID="EditFirstName" Text=
16. <%# Bind("FirstName") %>
17. </EditItemTemplate>
18. <FooterTemplate>
19. <asp:TextBox runat="server" ID="InsertFirstName" Text=
20. <%# Bind("FirstName") %>
21. </FooterTemplate>
22. </asp:TemplateField>
23. <asp:TemplateField HeaderText="LastName">
24. <ItemTemplate>
25. <%# Eval("LastName") %>
26. </ItemTemplate>
27. <EditItemTemplate>
28. <asp:TextBox runat="server" ID="EditLastName" Text=
29. <%# Bind("LastName") %>
30. </EditItemTemplate>
31. <FooterTemplate>
32. <asp:TextBox runat="server" ID="InsertLastName" Text=
33. <%# Bind("LastName") %>
34. </FooterTemplate>
35. </asp:TemplateField>
36.
37. <asp:TemplateField HeaderText="Commands">
38. <ItemTemplate>
39. <asp:Button runat="server" ID="Edit" Text="Edit" CommandName="Edit" />
40. <asp:Button runat="server" ID="Delete" Text="Delete" CommandName="Delete" />
41. </ItemTemplate>
42. <EditItemTemplate>
43. <asp:Button runat="server" ID="Update" Text="Update" CommandName="Update" />
44. <asp:Button runat="server" ID="Cancel" Text="Cancel" CommandName="Cancel" />
45. </EditItemTemplate>
46. <FooterTemplate>
47. <asp:Button runat="server" ID="Insert" Text="Insert" CommandName="InsertNew" />
48. <asp:Button runat="server" ID="Cancel" Text="Cancel" CommandName="CancelNew" />
49. </FooterTemplate>
50. </asp:TemplateField>
51. </Columns>
52. <EmptyDataTemplate>
53. First Name:<asp:TextBox runat="server" ID="NoDataFirstName" />
54. Last Name:<asp:TextBox runat="server" ID="NoDataLastName" />
55. <asp:Button runat="server" ID="NoDataInsert" CommandName="NoDataInsert" Text="Insert"/>
56. </EmptyDataTemplate>
57. </asp:GridView>
