LinQ binding to Gridview

Question

Hi, I know by using we can bind the table to gridview like this: dataGridView1.DataSource=( from customer in db.Customers
where customer.Country == "USA"
orderby customer.CompanyName
select new { customer.CustomerID,
customer.City }).ToBindingList();
In this case can we declare the gridview in aspx page with   " CommandName="Link" Text=' ' > can we do like this in aspx page. Thanks

Midhun Tp · Answer

Hi,

Try like this -

var result=( from customer in db.Customers
where customer.Country == "USA"
orderby customer.CompanyName
select new {CustomerID=customer.CustomerID,
City =customer.City }).ToList();

dataGridView1.DataSource = result;

dataGridView1.DataBind();

Please check below links too -

http://www.c-sharpcorner.com/uploadfile/jayendra/binding-gridview-using-linq/

http://www.aspsnippets.com/Articles/Populate-Bind-GridView-using-LINQ-to-SQL-in-ASPNet-using-C-and-VBNet.aspx

Vinay Singh · Answer

Hi check the code

var data=( from customer in db.Customers
where customer.Country == "USA"
orderby customer.CompanyName
select new { customer.CustomerID,
customer.City }).ToBindingList();

dataGridView1.DataSource=data;

dataGridView1.DataBind();