Dynamic array with dynamic number of variables with dynamic variable names

Asked Sep 25 '13 at 17:34

Active Sep 26 '13 at 02:47

Viewed 125 times

I have two sql Datareaders . 1st Data reader with fixed number of columns and fixed column names.2nd Data reader with dynamic number of columns with dynamic names. How can I combine data from two result sets in a single array list. I need to use this array list to brind values to jqgrid.

1st result set from sql

RequestNumber| OrderedQty | ReceivedQty 
101             100              90
102             500              420
103             10               10

2nd result set from sql

RequestNumber |BrokenKnobs| BrokenLens| WaterDamaged
101             10             9             10
102             5              4             4
103             1              1             4


RequestNumber |BrokenConnector| MissingComponents
104            10               9            
105             5               4             
106             1               1

For all requests , 1st result set has same number of columns and same column name. 2nd result set changes depending on input values. Number of columns and column name both changes with every input with request number column remains same for all requests.

edited Sep 26 '13 at 02:47

HK1

11,941
14
64
99

asked Sep 25 '13 at 17:34

kalyanasundaram v

have you tried [LINQ](http://msdn.microsoft.com/en-us/library/vstudio/bb397926.aspx)? – Emmanuel N Sep 25 '13 at 17:36
No, Can you please tell me how can I do it with LINQ – kalyanasundaram v Sep 25 '13 at 17:41
What linq is is a quering language, you can query and combine results from different list. can you post your code? – Emmanuel N Sep 25 '13 at 17:44

Dynamic array with dynamic number of variables with dynamic variable names

0 Answers0