How to skip serial numbers in gridview

Question

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

venkatt saikrishna · Answer

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

Priyaranjan K S · Answer

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.

Sujeet Suman · Answer

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 .