Show data in GridView Through Linq

Question

Hi Friends I want to show the data in gridview through the Linq data source how can we do this ?

Ajay Patel · Answer

Model.Entities objEntity = new Model.Entities(); var countryList = (from country in objEntity.Countries where country.flg_Deleted == false orderby country.CountryName select new { Country_ID = country.CountryID Country_Name = country.CountryName Country_Code = country.CountryCode Status = country.flg_Active.Value == true ? Active : DeActive ISDCode = country.ISDCode }); Grid.dataSource = countryList; Grid.Databind(); Grid Column's Data Field Must be same as Column Name Here. Like Country_ID.Country_Name..

Satyapriya Nayak · Answer

Hi Shubham Please refer the below link http://www.codeproject.com/Articles/33685/Simple-GridView-Binding-using-LINQ-to-SQL Thanks