http://www.gridviewguy.com/ArticleDetails.aspx?articleID=147
<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default"
%>
<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >
< html xmlns ="http://www.w3.org/1999/xhtml" >
< head runat ="server" >
< title > Untitled Page </ title >
</ head >
< body >
< form id ="form1" runat ="server" >
< asp:SqlDataSource ID ="userSqlDataSource" runat ="server" ConnectionString ="<%$ ConnectionStrings:ConnectionString %>"
InsertCommand ="INSERT INTO Users(FirstName, LastName) VALUES(@FirstName, @LastName)"
ProviderName ="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand ="SELECT * FROM Users" DeleteCommand ="DELETE FROM Users WHERE UserID = @UserID " UpdateCommand ="UPDATE Users SET FirstName = @FirstName, LastName = @LastName WHERE UserID = @UserID" >
</ asp:SqlDataSource >
< br />
< asp:DetailsView ID ="dvUsers" runat ="server" AllowPaging ="True" AutoGenerateDeleteButton ="True"
AutoGenerateEditButton ="True" AutoGenerateInsertButton ="True" AutoGenerateRows ="False"
BackColor ="White" BorderColor ="#3366CC" BorderStyle ="None" BorderWidth ="1px"
CellPadding ="4" DataKeyNames ="UserID" DataSourceID ="userSqlDataSource" Font-Names ="Verdana"
Font-Size ="Small" Height ="50px" Width ="125px" EmptyDataText ="There are no records." >
< FooterStyle BackColor ="#99CCCC" ForeColor ="#003399" />
< EditRowStyle BackColor ="#009999" Font-Bold ="True" ForeColor ="#CCFF99" />
< RowStyle BackColor ="White" ForeColor ="#003399" />
< PagerStyle BackColor ="#99CCCC" ForeColor ="#003399" HorizontalAlign ="Left" />
< Fields >
< asp:TemplateField HeaderText ="UserID" InsertVisible ="False" >
< ItemTemplate >
< asp:Label ID ="lblUserID" Text ='<%# Eval("UserID") % > ' runat="server"> </ asp:Label >
</ ItemTemplate >
</ asp:TemplateField >
< asp:TemplateField HeaderText ="FirstName" >
< InsertItemTemplate >
< asp:TextBox ID ="txtFirstName" Text ='<%# Bind("FirstName") % > ' runat="server"> </ asp:TextBox >
< br />
< asp:RequiredFieldValidator ID ="rfvFirstName" runat ="server" ControlToValidate ="txtFirstName"
ErrorMessage ="Invalid" ></ asp:RequiredFieldValidator >
</ InsertItemTemplate >
< ItemTemplate >
< asp:Label ID ="lblFirstName" Text ='<%# Eval("FirstName") % > ' runat="server"> </ asp:Label >
</ ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID ="txtEditFirstName" runat ="server" Text ='<%# Bind("FirstName") % > '> </ asp:TextBox >
</ EditItemTemplate >
</ asp:TemplateField >
< asp:TemplateField HeaderText ="LastName" >
< InsertItemTemplate >
< asp:TextBox ID ="txtLastName" Text ='<%# Bind("LastName") % > ' runat="server"> </ asp:TextBox >
< br />
< asp:RequiredFieldValidator ID ="rfvLastName" runat ="server" ErrorMessage ="Invalid" ControlToValidate ="txtLastName" ></ asp:RequiredFieldValidator >
</ InsertItemTemplate >
< ItemTemplate >
< asp:Label ID ="lblLastName" Text ='<%# Eval("LastName") % > ' runat="server"> </ asp:Label >
</ ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID ="txtEditLastName" runat ="server" Text ='<%# Bind("LastName") % > '> </ asp:TextBox >
</ EditItemTemplate >
</ asp:TemplateField >
</ Fields >
< HeaderStyle BackColor ="#003399" Font-Bold ="True" ForeColor ="#CCCCFF" />
< PagerSettings PageButtonCount ="20" />
</ asp:DetailsView >
</ form >
</ body >
</ html >
<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >
< html xmlns ="http://www.w3.org/1999/xhtml" >
< head runat ="server" >
< title > Untitled Page </ title >
</ head >
< body >
< form id ="form1" runat ="server" >
< asp:SqlDataSource ID ="userSqlDataSource" runat ="server" ConnectionString ="<%$ ConnectionStrings:ConnectionString %>"
InsertCommand ="INSERT INTO Users(FirstName, LastName) VALUES(@FirstName, @LastName)"
ProviderName ="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand ="SELECT * FROM Users" DeleteCommand ="DELETE FROM Users WHERE UserID = @UserID " UpdateCommand ="UPDATE Users SET FirstName = @FirstName, LastName = @LastName WHERE UserID = @UserID" >
</ asp:SqlDataSource >
< br />
< asp:DetailsView ID ="dvUsers" runat ="server" AllowPaging ="True" AutoGenerateDeleteButton ="True"
AutoGenerateEditButton ="True" AutoGenerateInsertButton ="True" AutoGenerateRows ="False"
BackColor ="White" BorderColor ="#3366CC" BorderStyle ="None" BorderWidth ="1px"
CellPadding ="4" DataKeyNames ="UserID" DataSourceID ="userSqlDataSource" Font-Names ="Verdana"
Font-Size ="Small" Height ="50px" Width ="125px" EmptyDataText ="There are no records." >
< FooterStyle BackColor ="#99CCCC" ForeColor ="#003399" />
< EditRowStyle BackColor ="#009999" Font-Bold ="True" ForeColor ="#CCFF99" />
< RowStyle BackColor ="White" ForeColor ="#003399" />
< PagerStyle BackColor ="#99CCCC" ForeColor ="#003399" HorizontalAlign ="Left" />
< Fields >
< asp:TemplateField HeaderText ="UserID" InsertVisible ="False" >
< ItemTemplate >
< asp:Label ID ="lblUserID" Text ='<%# Eval("UserID") % > ' runat="server"> </ asp:Label >
</ ItemTemplate >
</ asp:TemplateField >
< asp:TemplateField HeaderText ="FirstName" >
< InsertItemTemplate >
< asp:TextBox ID ="txtFirstName" Text ='<%# Bind("FirstName") % > ' runat="server"> </ asp:TextBox >
< br />
< asp:RequiredFieldValidator ID ="rfvFirstName" runat ="server" ControlToValidate ="txtFirstName"
ErrorMessage ="Invalid" ></ asp:RequiredFieldValidator >
</ InsertItemTemplate >
< ItemTemplate >
< asp:Label ID ="lblFirstName" Text ='<%# Eval("FirstName") % > ' runat="server"> </ asp:Label >
</ ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID ="txtEditFirstName" runat ="server" Text ='<%# Bind("FirstName") % > '> </ asp:TextBox >
</ EditItemTemplate >
</ asp:TemplateField >
< asp:TemplateField HeaderText ="LastName" >
< InsertItemTemplate >
< asp:TextBox ID ="txtLastName" Text ='<%# Bind("LastName") % > ' runat="server"> </ asp:TextBox >
< br />
< asp:RequiredFieldValidator ID ="rfvLastName" runat ="server" ErrorMessage ="Invalid" ControlToValidate ="txtLastName" ></ asp:RequiredFieldValidator >
</ InsertItemTemplate >
< ItemTemplate >
< asp:Label ID ="lblLastName" Text ='<%# Eval("LastName") % > ' runat="server"> </ asp:Label >
</ ItemTemplate >
< EditItemTemplate >
< asp:TextBox ID ="txtEditLastName" runat ="server" Text ='<%# Bind("LastName") % > '> </ asp:TextBox >
</ EditItemTemplate >
</ asp:TemplateField >
</ Fields >
< HeaderStyle BackColor ="#003399" Font-Bold ="True" ForeColor ="#CCCCFF" />
< PagerSettings PageButtonCount ="20" />
</ asp:DetailsView >
</ form >
</ body >
</ html >