How to skip serial numbers in gridview

venkatt saikrishna

11y928.NET

How to skip serial numbers in gridview when grid view first column row is empty

ex: sno employeename salary

1 sai 10000

20000

2 kumar 12000

3 Replies

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

venkatt saikrishna11y ago
Thank you for your support.Actually I try these code in my task but it displaying like these
Your code is working like these but I need these one
sno RouteName Poi sno RouteName POI Point
1 sr nagar   road1 1 sr nagar road1
4    road2 road2
5 road3 road3
6 2 Ameerpet road1
3 kukatpally road1 road2
road3
4 moosapet road1
0
Priyaranjan K S11y ago
Hi Venkatt ,

I think we can implement this at the data table level even before binding the data table to the grid view .

Once you have the data in the data table . Loop through the data table .Use an Incremental counter . Check if the Employee name is empty . If it has some value Increment the counter and assign the value to the serial number column.

DataTable table = new DataTable();
table.Columns.Add("SNo", typeof(int));
table.Columns.Add("EmployeeName", typeof(string));
table.Columns.Add("Salary", typeof(int));

// Populate the real data into the data table from some source

//Once data is populated loop through the data table to set the serial number

int count=0;
foreach (DataRow row in table.Rows)
{
if(row["EmployeeName"] != string.Empty)
{
count++;
row["SNo"]=count++;
}
}

Once we have the updated data table . Bind it to the grid view .

Thanks,
Priyan

If you found this useful Please mark this as Answer.

0
Sujeet Suman11y ago
VenKatt please once try below code:

.
void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{

   if (e.Row.RowType == DataControlRowType.DataRow)
   {
      // If this is a SqlDataSource you can use DataRowView,
      // otherwise use whatever type is used in the data source
      DataRowView rowView = (DataRowView)e.Row.DataItem;
      if (String.IsNullOrEmpty(rowView["SerialNo"].ToString()))
      {
         e.Row.Visible = false;
      }
   }
}

If this is useful for you then please accept my Answer.
0