How to show auto generated serial no. column in Gridview

Question

Dear All I need to maintain column in GridView for row count. I have values with IDNameTime with Select & Delete buttons in GridView. Here In ID column i dont want to show original values. I need auto generated row count values. but when i select that row i need to retrieve ID & Name. How can i do this? Can anybody help me out..

Satyapriya Nayak · Answer

Hi Shiva Default.aspx code Untitled Page AllowPaging=True AutoGenerateColumns=False PageSize=6 AlternatingRowStyle-BackColor=red AlternatingRowStyle-ForeColor=yellow > 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 snamesmarkssaddressyear 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

Senthilkumar · Answer

Hi Siva I suggest you to do it in the sql server side easily. SELECT ROW_NUMBER() OVER(ORDER BY ID ASC) AS [SNO]  IDNameTime FROM table_name In the grid assign the ID value to the hidden control or invisible label control. If you want to do it in the server side then you can do it in the DataTable DataColumn dColumn = new DataColumn(); dColumn.ColumnName = SNO; dColumn.AutoIncrement = true; dColumn.AutoSeed = 1; dataTable.Columns.Add(dColumn); Hope this will help you.