CODEWITHSUNDEEP
c#linq
Learning Curve
Learning Curve

Reputation: 1569

How to get a column value from data table with Linq

How to get a column value from a data table object. I have the id column on which basis I am trying to get another column value.

e.g. ApplicationId is the primary key column which I have and now I want to get the xyz column value for this ApplicationId.

Upvotes: 0

Views: 23968

Answers (3)

Srb1313711
Srb1313711

Reputation: 2047

var x= from myrow in myDataTable.asEnumerable() where myrow.ApplicationId==[YourValue] select myRow.[ColumnYouWant];

I am not great when it comes to linq but this should do the trick.

Upvotes: 0

Learning Curve
Learning Curve

Reputation: 1569

I have accomplished my result by making use of the following Linq statement

List<string> lstResult= (from table in dt.AsEnumerable()
                                          where table.Field<int>("Id") == id
                                          select table.Field<string>("status")).ToList();

string dtStatus = lstResult[0];

Upvotes: 3

Saddam Abu Ghaida
Saddam Abu Ghaida

Reputation: 6729

you can do it lik this 

var results = (from  rows in dt.AsEnumerable() select new {resultcolumnname=row["resultcolumnname"]}).where(item=>item.columnname == value).ToList()

Upvotes: 0

Related Questions