<%@ Page Language="C#" debug=true%>
<%@ Import namespace="System.Data"%>
<%@ Import namespace="System.Data.SqlClient"%>
<html>
<head>
<script runat="server">
DataTable dt = new DataTable("emp");
SqlConnection conn = new SqlConnection("server=(local);user id=sa;pwd=;database=pubs");
void Page_Load(object sender, EventArgs e) 

if(!IsPostBack)
{
Bind();
}
}
void Page_C(object send,DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
Bind();
}
void Bind()
{
SqlDataAdapter ad = new SqlDataAdapter("Select emp_id,fname,lname from employee",conn); 
ad.Fill(dt);
DataView dv = new DataView(dt);
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
DataGrid1.EditItemIndex = 0;
}
</script>
</head>
<body>
<form runat="server" ID="Form1">
<asp:DataGrid ID="DataGrid1" ShowFooter="True" BorderColor="black" AutoGenerateColumns="False" AllowPaging="True" PageSize="10" Runat="server" OnPageIndexChanged="Page_C">
<HeaderStyle BackColor="#aaaadd"></HeaderStyle>
<PagerStyle NextPageText="Next" PrevPageText="Prev" Position="top"></PagerStyle>
<EditItemStyle BackColor="#aaaadd"></EditItemStyle>
<Columns>
<asp:BoundColumn DataField="emp_id" HeaderText="&Ocirc;±&sup1;¤&ordm;&Aring;" ReadOnly="True" SortExpression="lname"></asp:BoundColumn>
<asp:BoundColumn DataField="fname" HeaderText="&micro;&Uacute;&Ograve;&raquo;&cedil;&ouml;&Atilde;&ucirc;×&Ouml;"></asp:BoundColumn>
<asp:BoundColumn DataField="lname" HeaderText="×&icirc;&ordm;ó&Ograve;&raquo;&cedil;&ouml;&Atilde;&ucirc;×&Ouml;"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="temp">
<EditItemTemplate>
<asp:DropDownList id=d1 AutoPostBack=true bordercolor=black borderstyle=double borderwith=10 runat=server></asp:dropdownlist>
</EditItemTemplate>
<ItemTemplate>
<a href="asp.aspx">Link</a><hr>
</ItemTemplate>
<HeaderTemplate>
<h1>
Template Sample
</h1>
</HeaderTemplate>
<FooterTemplate>
<img src="p1.jpg">
</FooterTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>