I Couldnt Can U? (Master Detail Relationship)
Hi.
I have 2 data grids,one at the top of a form and one at bottom of the form . Both have text boxes beneath them. As the user scrolls through the data grid he sees the corresponding values in the text boxes.The first grid contains the Centrals data and the 2nd grid contains the Devices data.I have coded that part except the problem is (Oki lemme tell u abt the daatbase)
I have 4 tables
Centrals Devices Groups DeviceTypes
CentralID DeviceID Group_Id DeviceType_ID
IP CentralID GroupDesc
TCPPort Group_ID
DeviceType_Id
Now I have two combo boxes below the 2nd datagrid that display the group_id and DeviceType_ID from the devices table.I want that all the groups and all the devices shld be displayed in the combo. the problem is that it doesnt
I have posted the code.What I want is that it should show me all the values of the groups and devicetypes in the 2 combo and that when i update the fields in the text boxes or the datagrid the database should also be updated on the click.The 2 update buttons will be below each datagrids along with the textboxes.
ds = new DataSet();
String query = "Select * from Centrals";
da = new OleDbDataAdapter(query,ConfigurationSettings.AppSettings["MsAccess_ConnectString"]);
DataTable centralDt = new DataTable("Centrals");
da.Fill(centralDt);
ds.Tables.Add(centralDt);
//Devices table
String query1 = "Select * from Devices";
da = new OleDbDataAdapter(query1,ConfigurationSettings.AppSettings["MsAccess_ConnectString"]);
DataTable deviceDt = new DataTable("Devices");
da.Fill(deviceDt);
ds.Tables.Add(deviceDt);
DataRelation dr = new DataRelation("Central_Devices_Relation",
centralDt.Columns["Central_Id"], deviceDt.Columns["Central_Id"]);
ds.Relations.Add(dr);
dsView = ds.DefaultViewManager;
dataGridCentral.DataSource = dsView;
dataGridCentral.DataMember = "Centrals";
dataGridDevice.DataSource = dsView;
dataGridDevice.DataMember = "Centrals.Central_Devices_Relation";
//Binding txt to the 1st datagrid
txtCentralId.DataBindings.Add("Text", dsView,"Centrals.Central_Id");
txtDesc.DataBindings.Add("Text",dsView,"Centrals.CentralDescription");
txtIP.DataBindings.Add("Text",dsView,"Centrals.IP");
txtTCP.DataBindings.Add("Text",dsView,"Centrals.TCPPort");
txtConn.DataBindings.Add("Text",dsView,"Centrals.ConnectionTimeout");
txtShip.DataBindings.Add("Text",dsView,"Centrals.SendTimeout");
txtReception.DataBindings.Add("Text",dsView,"Centrals.ReceiveTimeout");
txtID.DataBindings.Add("Text",dsView,"Centrals.DeviceID");
txtStartAdd.DataBindings.Add("Text",dsView,"Centrals.RWStartAddress");
txtAddCnt.DataBindings.Add("Text",dsView,"Centrals.RWCount");
//Binding txt to 2nd dataGrid
txtDevID.DataBindings.Add("Text",dsView,"Centrals.Central_Devices_Relation.Device_Id");
txtDevDesc.DataBindings.Add("Text",dsView,"Centrals.Central_Devices_Relation.DeviceDescription");
txtPort.DataBindings.Add("Text",dsView,"Centrals.Central_Devices_Relation.Port");
cboArmed.DataBindings.Add("Text",dsView,"Centrals.Central_Devices_Relation.Armed");
cmbType.DataSource = dsView;
cmbType.DisplayMember = "Centrals.Central_Devices_Relation.DeviceType";
cmbGrp.DataSource = dsView;
cmbGrp.DisplayMember = "Centrals.Central_Devices_Relation.Group_Id";
}
}
-----
Code for modification of data
if(!ds.HasChanges(DataRowState.Modified)) return;
DataSet xDataSet;
xDataSet = ds.GetChanges(DataRowState.Modified);
da.Update(xDataSet);
MessageBox.Show("Data modified");
Thanks in advance.