how Create an object instance from data in a data table of dataset

Question

I have a stored procedure with ref cursors. I got all the data populated in a data set from the stored procedure in my application. For each data table in the data set I have an object in my application. What is the best way to populate these objects with the data in the data tables. Thank you Sravan.

Andrzej Wegierski · Answer

Should be: class Customer { private string ssn; private string fname; private string lname; private custOrders[] cOrders; } int cnt=tableCustomers.Rows.Count; Customer[] aCust=new Customer[cnt]; for(int p=0;p<cnt;p++) { aCust[p].ssn=tableCustomres.Rows[p][ssn].ToString(); ... } But I think it's a bad solution to use datatables to copy their content to objects ... Use only datatables or only objects. You can fill object whits ADONET reader objects.

romantic_me2003 · Answer

Kind of objects I have are nested objects. Example. customer and custOrders. class Customer { private string ssn; private string fname; private string lname; private ArrayList cOrders; } class custOrders { private string custSsn; private string orderNum; private string itemName; private string quantity; .... } where cOrders private memeber in Customer is a type of custOrders. And the data set I have is having two tables. table1 with only one customer detail in it and table2 with all customer orders of that SSN in it but no relation established.

Andrzej Wegierski · Answer

What kind of objects do You have?