Increment values in gridview column

Sivajihero Hero

In my gridview which is in update mode, I need to increment a column value.

Ex: In my gridview have 5 rows and three columns. I need to increment the serial number column value by 1. Increment Gridview1.Rows[1].Cells[2] value by 1 up to 5th row. But when I execute the code it will result the output put of all the column same. This is my code.

{

int totalRows = GridView1.Rows.Count;

for (int RowIndex = 0; RowIndex < totalRows; RowIndex++)

{

GridViewRow row = GridView1.Rows[RowIndex];

TextBox txtslno = row.FindControl("txtslno") as TextBox;

int number = int.Parse(TextBox5.Text);

if (GridView1.Rows.Count > 1)

{

for (int i = 0; i < GridView1.Rows.Count - 1; i++)

{

txtslno.Text = (number + 1).ToString();

number++;

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Imtiyaz Ansari10y ago
Hello Sivaji

try this way......!!!

http://www.codeproject.com/Questions/455320/How-to-save-Item-Template-textbox-from-gridview-to
Sivajihero Hero10y ago
I already used this code
protected void Button33_Click(object sender, EventArgs e)
{
if(GridView1.Rows.Count>1)
{
for (int i = 0; i < GridView1.Rows.Count - 1; i++)
{

GridView1.Rows[i].Cells[0].Text = (i + 1).ToString();
}
}
}
But the problem is I cannot able to save that data, because my GV is in template field.
Sivajihero Hero10y ago
I need to increment my textbox value, If my textbo5.text value is 5 , then it will increment like 6,7,8,9 in my gridview column.
Imtiyaz Ansari10y ago
Hi
Sivajihero
try this.....!!!

DataTable _test = new DataTable();
DataColumn c = new DataColumn("sno", typeof(int));
c.AutoIncrement = true;
c.AutoIncrementSeed = 1;
c.AutoIncrementStep = 1;
_test.Columns.Add(c);
_test.Columns.Add("description");
gvlisting.DataSource = _test;

OR

private void QsDataGridView_DataBindingComplete(object sender, System.Windows.Forms.DataGridViewBindingCompleteEventArgs e)
{
int counter = 1;
for (int i = 0; i < this.Rows.Count; i++)
{
this.Rows[i].Cells["Counter"].Value = (counter++).ToString();
}

}

OR

<%#Container.DataItemIndex+1%>

Raja T10y ago

Hello Sivaji, try like

<asp:GridView ID="GridEmployee" runat="server" AutoGenerateColumns="false" 
         CellPadding="5" Style="background-color: #f1f1f1; width: 50%;">
                    <Columns>
                        <asp:TemplateField HeaderText="S.No">
                            <ItemTemplate>
                                <%#Container.DataItemIndex+1 %>
                            ItemTemplate>
                        asp:TemplateField>
                    Columns>
                asp:GridView>

more details check out below link

http://www.thedevelopertips.com/DotNet/ASPDotNet/how-to-create-autogenerate-serial-number-column-in-gridview.aspx?Id=74