Dynamical data binding | Infragistics Forums

425

Dynamical data binding

help 123 posted over 10 years ago

Hello togheter,

could somebody please support me by the following data binding issue:

On my web site I have two buttons (A & B).

When I click button A, I would like to bind data source A with the dedicated columns to the WebHierarchicalDataGrid.

When I click button B, I would like to bind data source B with the dedicated columns to the WebHierarchicalDataGrid.

HTML:

<body>

<div>

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

<ig:WebHierarchicalDataGrid ID="WebHierarchicalDataGrid1" runat="server" Height="500px" Width="400px">

<ig:Activation Enabled="true"></ig:Activation>

<ig:Selection Enabled="true" RowSelectType="Single" CellClickAction="Row" ></ig:Selection>

<ig:RowSelectors Enabled="true" RowNumbering="true" EnableInheritance="true"></ig:RowSelectors>

<ig:Paging Enabled="true" EnableInheritance="true" PagerMode="Numeric" PageSize="100"></ig:Paging>

<ig:Sorting Enabled="true" EnableInheritance="true" SortingMode="Single"></ig:Sorting>

</Behaviors>

</ig:WebHierarchicalDataGrid>

<asp:Button ID="Button_A" runat="server" Text="Button_A" OnClick="Button_A_Click" />

<asp:Button ID="Button_B" runat="server" Text="Button_B" OnClick="Button_B_Click" />

</div>

</form>

</body>

Page_Load:

if(!Page.IsPostBack)

{

Session["DataSource_Session"] = null;

WebHierarchicalDataGrid1.AutoGenerateColumns = false;

}

object data = Session["DataSource_Session"];

if(data != null)

{

if (data.GetType() == typeof(A[]))

{

WebHierarchicalDataGrid1.DataKeyFields = WebHierarchicalDataGrid1.Columns[0].Key;

WebHierarchicalDataGrid1.DataSource = (A[])data;

WebHierarchicalDataGrid1.DataBind();

}

else if (data.GetType() == typeof(B[]))

{

WebHierarchicalDataGrid1.DataKeyFields = WebHierarchicalDataGrid1.Columns[0].Key;

WebHierarchicalDataGrid1.DataSource = (B[])data;

WebHierarchicalDataGrid1.DataBind();

}

Button_Click_Event:

protected void Button_B_Click(object sender, EventArgs e)

{

try

{

WebHierarchicalDataGrid1.Columns.Clear();

WebHierarchicalDataGrid1.GridView.ClearDataSource();

BoundDataField dtf = new BoundDataField();

dtf.Header.Text = "Unique ID";

dtf.Key = "uniqueID";

dtf.DataFieldName = "uniqueID";

BoundDataField dtf1 = new BoundDataField();

dtf1.Header.Text = "Value B";

dtf1.Key = "valueB";

dtf1.DataFieldName = "valueB";

WebHierarchicalDataGrid1.Columns.Add(dtf);

WebHierarchicalDataGrid1.Columns.Add(dtf1);

B[] valueList = new B[10];

for (int i = 0; i < 10; i++)

{

B obj = new B();

obj.uniqueID = i;

obj.valueB = "Value B " + i.ToString();

valueList[i] = obj;

}

WebHierarchicalDataGrid1.DataKeyFields = WebHierarchicalDataGrid1.Columns[0].Key WebHierarchicalDataGrid1.DataSource = valueList;

WebHierarchicalDataGrid1.DataBind();

WebHierarchicalDataGrid1.GridView.DataKeyFields = WebHierarchicalDataGrid1.DataKeyFields;

WebHierarchicalDataGrid1.GridView.DataSource = WebHierarchicalDataGrid1.DataSource;

WebHierarchicalDataGrid1.GridView.DataBind();

WebHierarchicalDataGrid1.RefreshBehaviors();

Session["DataSource_Session"] = valueList;

}

catch (Exception ex)

{

string msg = ex.Message;

}

protected void Button_A_Click(object sender, EventArgs e)

{

try

{

WebHierarchicalDataGrid1.Columns.Clear();

WebHierarchicalDataGrid1.GridView.ClearDataSource();

BoundDataField dtf = new BoundDataField();

dtf.Header.Text = "Unique ID";

dtf.Key = "uniqueID";

dtf.DataFieldName = "uniqueID";

BoundDataField dtf1 = new BoundDataField();

dtf1.Header.Text = "Value A";

dtf1.Key = "valueA";

dtf1.DataFieldName = "valueA";

WebHierarchicalDataGrid1.Columns.Add(dtf);

WebHierarchicalDataGrid1.Columns.Add(dtf1);

A[] valueList = new A[10];

for (int i = 0; i < 10; i++)

{

A obj = new A();

obj.uniqueID = i;

obj.valueA = "Value A " + i.ToString();

valueList[i] = obj;

}

WebHierarchicalDataGrid1.DataKeyFields = WebHierarchicalDataGrid1.Columns[0].Key WebHierarchicalDataGrid1.DataSource = valueList;

WebHierarchicalDataGrid1.DataBind();

WebHierarchicalDataGrid1.GridView.DataKeyFields = WebHierarchicalDataGrid1.DataKeyFields;

WebHierarchicalDataGrid1.GridView.DataSource = WebHierarchicalDataGrid1.DataSource;

WebHierarchicalDataGrid1.GridView.DataBind();

WebHierarchicalDataGrid1.RefreshBehaviors();

Session["DataSource_Session"] = valueList;

}

catch (Exception ex)

{

string msg = ex.Message;

}

Data_Source_Class:

public class A

{

Int64 _uniqueID;

public Int64 uniqueID

{

get { return _uniqueID; }

set { _uniqueID = value; }

}

string _valueA;

public string valueA

{

get { return _valueA; }

set { _valueA = value; }

}

public class B

{

Int64 _uniqueID;

public Int64 uniqueID

{

get { return _uniqueID; }

set { _uniqueID = value; }

}

string _valueB;

public string valueB

{

get { return _valueB; }

set { _valueB = value; }

}

Thanks in advanced.

Parents

17590

Offline Vasya Kacheshmarova posted over 10 years ago

Hello help123,

Thank you for posing in our community.

I made a small sample from the code snippets provided. I noticed that you are trying to set the data source for the WebHierarchialDataGrid multiple times. I removed the additional data bindings and on my side the sample was working as expected.

I am attaching the sample project for your reference. Please test this on your side and let me know whether it helps you achieve your requirement.

Please feel free to contact me if you have any additional questions regarding this matter.

WHDG.zip
Cancel
Reply

Cancel
425

help 123 posted over 10 years ago in reply to Vasya Kacheshmarova

Hello,

thank you for the fast support. Unfortunatelly it is not working properly on my site. The pageing, sorting and grouping doesn't work as expected.

I have a working solution with 'AutoGenerateColumns = true' (see below). All I need is to substitute the 'AutoGenerateColumns = true' with BoundDataField:

e.G.:

BoundDataField dtf = new BoundDataField();
dtf.Header.Text = "Unique ID";
dtf.Key = "uniqueID";
dtf.DataFieldName = "uniqueID";

   BoundDataField dtf1 = new BoundDataField();
   dtf1.Header.Text = "Value A";
   dtf1.Key = "valueA";
   dtf1.DataFieldName = "valueA";

BoundDataField dtf = new BoundDataField();
dtf.Header.Text = "Unique ID";
dtf.Key = "uniqueID";
dtf.DataFieldName = "uniqueID";

BoundDataField dtf1 = new BoundDataField();
dtf1.Header.Text = "Value B";
dtf1.Key = "valueB";
dtf1.DataFieldName = "valueB";

Could you please show me how to solve the problem? P.S.: I am using Infragsitics V 14.1.

Here the working code.

Page_Load:

if (!IsPostBack)
            {
                Session["DataSource_Session"] = null;
                WebHierarchicalDataGrid1.AutoGenerateColumns = true;
            }

            object data = Session["DataSource_Session"];
            if (data != null)
            {
                if (data.GetType() == typeof(A[]))
                {
                    WebHierarchicalDataGrid1.DataKeyFields = "uniqueID";
                    WebHierarchicalDataGrid1.DataSource = (A[])data;
                    WebHierarchicalDataGrid1.DataBind();

                }

                else if (data.GetType() == typeof(B[]))
                {
                    WebHierarchicalDataGrid1.DataKeyFields = "uniqueID";
                    WebHierarchicalDataGrid1.DataSource = (B[])data;
                    WebHierarchicalDataGrid1.DataBind();

                }
            }

Button_Event:

protected void Button_A_Click(object sender, EventArgs e)
        {
            WebHierarchicalDataGrid1.GridView.ClearDataSource();

            A[] valueList = new A[1000];

            for (int i = 0; i < 1000; i++)
            {
                A obj = new A();

                obj.uniqueID = i;

                obj.valueA = "Value A " + i.ToString();

                valueList[i] = obj;
            }

            WebHierarchicalDataGrid1.DataKeyFields = "uniqueID";
            WebHierarchicalDataGrid1.DataSource = valueList;
            WebHierarchicalDataGrid1.DataBind();

            Session["DataSource_Session"] = valueList;
        }

protected void Button_B_Click(object sender, EventArgs e)
        {
            WebHierarchicalDataGrid1.GridView.ClearDataSource();

            B[] valueList = new B[1000];

            for (int i = 0; i < 1000; i++)
            {
                B obj = new B();

                obj.uniqueID = i;

                obj.valueB = "Value B " + i.ToString();

                valueList[i] = obj;
            }

            WebHierarchicalDataGrid1.DataKeyFields = "uniqueID";
            WebHierarchicalDataGrid1.DataSource = valueList;
            WebHierarchicalDataGrid1.DataBind();

            Session["DataSource_Session"] = valueList;
        }

Model and HTML:

No changes!

Thanks in advanced!
Cancel
Reply

Cancel
17590

Offline Vasya Kacheshmarova posted over 10 years ago in reply to help 123
Hello,

I investigated your sample further and I made a few changes.

I set the AutogenerateColumns property to false. Afterwards, when manually adding the columns to the grid it is essential to add them trough the GridView. This will ensure that they are going to be correctly added. For example:

WebHierarchicalDataGrid1.GridView.Columns.Add(dtf);

Also Columns collection should be cleared trough the GridView as well.

I tested the sample on my side and everything is working as expected. Columns are correctly created depending on the underlying data source and all the grid behaviors are correctly functioning.

Please have a look at my sample project, test it on your side and let me know whether it helps you resolve your issues.

Looking forward to hearing from you.
WHDGModified.zip
Cancel
Reply

Cancel

Reply

425

help 123 posted over 10 years ago in reply to Vasya Kacheshmarova

Hi, everything is working fine now. Thank you very much!
Cancel
Reply

Cancel

Children

5

chaithra G M posted over 9 years ago in reply to Vasya Kacheshmarova

Hi..im new to infragistics controls ,im using webhierarchicaldatagrid in my project

how to bind data to infragistics webhierarchicaldatagrid through javascript, im having data in datatable ,

dtParent to bind data and dtchild to bind records to bands ..i.e onexpanding a row dtchild has to bind
Cancel
Reply

Cancel
17590

Offline Vasya Kacheshmarova posted over 10 years ago in reply to help 123

Hello help123,

I am glad that your issue is resolved.

Please let me know if you have any additional questions.
Cancel
Reply

Cancel
425

help 123 posted over 10 years ago in reply to Vasya Kacheshmarova

Hi, with the new version the behaviour is correct. Thanks and best regards
Cancel
Reply

Cancel
17590

Offline Vasya Kacheshmarova posted over 10 years ago in reply to help 123

Hello help123,

I noticed that in your sample project you are using the RTM build of version 14.1 - 14.1.20141.1015.

Could you please try downloading the latest service release available for NetAdvantage 14.1, which currently is 14.1.20141.2283. This could be achieved by following these steps:

1) Go to our web site www.infragistics.com and log with your account.

2) Click Support/Account in the top right corner of the page

3) You will see Welcome, [Your name] on the top of the menu that will appear. Click on the Welcome word.

4) This will lead you to My Keys&Downloads section. Select your product from the list

Under the Service Releases tab you will find the latest service release available for download.

Please test your sample with this service release and let me know whether you are still experiencing this issue.

Looking forward to hearing from you.
Cancel
Reply

Cancel
425

help 123 posted over 10 years ago in reply to Vasya Kacheshmarova

Hi, please see attachment.

WHDG_1.zip
Cancel
Reply

Cancel