Linq select value in a datatable column

Question

How do you use LINQ  C   to select the value in a particular column for a particular row in a datatable  The equivalent SQL would be   select NAME from TABLE where ID   0   Thanks in advance

User · Accepted Answer

var name   from r in MyTable             where r ID    0             select r Name    If the row is unique then you could even just do   var row   DataContext MyTable SingleOrDefault r   gt  r ID    0   var name   row    null   row Name   String Empty

User · Answer

I notice others have given the non-lambda syntax so just to have this complete I ll put in the lambda syntax equivalent   Non-lambda  as per James s post    var name   from i in DataContext MyTable            where i ID    0            select i Name   Equivalent lambda syntax   var name   DataContext MyTable Where i   gt  i ID    0                                 Select i   gt  new   Name   i Name       There s not really much practical difference  just personal opinion on which you prefer

User · Answer

var name   from DataRow dr in tblClassCode Rows where  long dr  ID      Convert ToInt32 i  select  int dr  Name    FirstOrDefault   ToString

User · Answer

var x     from row in table           where row ID    0           select row   Supposing you have a DataTable that knows about the rows  other wise you ll need to use the row index   where row rowNumber     0   In this instance you d also want to use the select to place the row data into an anonymous class or a preprepared class  if you want to pass it to another method

User · Answer

Use linq and set the data table as Enumerable and select the fields from the data table field that matches what you are looking for   Example  I want to get the currency Id and currency Name from the currency table where currency is local currency  and assign the currency id and name to a text boxes on the form   DataTable dt   curData loadCurrency                var curId   from c in dt AsEnumerable                           where c Field lt bool gt   LocalCurrency      true                         select c Field lt int gt   CURID                 foreach  int cid in curId                                txtCURID Text   cid ToString                              var curName   from c in dt AsEnumerable                             where c Field lt bool gt   LocalCurrency      true                           select c Field lt string gt   CurName                foreach  string cName in curName                                txtCurrency Text   cName ToString

User · Answer

If the return value is string and you need to search by Id you can use   string name   datatable AsEnumerable   Where row   gt  Convert ToInt32 row  Id       Id  Select row   gt  row Field lt string gt   name    ToString      or using generic variable   var name   datatable AsEnumerable   Where row   gt  Convert ToInt32 row  Id       Id  Select row   gt  row Field lt string gt   name

User · Answer

Thanks for your answers  I didn t understand what type of object  MyTable  was  in your answers  and the following code gave me the error shown below   DataTable dt   ds Tables 0   var name   from r in dt            where r ID    0            select r Name       Could not find an implementation of the query pattern for source type    System Data DataTable     Where  not found   So I continued my googling and found something that does work   var rowColl   ds Tables 0  AsEnumerable    string name    from r in rowColl               where r Field lt int gt   ID      0               select r Field lt string gt   NAME    First lt string gt       What do you think

[c#] Linq : select value in a datatable column

Examples related to c#

Examples related to linq

Examples related to datatable