forum

Home / DeveloperSection / Forums / How to create datagrid columns from multiple records using LinqtoSql?

Ask Question

How to create datagrid columns from multiple records using LinqtoSql?

Anonymous User142525-Aug-2014

I have a sql table and I want each record to be a datagrid column and another sql table with multiple records related to each fieldID.

I would like to display each value in the appropiate column of a datagrid using linq.

asp.netasp.net 
Updated on 25-Aug-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Sumit Kesarwani

Sumit Kesarwani

25-Aug-2014
Hi Ankita, 

var dc = new YourdataContext();
   
yourGrid.DataSource = dc.YourTable.Select( t => new {                                                     
t.Property1,                                                    
t.RelationTable.Property2,                                                    
etc...                     
                             
                    } );
  
yourGrid.DataBind();

and add this in the page_load or page_init

Liked By