posting values in 2 data grids

  • Thread starter Thread starter sups sups via .NET 247
  • Start date Start date
S

sups sups via .NET 247

Hi ..
please see the code below..
I have two tables Centrals and Devices both having Central_Id asa common field..I am able to display the Centals table value inthe first datagrid (dataGirdCentral).However on click of eachcell on the central_id i want the corresponding entries ofDevices table to be shown in the 2nd datagriddataGridDevices..how do i do that...

private void loadCentralDevices()
{
ds = new DataSet();
//Getting schema of Centrals table
DataTable centralDt = new DataTable("Centrals");
String query = "Select * from Centrals";
OleDbDataAdapter da = newOleDbDataAdapter(query,ConfigurationSettings.AppSettings["MsAccess_ConnectString"]);
da.FillSchema(centralDt, SchemaType.Source);
ds.Tables.Add(centralDt);


//Getting schema of Devices table
DataTable deviceDt = new DataTable("Devices");
String query1 = "Select * from Devices";
da = newOleDbDataAdapter(query1,ConfigurationSettings.AppSettings["MsAccess_ConnectString"]);
da.FillSchema(deviceDt,SchemaType.Source);
ds.Tables.Add(deviceDt);

DataRelation dr = new DataRelation("Central_Devices_Relation",
centralDt.Columns["Central_ID"], deviceDt.Columns["Central_Id"]);
ds.Relations.Add(dr);

//create a dataview of the data
DataView centralVw = new DataView(ds.Tables["centralDt"]);
//giving access to Centrals table
centralVw.AllowDelete=true;
centralVw.AllowEdit = true;
centralVw.AllowNew = true;
//set the grid source to the author view
dataGridCentral.DataSource = centralVw;
//hook up the event handler
dataGridCentral.CurrentCellChanged+= newEventHandler(this.dataGridCentral_CellChanging);

}


private void dataGridCentral_CellChanging(object sender,EventArgs eArgs)
{
????? what do i write here to get the corresponding values?
}

sups
 
private void dataGridCentral_CellChanging(object sender, EventArgs eArgs)
{
Object oData = grid.DataSource
DataView dvParent = null
if (oData is DataTable
dvCentral= ((DataTable)oData).DefaultView
els
dvCentral= (DataView) oData

DataRowView drvCentral= dvCentral[dataGridCentral.CurrentCell.RowNumber]

dataGridDevice.DataSource = drvCentral.CreateChildView("Central_Devices_Relation")

}

Hope this helps. You might need to modify a little bit

Bin Song, MC
 
Back
Top