c# - LINQ Select DataRow from DataTable -

i have datatable trying simple select row contains value.

my code

  var logindetails = myrow in dtoperators.asenumerable()                            myrow.field<string>(0) == username                            select myrow; 

i trying check if string username exists @ position 0 rows in datatable

when run query blank datarow back.

i have tried use [] around position want select.

anyone able see doing wrong.

you have check if comparing right column , check data in table. work fine:

var dtoperators = new datatable(); var username = "test"; dtoperators.columns.add("username", typeof(string)); dtoperators.rows.add("test1"); dtoperators.rows.add("test"); var logindetails = myrow in dtoperators.asenumerable()                      myrow.field<string>(0) == username                      select myrow; 

i've got enumerable 1 datarow. try data columnname:

var logindetails = dtoperators.rows                               .cast<datarow>()                               .where(x => x["username"] == username).tolist();