Hierarchical GridView - winform bind in code

[Richard Thurgood]

Okay, I know I'm missing something here. I'm using the latest version of Rad for WinForms (Q1 2008) and I'm trying to populate a RadGridView using code only (not the BindingSource control). Can you tell me why this code isn't working?

private void PopulateGrid()
{
 DataSet ds = GetMasterDetail();
 radGridView1.DataSource = ds;
}

private DataSet GetMasterDetail()
{
  DataTable master = Clients.GetMasterList();
  master.TableName = "Clients";
  DataTable child = Orders.GetChildList();
  child.TableName = "Orders";

  DataSet ds = new DataSet();
  ds.Tables.Add(master.Copy());
  ds.Tables.Add(child.Copy());

  DataRelation relationship = new DataRelation("MasterDetail", ds.Tables["Clients"].Columns["ClientID"], ds.Tables["Orders"].Columns["ClientID"]);
  ds.Relations.Add(relationship);

  return ds;
}

[Julian Benkov]

Hello Richard,

All your code looks right, except for the DataMember property of RadGridView, which is not set in this scenario. Your PopulateGrid method should be changed to following:

private void PopulateGrid()
{
    DataSet ds = GetMasterDetail();
    radGridView1.DataMember = "Clients";
    radGridView1.DataSource = ds;
}

I hope this helps. If you have further questions, feel free to write back.

Kind regards,
Julian Benkov
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Richard Thurgood]

I tried that but I was setting the DataMember after binding the datasource and it bombed. Duh!  My fault. Asside from that, I also needed to set the AutoGenerateHierarchyFromDataSet property to true.  So, here's what worked:

private void PopulateGrid()
{
 DataSet ds = GetMasterDetail();
 
 radGridView1.AutoGenerateHierarchyFromDataSet  = true;
 radGridView1.DataMember = "Clients";
 radGridView1.DataSource = ds;
}

private DataSet GetMasterDetail()
{
  DataTable master = Clients.GetMasterList();
  master.TableName = "Clients";
  DataTable child = Orders.GetChildList();
  child.TableName = "Orders";

  DataSet ds = new DataSet();
  ds.Tables.Add(master.Copy());
  ds.Tables.Add(child.Copy());

  DataRelation relationship = new DataRelation("MasterDetail", ds.Tables["Clients"].Columns["ClientID"], ds.Tables["Orders"].Columns["ClientID"]);
  ds.Relations.Add(relationship);

  return ds;
}

[Narendra]

Hello,

    i was also trying to bind Hierarchical grid in code behind. But cant make it.
    i am trying to read from xml file and loaded to dataset.

    i have set  propery AutoGenerateHierarchyFromDataSet =true.
    but still i am unable to bind data in Hierarchical  format. 
    code goes here, Please check once let me know what was my mistake.

public frmBOM()
{
InitializeComponent();
PopulateGrid();
}

private void PopulateGrid()
{
DataSet ds = GetMasterDetail();
radGridView1.AutoGenerateHierarchyFromDataSet = true;
radGridView1.DataMember = "MasterDataHeader";
radGridView1.DataSource = ds;
}

private DataSet GetMasterDetail()
{
DataSet dsMaster = new DataSet();
dsMaster.ReadXml("c:\\My Documents\\Visual Studio 2008\\Projects\\MyTestFopl\\MyTestFopl\\dtMaster.xml");
DataSet dsChild = new DataSet();
dsChild.ReadXml("c:\\My Documents\\Visual Studio 2008\\Projects\\MyTestFopl\\MyTestFopl\\dtChild.xml");
DataTable master = dsMaster.Tables["MasterDataHeader"];
DataTable child = dsChild.Tables["MasterDataDetails"];
master.TableName = "MasterDataHeader";
child.TableName = "MasterDataDetails";
DataSet ds = new DataSet();
ds.Tables.Add(master.Copy());
ds.Tables.Add(child.Copy());
DataRelation relationship = new DataRelation("MasterDetail", ds.Tables["MasterDataHeader"].Columns["MDHCode"], ds.Tables["MasterDataDetails"].Columns["MDHCode"]);
ds.Relations.Add(relationship);
return ds;
}

 

Please suggest me what i am doing wrong.

Thanks in advance.
Regards
Narendra P 
    

[Julian Benkov]

Hi Narendra,

Your code looks ok - we did not find any errors or omissions in it. Please, open a support ticket and send us a simple project to reproduce this issue locally. Thank you in advance.

 
Sincerely yours,
Julian Benkov
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.