Nested Tables in Datagrid???

[Darryn Ross]

Hi there...

I am trying to display both parent and child details in my datagrid at the
same time but i cannot seem to do it. It's either one or the other, if
anyone has any suggestions on how i can do this please let me know.

My current code to establish the relationship and display the datagrid is as
follows...

GLDs.Clear() ;
GLConnection.ConnectionString = AppMain.CompanyConnectionPath ;
GLConnection.Open() ;
//Select commands for both adapters
SelectCommand1.CommandText = "SELECT * FROM " + pPostTable ;
SelectCommand1.Connection = GLConnection ;
SelectCommand2.CommandText = "SELECT * FROM " + pSourceTable ;
SelectCommand2.Connection = GLConnection ;
//Loading Post table details
GLAdapter1.SelectCommand = SelectCommand1 ;
GLAdapter1.MissingSchemaAction = MissingSchemaAction.AddWithKey ;
GLAdapter1.Fill(GLDs, pPostTable) ;
//Loading Source table details
GLAdapter2.SelectCommand = SelectCommand2 ;
GLAdapter2.MissingSchemaAction = MissingSchemaAction.AddWithKey ;
GLAdapter2.Fill(GLDs, pSourceTable) ;
//Setting the table relationship
GLDs.Relations.Add("View Batch Transactions",
GLDs.Tables[pPostTable].Columns["GLBatchID"],
GLDs.Tables[pSourceTable].Columns["GLBatchID"]) ;
//Adding some custom table styles
AddCustomDataTableStyle1() ;
AddCustomDataTableStyle2() ;
//Updating the Datagrids details
dgViewTrans.SetDataBinding(GLDs, pPostTable) ;

Regards

Darryn

[Nicholas Paldino [.NET/C# MVP]]

Darryn,

You can't do this. The datagrid that comes with .NET allows you to
drill down, but not open up child data grids in the same space. You will
have to get a third party control that will do this.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Darryn Ross" <da****@datawave.com.au> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

Hi there...

I am trying to display both parent and child details in my datagrid at the
same time but i cannot seem to do it. It's either one or the other, if
anyone has any suggestions on how i can do this please let me know.

My current code to establish the relationship and display the datagrid is
as
follows...

GLDs.Clear() ;
GLConnection.ConnectionString = AppMain.CompanyConnectionPath ;
GLConnection.Open() ;
//Select commands for both adapters
SelectCommand1.CommandText = "SELECT * FROM " + pPostTable ;
SelectCommand1.Connection = GLConnection ;
SelectCommand2.CommandText = "SELECT * FROM " + pSourceTable ;
SelectCommand2.Connection = GLConnection ;
//Loading Post table details
GLAdapter1.SelectCommand = SelectCommand1 ;
GLAdapter1.MissingSchemaAction = MissingSchemaAction.AddWithKey ;
GLAdapter1.Fill(GLDs, pPostTable) ;
//Loading Source table details
GLAdapter2.SelectCommand = SelectCommand2 ;
GLAdapter2.MissingSchemaAction = MissingSchemaAction.AddWithKey ;
GLAdapter2.Fill(GLDs, pSourceTable) ;
//Setting the table relationship
GLDs.Relations.Add("View Batch Transactions",
GLDs.Tables[pPostTable].Columns["GLBatchID"],
GLDs.Tables[pSourceTable].Columns["GLBatchID"]) ;
//Adding some custom table styles
AddCustomDataTableStyle1() ;
AddCustomDataTableStyle2() ;
//Updating the Datagrids details
dgViewTrans.SetDataBinding(GLDs, pPostTable) ;

Regards

Darryn