I have been trying to figure out, to no avail, how to query a datatable with linq and than bind those results to a grid view.  How do you select specific columns from the table and then bind to a gridview?  I am sure others are trying to figure out the same thing as this would be very useful to be able to do.  Here is a copy of the syntax I have been trying:

var query = from c in table.AsIEnumerable() select c;

gridview1.datasource = query;

gridview1.databind();

Do you select specific columns by c.Field<string>("username") or c.username

I am using Visual Studio 8 Beta2.  Any help would be greatly appreciated.

Cheers!

Try with this:

        NorthWindDataContext db = new NorthWindDataContext();
        var products = from p in db.Products select new { p.CategoryID, p.Discontinued };
        GridView1.DataSource = products;
        GridView1.DataBind();

kipo:

Try with this:

        NorthWindDataContext db = new NorthWindDataContext();
        var products = from p in db.Products select new { p.CategoryID, p.Discontinued };
        GridView1.DataSource = products;
        GridView1.DataBind();

Error 1 'System.Data.DataRow' does not contain a definition for 'Person' and no extension method 'Person' accepting a first argument of type 'System.Data.DataRow' could be found (are you missing a using directive or an assembly reference?) C:\Users\MyAccount\Documents\Visual Studio 2008\WebSites\GWLCDev\Default.aspx.cs 41 66 C:\...\Dev\
 

This is the error I get when I try and use code similar to what your response.  Any Ideas?

Can you post code which is generating error?

var query = from c in table.AsEnumerable()

Sorry, I thought you're using Linq to SQL, but actually you're using Linq to DataTable. So in your case use this:

var query = from c in table.AsEnumerable() select new { Week = c.Field<string>("Week"), Person = c.Field<string>("Person"), Guess = c.Field<string>("Guess"), Actual = c.Field<string>("Actual") };

Kipo,

 Yes, that worked thank you for taking the time to help me out. Kudos to you!  select new { c.Week,c.Person,c.Guess,c.Actual} only works if you are using a typed dataset, I did not realize that.

Thanks ....

I am working on same problem but i have to select perticular rows depanding on select criteria

can you please explain how can we do that

Vir1:

Thanks ....

I am working on same problem but i have to select perticular rows depanding on select criteria

can you please explain how can we do that

Just use the Where keywork.

I am little bit late..but would like to share my example with you,

dt.Columns.Add("col1");

dt.Columns.Add("col3");

DataRow dr = dt.NewRow();

dr["col2"] = i + " - Name";

Hi i am wondering if you coud please help me too i am having the same type of problem as Bridge23,

 I am trying to do a Linq to a Cached DataTable, i am quite new to Linq...

I emulated his code from the solution  you gave to Bridge23, the only thing i am doing differently is that i am storing my dataset in a cache instead of a session...can this be the problem i really thing not ...here is my code

and below it is the error i am receiving :

DataSet ds = (DataSet) Cache["dsResult"];

select new

SecurityName = c.Field<string>("SecurityName"),

Product = c.Field<string>("Product"),

Location = c.Field<string>("Location"),

AvgBorrowCost = c.Field<string>("AvgLoanCost"),

AvgBorrowRebate = c.Field<string>("AvgBorrowRebate"),

Price = c.Field<string>("Price"),

//PendingDate1 = c.Field<string>("PendingDate1"),

//PendingValue1 = c.Field<string>("PendingValue1"),

//NetDate1 = c.Field<string>("NetDate1"),

//NetValue1 = c.Field<string>("NetValue1"),

//PendingDate2 = c.Field<string>("PendingDate2"),

//PendingValue2 = c.Field<string>("PendingValue2"),

//NetDate2 = c.Field<string>("NetDate2"),

//NetValue2 = c.Field<string>("NetValue2"),

//PendingDate3 = c.Field<string>("PendingDate3"),

//PendingValue3 = c.Field<string>("PendingValue3"),

//NetDate3 = c.Field<string>("NetDate1"),

//NetValue3 = c.Field<string>("NetValue1"),

////pending and net 4 to 22 here

The data source does not support server-side data paging

Are you also using LINQ to SQL or only LINQ?

Hi

I am using just Linq

If you are asking if i am using the Linq to SQL class file and then creating an instance of the DBContext file i am not, but if there is a way to do it that way i am intersted as well

thanks

 Well if you are using VS 2008 then you can simply add a "Linq to Sql" file and map it to your database.