Hello Team,
I am facing problem in dynamic creation grid structure and bind data and not able to see nested grid data below is code for same. Please do help me asap.
Looking forward to your response.
RadGridData.AutoGenerateColumns = false;
//generate grid columns/ grid structure
GridBoundColumn ZoneColumn;
GridTableView gridTableView = new GridTableView();
for (int ColumnCount = 0; ColumnCount < ZoneData.Tables[0].Columns.Count; ColumnCount++)
{
ZoneColumn = new GridBoundColumn();
RadGridData.MasterTableView.Columns.Add(ZoneColumn);
ZoneColumn.DataField = Convert.ToString(ZoneData.Tables[0].Columns[ColumnCount]);
ZoneColumn.HeaderText = Convert.ToString(ZoneData.Tables[0].Columns[ColumnCount]);
ZoneColumn.UniqueName = Convert.ToString(ZoneData.Tables[0].Columns[ColumnCount]);
ZoneColumn.SortExpression = Convert.ToString(ZoneData.Tables[0].Columns[ColumnCount]);
gridTableView.AutoGenerateColumns = false;
for (int innerColumnCount = 0; innerColumnCount < ZoneData.Tables[1].Columns.Count; innerColumnCount++)
{
ZoneColumn = new GridBoundColumn();
gridTableView.Columns.Add(ZoneColumn);
ZoneColumn.DataField = Convert.ToString(ZoneData.Tables[1].Columns[innerColumnCount]);
ZoneColumn.HeaderText = Convert.ToString(ZoneData.Tables[1].Columns[innerColumnCount]);
ZoneColumn.UniqueName = Convert.ToString(ZoneData.Tables[1].Columns[innerColumnCount]);
ZoneColumn.SortExpression = Convert.ToString(ZoneData.Tables[1].Columns[innerColumnCount]);
}
RadGridData.MasterTableView.DetailTables.Add(gridTableView);
}
RadGridData.MasterTableView.AutoGenerateColumns = false;
RadGridData.MasterTableView.DetailTables[0].AutoGenerateColumns = false;
GridRelationFields relationFields = new GridRelationFields();
relationFields.MasterKeyField = "ID";
relationFields.DetailKeyField = "ID";
gridTableView.ParentTableRelation.Add(relationFields);
RadGridData.MasterTableView.DataSource = ZoneData.Tables["Zone"]; //ZoneData is dataset with table data
RadGridData.MasterTableView.DetailTables[0].DataSource = ZoneData.Tables["ZoneContract"];
Thanks & Regards
I am facing problem in dynamic creation grid structure and bind data and not able to see nested grid data below is code for same. Please do help me asap.
Looking forward to your response.
RadGridData.
//generate grid columns/ grid structure
GridBoundColumn ZoneColumn;
GridTableView gridTableView = new GridTableView();
for (int ColumnCount = 0; ColumnCount < ZoneData.Tables[0].Columns.
{
ZoneColumn = new GridBoundColumn();
RadGridData.MasterTableView.
ZoneColumn.DataField = Convert.ToString(ZoneData.
ZoneColumn.HeaderText = Convert.ToString(ZoneData.
ZoneColumn.UniqueName = Convert.ToString(ZoneData.
ZoneColumn.SortExpression = Convert.ToString(ZoneData.
gridTableView.
for (int innerColumnCount = 0; innerColumnCount < ZoneData.Tables[1].Columns.
{
ZoneColumn = new GridBoundColumn();
gridTableView.Columns.Add(
ZoneColumn.DataField = Convert.ToString(ZoneData.
ZoneColumn.HeaderText = Convert.ToString(ZoneData.
ZoneColumn.UniqueName = Convert.ToString(ZoneData.
ZoneColumn.SortExpression = Convert.ToString(ZoneData.
}
RadGridData.MasterTableView.
}
RadGridData.MasterTableView.
RadGridData.MasterTableView.
GridRelationFields relationFields = new GridRelationFields();
relationFields.MasterKeyField = "ID";
relationFields.DetailKeyField = "ID";
gridTableView.
RadGridData.MasterTableView.
RadGridData.MasterTableView.
Thanks & Regards