In this article we
will know how to create an auto number column in GridView. We can add AutoNumber
column by using Container.DataItemIndex property in .aspx page of the GridView.
Program
Default.aspx code
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" 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">
<div>
<asp:GridView ID="GridView1" runat="server"
AllowPaging="True" AutoGenerateColumns="False"
PageSize="6"
AlternatingRowStyle-BackColor="red"
AlternatingRowStyle-ForeColor="yellow" >
<Columns>
<asp:TemplateField HeaderText="Sno">
<ItemTemplate>
<%# Container.DataItemIndex
+ 1 %>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="sname" HeaderText="Name"/>
<asp:BoundField DataField="saddress" HeaderText="Address" />
<asp:BoundField DataField="smarks" HeaderText="Marks" />
<asp:BoundField DataField="year" HeaderText="Year" />
</Columns>
<HeaderStyle BackColor="#FF9966" />
<AlternatingRowStyle BackColor="Red" ForeColor="Yellow"></AlternatingRowStyle>
</asp:GridView>
</div>
</form>
</body>
</html>
Default.aspx.vb code
Imports System.Data
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Dim strConnString As String =
System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
Dim con As New SqlConnection(strConnString)
Dim str As String
Dim com As SqlCommand
Dim sqlda As SqlDataAdapter
Dim ds As DataSet
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) HandlesMe.Load
bind()
End Sub
Sub bind()
con.Open()
str = "select
sname,smarks,saddress,year from student"
com = New SqlCommand(str,
con)
sqlda = New SqlDataAdapter(str,
con)
ds = New DataSet
sqlda.Fill(ds, "student")
GridView1.DataSource = ds
GridView1.DataMember = "student"
GridView1.DataBind()
con.Close()
End Sub
Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e AsSystem.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging
GridView1.PageIndex = e.NewPageIndex
bind()
End Sub
End Class
Output