Are many-to-one relationships possilble with ADO.Net datasets
I have an orders table in a datagrid. The orders table contains a customer ID field. As the user scrolls the table, I would like to have a textbox outside the grid reflect the customer NAME field from the customer table. This is sort of a classic lookup concept, but I can't seem to figure out how to implement it.
As usual, any help is appreciated.
many-to-one relationships
Hot Topic
- getting the cellValues of a datatbound DGV row before it is removed
- Dialog ZOrder Behind Parent on Win98 / NT
- passing values from form1 to an instance of form2.
- Last Column AutoSize Fill Mode
- Can't Install Terrarium
- can anyone help me to getrid of this error....
- Restrict datagrid for only one new row?
- WYSIWYG HTML Editor Control
- Any free hierarchical grid? (TreeView column)
- Removing focus from my form (application), how ?
Windows Forms
- Couldn't find System.ComponentModel.Design.CollectionEditor
- opening a paticular cell in editMode when dg row is highlighted
- Please help
- What does this mean.."A child row has multiple parents"
- How to draw ImageList items with ImageAttributes applied
- Items in ListView / ListBox change event does not exists
- hosting controls / forms across app domains (alternatives or thoughts)
- I'm going nuts here...
- CheckedListBox and DataMember/ValueMember
- Getting focus to a dialog box
many-to-one relationships
RCroft
Both tables should be on the same dataset, then add a realtion
ds.Relationships.Add(new DataRelation("CustomerOrders",ds.Tables["customers"].Columns["customerID"],ds.Tables["orders"].Columns["customerID"]))
then use the GetParentRow method of the selected row in the orders table to get the customer row and change the textox:
DataRow dr = selectedRow.GetParentRow("CustomerOrders")
TextBox.Text = dr["CustomerName"]
CostumerOrders is the name of the realtion.
I'm not writing the code to get the selectedRow but you shouldn't have trouble with that.
maybe is there a better way to do this in windowsforms, I'm not sure as I'm more oriented to ASP.NET coding.