Please provide me the Sample Code/Example that describes how to bind WebHierarchicalDataGrid with dataset containing multiple tables having N-Level Relationship as follows:
Parent ==>Children==>Grand Children==>Grand Grand Children and so on.
Thanks and regards
A DataSet contains different DataTables. Set for every DataTable a TableName.
Add relations between the DataTables.
Example: ds.Relations.Add("mp1", ds.Tables(0).Columns("ID"), ds.Tables(1).Columns("IDDT0"), True)
Set on the WebHierarchicalDataGrid the DataMember to the name of the Parent DataTable, on the first Band, set the DataMember to the name of the Child DataTable, on the Band of the Child, set the DataMember to the name of the Grand Child DataTable. etc...
Like DataMember set the DataKeyFields.
Assign the DataSet to the DataSource of the WHDG and Do a DataBind()
I hope that this brief explanation helps you achieve your goal.
Sorry but I'm trying to bind a dataset with 2 tables (Partners and Products) and the WebHierarchicalDataGrid only shows the parent rows (Partners) but no the childs rows (Products).
Here is my code:
in aspx file:
<
ig:WebHierarchicalDataGrid ID="WebHierarchicalDataGrid1" runat="server" Height="350px" Width="400px" DataKeyFields="Partner Code" DataMember="Partners">
in.cs file:
ds.Tables.Add(
new DataTable("Partners")); ds.Tables.Add(
new DataTable("Products")); ds.Tables[
ds.Tables[
"Partners"].Columns.Add(new DataColumn("Partner Code",typeof(string
))); ds.Tables[
"Partners"].Columns.Add(new DataColumn("Partner Name", typeof(string
"Products"].Columns.Add(new DataColumn("Product Code", typeof(string
"Products"].Columns.Add(new DataColumn("Product Name", typeof(string
"Products"].Columns.Add(new DataColumn("Partner Code", typeof(string
)));
rowPartner1[
"Partner Code"] = "COD-DIS-A"; rowPartner1[
"Partner Name"] = "Partner A"; ds.Tables[
"Partners"].Rows.Add(rowPartner1);
rowPartner2[
"Partner Code"] = "COD-DIS-B"; rowPartner2[
"Partner Name"] = "Partner B"; ds.Tables[
"Partners"].Rows.Add(rowPartner2);
rowProduct1[
"Product Code"] = "COD-PROD-A"; rowProduct1[
"Product Name"] = "Product A"; rowProduct1[
"Partner Code"] = "COD-DIS-A"; ds.Tables[
"Products"].Rows.Add(rowProduct1);
rowProduct2[
"Product Code"] = "COD-PROD-B"; rowProduct2[
"Product Name"] = "Product B"; rowProduct2[
"Partner Code"] = "COD-DIS-A" ds.Tables[
"Products"].Rows.Add(rowProduct2);
rowProduct3[
"Product Code"] = "COD-PROD-C"; rowProduct3[
"Product Name"] = "Product C"; rowProduct3[
"Partner Code"] = "COD-DIS-B"; ds.Tables[
"Products"].Rows.Add(rowProduct3);
rowProduct4[
"Product Code"] = "COD-PROD-D"; rowProduct4[
"Product Name"] = "Product D"; rowProduct4[
"Products"].Rows.Add(rowProduct4);
rowProduct5[
"Product Code"] = "COD-PROD-E"; rowProduct5[
"Product Name"] = "Product E"; rowProduct5[
"Products"].Rows.Add(rowProduct5); ds.Relations.Add(
ds.Relations.Add(
"Relationship", ds.Tables["Partners"].Columns["Partner Code"
],ds.Tables["Products"].Columns["Partner Code"]);
WebHierarchicalDataGrid1.DataSource = ds; WebHierarchicalDataGrid1.DataBind(); What is wrong? Thanks!!!
WebHierarchicalDataGrid1.DataSource = ds;
WebHierarchicalDataGrid1.DataBind();
What is wrong? Thanks!!!
I don't know if anyone has answered your question since this post is so old. But, if not, the .cs code below is what I came up with as a solution. The significant changes are in bold:
protected void Page_Load(object sender, EventArgs e) { DataSet ds = new DataSet("Partners"); DataColumn[] keys = new DataColumn[1];
ds.Tables.Add(new DataTable("Partners")); ds.Tables["Partners"].Columns.Add(new DataColumn("Partner Code", typeof(string))); ds.Tables["Partners"].Columns.Add(new DataColumn("Partner Name", typeof(string))); keys[0] = ds.Tables["Partners"].Columns["Partner Code"]; ds.Tables["Partners"].PrimaryKey = keys; ds.Tables.Add(new DataTable("Products")); ds.Tables["Products"].Columns.Add(new DataColumn("Product Code", typeof(string))); ds.Tables["Products"].Columns.Add(new DataColumn("Product Name", typeof(string))); ds.Tables["Products"].Columns.Add(new DataColumn("Partner Code", typeof(string))); keys[0] = ds.Tables["Products"].Columns["Product Code"]; DataRow rowPartner1 = ds.Tables["Partners"].NewRow(); rowPartner1["Partner Code"] = "COD-DIS-A"; rowPartner1["Partner Name"] = "Partner A";
ds.Tables["Partners"].Rows.Add(rowPartner1); DataRow rowPartner2 = ds.Tables["Partners"].NewRow(); rowPartner2["Partner Code"] = "COD-DIS-B"; rowPartner2["Partner Name"] = "Partner B"; ds.Tables["Partners"].Rows.Add(rowPartner2); DataRow rowProduct1 = ds.Tables["Products"].NewRow(); rowProduct1["Product Code"] = "COD-PROD-A"; rowProduct1["Product Name"] = "Product A"; rowProduct1["Partner Code"] = "COD-DIS-A"; ds.Tables["Products"].Rows.Add(rowProduct1); DataRow rowProduct2 = ds.Tables["Products"].NewRow(); rowProduct2["Product Code"] = "COD-PROD-B"; rowProduct2["Product Name"] = "Product B"; rowProduct2["Partner Code"] = "COD-DIS-A"; ds.Tables["Products"].Rows.Add(rowProduct2);
DataRow rowProduct3 = ds.Tables["Products"].NewRow(); rowProduct3["Product Code"] = "COD-PROD-C"; rowProduct3["Product Name"] = "Product C"; rowProduct3["Partner Code"] = "COD-DIS-B"; ds.Tables["Products"].Rows.Add(rowProduct3); DataRow rowProduct4 = ds.Tables["Products"].NewRow(); rowProduct4["Product Code"] = "COD-PROD-D"; rowProduct4["Product Name"] = "Product D"; rowProduct4["Partner Code"] = "COD-DIS-B"; ds.Tables["Products"].Rows.Add(rowProduct4); DataRow rowProduct5 = ds.Tables["Products"].NewRow(); rowProduct5["Product Code"] = "COD-PROD-E"; rowProduct5["Product Name"] = "Product E"; rowProduct5["Partner Code"] = "COD-DIS-B"; ds.Tables["Products"].Rows.Add(rowProduct5); ds.Relations.Add("PartnerProduct", ds.Tables["Partners"].Columns["Partner Code"], ds.Tables["Products"].Columns["Partner Code"]);
WebHierarchicalDataGrid1.Bands[0].DataMember = "Products"; WebHierarchicalDataGrid1.Bands[0].DataKeyFields = "Product Code";
WebHierarchicalDataGrid1.DataSource = ds; WebHierarchicalDataGrid1.DataBind(); }
Thanks for your reply
still i am facing the same issue
here is my code
ig:WebHierarchicalDataGrid ID="WebHierarchicalDataGrid2" runat="server" Height="350px" Width="700px" DataKeyFields="Partner Code" DataMember="Partners" AutoGenerateColumns="false" AutoGenerateBands="false" OnRowIslandsPopulating="WebHierarchicalDataGrid1_RowIslandsPopulating" OnInitializeRow="WebHierarchicalDataGrid2_InitializeRow" OnDataBound ="WebHierarchicalDataGrid2_DataBound">
<ExpandCollapseAnimation SlideOpenDirection="Auto" SlideOpenDuration="300" SlideCloseDirection="Auto" SlideCloseDuration="300" />
<Columns>
<ig:BoundDataField DataFieldName="Partner Code" Key="PartnerCode" Header-Text="Code" />
<ig:BoundDataField DataFieldName="Partner Name" Key="Name" Header-Text="Name" Width="230px" />
</Columns>
<Bands>
<ig:Band DataKeyFields="Product Code" DataMember="Products"></ig:Band>
</Bands>
</
ig:WebHierarchicalDataGrid>
And in .VB file i placed the above code @ Page Load
Please help me!
>
Its working for me
Thanks!!