ARTICLE

Dynamically creating autonumber column in gridview in VB.NET

Posted by Satyapriya Nayak in Articles | ASP.NET using VB.NET on August 22, 2011

Tags: vb.net, vb.net articles, vb.net tutorials, autonumber column in gridview in vb.net, asp.net gridview

In this article we will know how to create an auto number column in gridview.

Tweet
1315
0

Download Files:

Dynamically creating autonumber column in gridview.rar

Reader Level: Beginner

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">

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server"

AllowPaging="True" AutoGenerateColumns="False"

PageSize="6"

AlternatingRowStyle-BackColor="red"

AlternatingRowStyle-ForeColor="yellow" >

<asp:TemplateField HeaderText="Sno">

<%# 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>

</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) Handles Me.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 As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging

GridView1.PageIndex = e.NewPageIndex

bind()

End Sub

End Class