comparing two dataTables

[Twyce]

I am trying to create a relation between two datatables.Here is the code i am using SqlConnection conDatabase = new SqlConnection(databaseConnectionString); SqlCommand cmdDatabase = new SqlCommand("SELECT * FROM StudentModule",conDatabase); SqlDataAdapter daDatabase = new SqlDataAdapter(cmdDatabase); //Get Columns for DataRelation DataColumn[] databaseColumns = new DataColumn[dsImport.Tables[0].Columns.Count]; for (int i = 0; i < databaseColumns.Length;i++) { databaseColumns[i] = dsImport.Tables[0].Columns[i]; } OleDbConnection conSpread = new OleDbConnection(spreadSheetConnectionString); OleDbCommand cmdSpread = new OleDbCommand("SELECT * FROM[Sheet1$]",conSpread); OleDbDataAdapter daSpread = new OleDbDataAdapter(cmdSpread); //Get Columns for DataRelation DataColumn[] spreadColumns = new DataColumn[dsImport.Tables[1].Columns.Count]; for (int i = 0; i < spreadColumns.Length;i++) { spreadColumns[i] = dsImport.Tables[1].Columns[i]; } //Create DataRelation DataRelation r = new DataRelation(string.Empty,databaseColumns, spreadColumns,false); dsImport.Relations.Add(r); The problem is that when i debug and step into the code the debugger does not go into the for loops,and therefore does not load the columns.What could be causing this plz help?

[Syed Mehroz Alam]

Looks you missed the statement to fill the DataSet.

daDatabase.Fill(dsImport)

Regards, Syed Mehroz Alam

My Blog My Articles

[Twyce]

Thank you very much.i did not see that

[Twyce]

i filled the dataset but it is still doing the same thing. Anything else i'm missing???

[Syed Mehroz Alam]

It seems that you want to fill the same dataset in both the queries. Are you sure you are using the correct overload of Fill()[^] method.?

My Blog My Articles

[Twyce]

yes I want to Fill thesame dataset so that the comparison can be done and then create a third datatable