Generate serial number using Linq

Hi ahsan.ali,

Refer the below code.

NorthwindEntities db = new NorthwindEntities();
IEnumerable<Customer> customers = (from cus in db.Customers select cus).ToList().Take(10);
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[4] { new DataColumn("SiNo"), new DataColumn("Id"), new DataColumn("Name"), new DataColumn("Country") });
DataRow dr;
int siNo = 1;
foreach (Customer cus in customers)
{
    dr = dt.NewRow();
    dr["SiNo"] = siNo;
    dr["Id"] = cus.CustomerID;
    dr["Name"] = cus.ContactName;
    dr["Country"] = cus.Country;
    siNo++;
    dt.Rows.Add(dr);
}
dataGridView1.DataSource = dt;

Output