Mega Code Archive

 
Categories / ASP.Net Tutorial / Data Binding
 

Use a CommandField to customize the appearance of the Edit, Delete, Update, Cancel, and Select buttons

<%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"   "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server">     <title>Show CommandField</title> </head> <body>     <form id="form1" runat="server">     <div>     <asp:GridView         id="grdProducts"         DataSourceID="srcProducts"         DataKeyNames="Id"         AutoGenerateColumns="false"         Runat="server">         <Columns>         <asp:CommandField             ButtonType="Image"             ShowEditButton="true"             EditText="Edit Product"             UpdateText="Update Product"             ShowCancelButton="true"             CancelText="Cancel Edit"             ShowDeleteButton="true"             DeleteText="Delete Product"/>         <asp:BoundField             DataField="Title"             HeaderText="Product Title" />         <asp:BoundField             DataField="Director"             HeaderText="Product Director" />         </Columns>     </asp:GridView>     <asp:SqlDataSource         id="srcProducts"         ConnectionString="<%$ ConnectionStrings:Products %>"         SelectCommand="SELECT Id,Title,Director FROM Products"         UpdateCommand="UPDATE Products SET Title=@Title,                                           Director=@Director                                          WHERE Id=@Id"          DeleteCommand="DELETE Products WHERE Id=@Id"         Runat="server" />     </div>     </form> </body> </html> File: Web.config <configuration>   <connectionStrings>     <add name="Products"           connectionString="Data Source=.\SQLEXPRESS;          AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />   </connectionStrings> </configuration>