Getting a value from datatable

Question

enter image description here

I have a Datatable like this.Now how can i pick the value from zones based on weight and zone.I am doing this in c#

You have "a database like this"? It looks like a grid. Please specify the question. — Tarec, May 14 '14 at 09:33
Its a screenshot of a datatable in preview mode in vs. Tarec. Completely plausable question — Jonny, May 14 '14 at 09:39

score 1 · Accepted Answer · edited May 23 '17 at 11:45

1

Using LINQ Query : You need to use the AsEnumerable() extension for DataTable

    var results = from myRow in myDataTable.AsEnumerable()
                  where myRow.Field<int>("RowNo") == 1
                  select myRow;

AsEnumerable() returns IEnumerable. If you need to convert IEnumerable to a DataTable, use the CopyToDataTable()

Check Here

edited May 23 '17 at 11:45

Community

answered May 14 '14 at 09:39

Ramy M. Mousa

score -1 · Answer 2 · answered May 14 '14 at 09:39

-1

If you want to pick cells/rows with criteria. you need to a select clauase in your datatable. Go Here to see some examples

answered May 14 '14 at 09:39

Jonny

2 Answers2