Related Tables

Hi csanchez if u want to create a relation between Customers & Orders Tables , you can do this: parentCol = ds.Tables["Customers"].Columns["Customer_ID"]; childCol = ds.Tables["Orders"].Columns["Customer_ID"]; // create a Relation called "CustOrder" DataRelation dr = new DataRelation("CustOrder", parentCol, childCol) // add a relation ds.Relations.Add(dr); now datarelation added in your dataset if u want to get a specific row, you can use SelectedIndex prop int x = listBox1.SelectedIndex; parentRow = ds.Tables["Customers"].Rows[x]; childRow = parentRow.GetChildRows(dr); foreach(DataRow drow in childRow) { Console.WriteLine(drow["Column1"]+" "+["Column2"].ToString()); } then u will get all the related records for that particular row. if u still have questions, then u can ask me. bye

Somebody knows about DataSet.Relations.Add() and GetChildRows()? How do they work? thanx.

What is a trigger? My questions are: For example: I have the next Data Base: *Customers* ---------------- ID_Customer Name Address TelephoneNum *Orders* ------------- ID_Order ID_Cliente Date - I want to create a relationship (Customers.ID_Customer = Orders.ID_Customer). How can I create it? - In my application the user can delete a customer, but I want to know wether or not the customer have orders, if the costumer have one or more orders I have to display a message: "Is not possible delete this Customer". How can I do it? Thanx Carlos

That's why you have relationships in a database. you can use a trigger.