binding data to gridview

Hi,

You can use Linq2SQL like this,

var AfterRowNumbering = dataTable.Select((x, index) => new {
Id=x.Id,
......
......
Row_Number = index
});

var evenResult = from row in AfterRowNumbering
                       where row.Row_Number % 2 == 0
                       select row;

var oddResult = from row in AfterRowNumbering
                       where row.Row_Number % 2 != 0
                       select row;

Why do you want to display only even numbered records? Is there any specific reason?
Else we can get the records only required.