ID Name Job DeptName
100 g Mgr p1
100 g pur d1
200 f Sal p2
200 f order d2
This is my table with data,i want to retrieve data using data reader using below code,
I want to loop execute two times,One is retrieve data ID with Two(rows) records data,and again retive data loadId alogwith two rows data
Finally total data stored in alist
I am writing above code not getting perfect way of data,can you give me perfect code,once see my code once