Data Grid - Displaying a related column instead of parent id - URGENT HELP PLEASE

[Dawnyy]

I'm in desperate need of knowing how I can bind my data grid so that I have the following

Customer ID - parent table
Customer Name - parent table
Status ID - parent table
Status Description - related table status

I want to pull in the status description from the relation I have set up on the dataset between the customer table and the status table based on the status ID!

Does anyone know how to do this?

I tried going into edit columns on the grid and changing the DataPropertyName to the Foreign Key link and the Status Description column, but the data does not appear!

I am filling the customer and status tables in the load event of the form.

Any help would be greatly appreciated!

[agarwalsunitadhn]

I'm in desperate need of knowing how I can bind my data grid so that I have the following

Customer ID - parent table
Customer Name - parent table
Status ID - parent table
Status Description - related table status

I want to pull in the status description from the relation I have set up on the dataset between the customer table and the status table based on the status ID!

Does anyone know how to do this?

I tried going into edit columns on the grid and changing the DataPropertyName to the Foreign Key link and the Status Description column, but the data does not appear!

I am filling the customer and status tables in the load event of the form.

Any help would be greatly appreciated!

why dont you try to manually bind the datagrid with coding
like this

OleDbConnection conn=new OleDbConnection(conectionstr);
string str="select pt.CustomerId,pt.CustomerName,pt.StatusId,rt.Statu sDesc from parenttable pt,relatedtable rt where rt.CustomerId=pt.CustomerId";
OleDbCommand cmd=new OleDbCommand(str,conn);
OleDbDataAdapter ada=new OleDbDataAdapter(cmd);
DataSet ds=new DataSet();
ada.Fill(ds);

Datagrid.DataSource=ds;
DataGrid.DataBind();

and must set AutoGenerateClomns to false from datagrid property

I think this code will must help

[shlabadoo]

I'm not sure if this works for DataGrids, but for a DataGridView you can set a column to be a ComboBox instead of a textbox. Then you can set both the display property and the value property to the other table.

When you change it to a dataGridViewComboBoxColumn you get some other options in the Data section of the edit columns dialog.

There is DataPropertyName, DataSource, DisplayMember, and ValueMember. Set the DataPropertyName to the key that you are trying to not show, the DataSource to the binding source of the secondary table, DisplayMember to the name of the column you want to actually display and ValueMember to the primarykey of that table.

Then you can change the DisplayStyle to Nothing to get rid of the dropdown arrow.

Hopefully that pertains to your situation.

-dan