How to show auto generated serial no. column in Gridview

Hi Shiva,


Default.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>





   


   

   

                  AllowPaging="True" AutoGenerateColumns="False"
              PageSize="6"
              AlternatingRowStyle-BackColor="red"
              AlternatingRowStyle-ForeColor="yellow" >
   
   
   
        <%# Container.DataItemIndex + 1 %>
   
   
   
   
      
                   
   
       


   

   

   

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(com)
        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



Thanks