Relations + ADO.NET ?[Resolved]

I'm getting this error that says : "This constraint cannot be enabled as not all values have corresponding parent values "


I'm getting data from two relational tables . Hmm , have a look at the code .

How can I solve this problem ?:rolleyes:

Code:

---

public void ShowInGrid()
{
DataSet ds;
//two commands for MainCat_Tab & SubCat_Tab tables
System.Data.OleDb.OleDbCommand cmd;
System.Data.OleDb.OleDbCommand cmd2;

//two adapters for filling ds obj
System.Data.OleDb.OleDbDataAdapter adp;       
System.Data.OleDb.OleDbDataAdapter adp2;


//this handles the relationship between
//the two columns
System.Data.DataRelation datarelation;
System.Data.DataColumn dc1;
System.Data.DataColumn dc2;
                               

ds =new DataSet();
ds.CaseSensitive=true;
//First command for first table
cmd=new OleDbCommand ();
cmd.Connection=DBSpace.FunctionClass.MyConnection;
cmd.CommandText="SELECT * FROM MainCat_Tab";

//Second command for Second table
cmd2=new OleDbCommand ();
cmd2.Connection=DBSpace.FunctionClass.MyConnection;
cmd2.CommandText="SELECT * FROM SubCat_Tab";

//first table
adp=new OleDbDataAdapter ();
adp.SelectCommand =cmd;
adp.TableMappings.Add("Table","MainCat_Tab");
adp.Fill(ds);

                       
//Second table
adp2=new OleDbDataAdapter ();
adp2.SelectCommand=cmd2;
adp2.TableMappings.Add ("Table","SubCat_Tab");
adp2.Fill(ds);

dc1=ds.Tables["MainCat_Tab"].Columns["MainCat_ID"];
                        dc2=ds.Tables["SubCat_Tab"].Columns["SubCat_ID"];
datarelation=new System.Data.DataRelation("MainCat_TabToSubCat_Tab",dc1,dc2);

ds.Relations.Add (datarelation);
                       
Here is the error dataGrid1.DataSource=ds;//.DefaultViewManager;
dataGrid1.DataMember="MainCat_Tab";
}

---

I dont have any idea what the problem might, since I have'nt really worked with DataRelations. You might wanna try it with typed DataSets.

Quote:

---

Originally posted by DevGrp
I dont have any idea what the problem might, since I have'nt really worked with DataRelations. You might wanna try it with typed DataSets.

---

I have no idea about this thing ,:rolleyes: . Do you think this might help solving my problem ?

It might help. I'll write a small demo when I get home. BTW what does your table relationship look like? Also what exactly are you trying to accomplish?

Quote:

---

Originally posted by DevGrp
It might help. I'll write a small demo when I get home. BTW what does your table relationship look like? Also what exactly are you trying to accomplish?

---

I want to add two tables with DataRelations and add them to one dataset then to datagrid . Is that clear ?:rolleyes:

Thanks man .

Do you want each table bound to a different datagrid?

Quote:

---

Originally posted by DevGrp
Do you want each table bound to a different datagrid?

---

NO :D , I'm following the same example written in a book here . I wrote the code , it showed two tables in one DataGrid. My code seems fine , but ....:rolleyes:

Quote:

---

Originally posted by Pirate
NO :D , I'm following the same example written in a book here . I wrote the code , it showed two tables in one DataGrid. My code seems fine , but ....:rolleyes:

---

I dont understand. Why dont you post the project and I'll take a look at it.

The whole proj is the code I posted at the top (all of it) . I don't have other code though (the database is full now with 200 records ) .

Yeeeeeeees , I did it . You know what was the problem . I had to map the same column because there is a relation between them (not with SubCat_ID) . hehe , very simple , like this :

Code:

---

dc1=ds.Tables["MainCat_Tab"].Columns["MainCat_ID"];
dc2=ds.Tables["SubCat_Tab"].Columns["MainCat_ID"];

---

Thanks DevGrp for trying to help .:)

Glad to here that you found the problem.

Happy coding.:)