About the data from different tables

Jun 15 2015 10:28 PM
Crystal Reports, Array List and DataObject
I have three tables   
table1: col1,col2,productcode,creation date,whscode,hold,holdweight 
table2: compcode,compname 
table3:productcode,productdesc 
table4:whscode,whsdesc   
I have created a data object with all three table colomuns like 
class mycls 
{
 private col1{get,set} etc (i created variables for the three tables as well 
}   
Now previously i have a dataset that contains executed select statements on these three tables   
now i want to replace my dataset and i want the data from the data from db to be passed to set methods in the dataobject class and the objects of this class is created as an arraylist and then the array list is fed to the crystal reports.  
 thanks and regards 
Srikanth S