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
SiNo |
Id |
Name |
Country |
1 |
ALFKI |
Maria Anders |
Germany |
2 |
ANATR |
Ana Trujillo |
Mexico |
3 |
ANTON |
Antonio Moreno |
Mexico |
4 |
AROUT |
Thomas Hardy |
UK |
5 |
BERGS |
Christina Berglund |
Sweden |
6 |
BLAUS |
Hanna Moos |
Germany |
7 |
BLONP |
Frédérique Citeaux |
France |
8 |
BOLID |
Martín Sommer |
Spain |
9 |
BONAP |
Laurence Lebihan |
France |
10 |
BOTTM |
Elizabeth Lincoln |
Canada |