I have a set of a data in a table, (Attached the screen shot). In this table i would like to get the data of ‘amount’ column where state=‘CA’. This dataset is dynamic, some days there are 3 rows with stat=‘CA’ and other days it may be 5. Please suggest some ideas to get this data from the table.
First extract the data to datatable using extract Structure data.(dt)
After getting the hole table just apply the filter condition.
If you want only Amount then use the below query , it will give you the lamount which satisfies the condition as a list of strings.
Let us take your datatable as dt
ListA=(From p in dt.Select