.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Gridview: How to create a column that will autogenerate the serial number of each row

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :ASP.Net

Hi all,

I have a gridview and I want to autopopulate the serial number columns. For eg, the gridview has 10 rows. The user deleted the first row. I want the gridview serial number to automatically shift down by one. Ie., 10-->9, 9-->8 and so on.

Can this be done? Any help is much appreciated!

View Complete Post

More Related Resource Links

Create a new Column in SQL-Database-GridView


Hi everybody,

at this time I try to  connect to a SQL-Database with ASP.net.

That works very well with DataGrid, but I want to add a new Column to the DataGrid with the number of the database rows.

The column have to be the first Column of DataGrid.

I want to create a function (with for-loop) to count the number of the row of a DataGrid and write it into DataGrid's first Column.

The number of Rows gets the DataGrid by the SQL-Database.

The SQL Database shouldn't get a new Column. I just want to create the column dynamically.

How could I realize this ? 


Here you can see my SourceCode:

Dim connStr As String = "server=WU900136\SQLEXPRESS; database=GT; Trusted_Connection=yes"
    Dim conn As New SqlConnection(connStr)

    Sub Page_Load(ByVal Sender As Object, ByVal E As EventArgs)
    End Sub
    Private Dataset As DataSet

    Sub rData()
        'Read Data
        Dim sql As String = "SELECT Bezeichnung Thema, starttermin Beginn, endtermin Ende From GR_Seminare, Gr_Termine WHERE Gr_Seminare.SemId=Gr_Termine.SemId"
        Dim cmd As New SqlCommand(sql, conn)
        Dim DataReader As SqlDataReader
        DataReader = cmd.E

how to create calculated column with gridview boundfield?


Hi Friends.....

can you guide me how to create calculated column with gridview boundfield?

Thanks in advance.........

Create GridView Dynamically with any Number


according to my case i want to show from  1 to 7 gridviews at every query from database
so i made 7 methods and also 7 gridview ,but this is bad idea
how can i ceate it dynamically for only gridview and only method?
thanks so much
here is my gridview
<asp:GridView ShowHeader="False" ID="gv_statistics_gr4" runat="server" AutoGenerateColumns="False" onrowdatabound="gv_statistics_gr4_RowDataBound" > <RowStyle BackColor="#FFFF00" /> <Columns> <asp:TemplateField HeaderText="name"> <ItemTemplate> <asp:Label ID="img_vvvitemname10" runat="server" Text='<%#Eval("name")%>' /> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="count "> <ItemTemplate> <asp:Label ID="lbl_sum" runat="server" Text='<%#Eval("count") %>' /> </ItemTemplate>

Create ToolTip for GridView Header

The following allows you to add a tooltip to the header links of your GridView, a feature that is lacking.

Tooltip for GridView Column Headers (ASP.Net)

I just wanted to add auto tooltips for my GridView headers. There are couple of ways but I don't want to use javascript and wanted to use simple 'title' attribute. It took couple of hours to get the working code supporting sortable columns. I thought it will be very useful for others. Here's the code and logic behind it.

Use a column as parameter for a sds in another column; gridview


Hola, I have a gridview which is bound to a sds which returns 7 columns and I added two columns from the GUI.  What I want is to fill up the 9th column with DDLs and these  DDLS will get their data from a different sds which is using a stored procedure with a single parameter.  I created the 9th row, used template field, made the sds for 9th row, the stored_procedure, threw a DDL in Item template and all  I need now is to pass a parameter in the first column to the sds in the 9th column.  I can code this but i'm getting tired of aspx.cs :) and would like to do it from the GUI.

Rendering data with HTML tags in the DD Gridview for a selected column


I am having trouble finding out where and how to HTML Encode a cell's data on the Dynamic Data (v4.0) gridview of List.aspx.  As a simple case, suppose I have formatted cell data that is A<br/>B in the DB.    Obviously, I want A stacked on B in the cell.

It seems gridView1.HtmlEncode = true has gone away.

So maybe I'll try to catch it on the RowDataBound event:

protected void GridView1_RowDataBound(Object sender, GridViewRowEventArgs e)

            if (e.Row.RowType == DataControlRowType.DataRow)
                // Html Encode the cells


but this event never fires?

Has anyone figured out how to properly render HTML tags data in the List.aspx's GridView1? 

If I figure this out, then I can add a MetaAttribute called something like [EncodeAsHtml(true)] and be on my way.  Thanks!

How to show 0 as first number in column


Hi guys. I have two little problem.

I have database with one table and it has 4 rows.

1. I want to show a zero in front of all number. Actually i added but it doesn't show.

2. If i don't put any value in column is it possible to have minus for example instead of 0?




I post it like that because i can't see how to post pics directly.

P.S. The columns with numbers have checked "allow nulls".

I draw in paint so it's not so good but i think it's understandable.

10x in advance.

how to create index for a column


Hi Friends,

                       I need to create the index for a column and accessing that in sqlserver 2005. Please any one help me.


How To Access Datakeys In Javascript...and How To make gridview Column Visible true in javascript


How To Access Gridview's Datakeys In Javascript...and How To make gridview Column Visible true in javascript

Reply me..

To create a custom control and type while creating a column


HI All,

i am creating a column in the list while creating a column i will have an option for choice field on selecting choice i can see dropdown, radiobutton, Checkbox to select and  can enter list of values. and on clicking ok i will get a column with radiobutton. in newform.aspx and also in editform.aspx

so i need to create the similar functionality with my custom radio button, so on create column i need to show my custom choce on selecting this i need to show my custom radiobutton  and  can enter list of values then on selecting it then click ok to create a column, in edit form and new form i need to show a radio buttons with values.

Thanks in advance




sum of 7 column totals in footer of gridview

I have implemented column tolals in the footer of my gridview using the technicque described in this article http://aspalliance.com/782 .Now I would like to have a total of the 7 column totals that are displayed in the footer.  Can anyone tell me how to do this.  I would like to display this in a label or an addition row in the footer if that is possible.

proper format for number column

Hi  In a column i have number datatype but after filling some no it's giving like that 23,786,23 (mostly like a currency format ) but i need like that 2378623 so give me suggestion how i can implement this in sharepoint 2010 , is there need to bound some column level validation for that ............... 

How to set the width of column on GridView

How to set the specific the width of each column, the columns are created automaticly 

How to tell repeater to wrap text after certain number of characters for a particular column ?

I have a column in my repeater which allows as many as 255 characters and causes the page contents pushed away to the right if any of the record has all 255 characters in that column. How can I tell it to wrap the text after 50 characters ?Thanks,

Use Data in a Column as Select Button in GridView

I don't want to use the built in "Select" hyperlink that's in the gridview, I'd like to just use the first data column, is there a way to do that or are we forced to use the automatically generated "Select" column.Thanks!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend