HI
Iam reading from excel file and I store values into data tables.
Thanks
Tank50
You say that you want to store data from Excel file and store into two DataTable instances - You are going to split your data.
If you want to add relationship between two tables - one table must have a primarykey and another table must have a same datatype field in which relationship exists.
.....
.....
// Two DataTable instances
DataTable dt1=new DataTable("Table1");
DataTable dt2=new DataTable("Table2");
dt1.Columns.Add("No",typeof(int));
dt1.Columns.Add("Name");
dt2.Columns.Add("No",typeof(int));
dt2.Columns.Add("Data",typeof(int));
// Adding a primary key
dt1.PrimaryKey=new DataColumn[]{dt1.Columns[0]};
// Create an instance of DataSet
DataSet ds=new DataSet("DB");
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);
ds.Relations.Add("Relation1",dt1.Columns[0],dt2.Columns[0]);
...
...
Reputation Points: 2136
Solved Threads: 1228
Posting Genius
Offline 6,527 posts
since Oct 2008
Unsolved 
