Hi,
I get product details in a DataTable from a webservice that has 4 columns.
RowId (unique), ProductId,SubProductId, Price
I get a DataTable from webservice in batches. It can return only 5000 rows at a time. I pass Start RowId and End Row Id as parameters so that products within that range is returned in a datatable. Row Id is unique but same Product Id can be in multiple rows.
If I call the webservice method three times, I get 3 Datatables with 5000 rows in each table.
I want to get the rows with same Product Id from all the three tables and get the maximum price.
Can I merge 3 table into one table and loop through or can I use LINQ query to fetch data from multiple tables?
How to store the max price of each product in a new table?
Thanks
Ashok
I get product details in a DataTable from a webservice that has 4 columns.
RowId (unique), ProductId,SubProductId, Price
I get a DataTable from webservice in batches. It can return only 5000 rows at a time. I pass Start RowId and End Row Id as parameters so that products within that range is returned in a datatable. Row Id is unique but same Product Id can be in multiple rows.
If I call the webservice method three times, I get 3 Datatables with 5000 rows in each table.
I want to get the rows with same Product Id from all the three tables and get the maximum price.
Can I merge 3 table into one table and loop through or can I use LINQ query to fetch data from multiple tables?
How to store the max price of each product in a new table?
Thanks
Ashok