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 T P · 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();