Hi...
I have this DataTable: StockContract.D ictionary. I need a linq to DataTable
query that will select all rows where the "Word" column values match the
WordTextBox.Tex t value. I am running into some problems since the linq query
isn't totally like sql queries. If I wrote the query I am looking for in
sql, it would look like this:
select Word from StockContract.D ictionary where Word = WordTextBox.Tex t;
I then need to take the results of the query and determine if the value in
WordTextBox.Tex t is already in the column "Word" somewhere. Is there an
example of this somewhere?
I found this linq to DataTable on a google search, but it makes no sense to
me. Can somebody break it apart?
var query = from c in table.AsEnumera ble() select new { Week =
c.Field<string> ("Week"), Person = c.Field<string> ("Person"), Guess =
c.Field<string> ("Guess"), Actual = c.Field<string> ("Actual") };
I have this DataTable: StockContract.D ictionary. I need a linq to DataTable
query that will select all rows where the "Word" column values match the
WordTextBox.Tex t value. I am running into some problems since the linq query
isn't totally like sql queries. If I wrote the query I am looking for in
sql, it would look like this:
select Word from StockContract.D ictionary where Word = WordTextBox.Tex t;
I then need to take the results of the query and determine if the value in
WordTextBox.Tex t is already in the column "Word" somewhere. Is there an
example of this somewhere?
I found this linq to DataTable on a google search, but it makes no sense to
me. Can somebody break it apart?
var query = from c in table.AsEnumera ble() select new { Week =
c.Field<string> ("Week"), Person = c.Field<string> ("Person"), Guess =
c.Field<string> ("Guess"), Actual = c.Field<string> ("Actual") };