Infragistics - Nested Tables in UltraGrid

Bubbly
Posted by in C# category on for Beginner level | Views : 14179 red flag

This article demonstrates simple usage of Ultragrid


 Download source code for Infragistics - Nested Tables in UltraGrid

Nested Tables in UltraGrid :

Note : You can download the trial version of infragistics from http://infragistics.com/

In this example, UltraGrid will show parent rows containing Company records and for each company record there will be corresponding Employee records.

First of all you need to create Employee and Company class files

Employee.cs

using System;

using System.Collections.Generic;

using System.Text;

namespace NestedTableUltraGrid

{

class Employee

{

string strFirstName;

string strLastName;

public string StrFirstName

{

get { return strFirstName; }

set { strFirstName = value; }

}

public string StrLastName

{

get { return strLastName; }

set { strLastName = value; }

}

public Employee(string Fname, string Lname)

{

strFirstName = Fname;

strLastName = Lname;

}

}

}

Company.cs

using System;

using System.Collections.Generic;

using System.Text;

namespace NestedTableUltraGrid

{

class Company

{

string strCompanyName;

List<Employee> employees = new List<Employee>();

public string StrCompanyName

{

get { return strCompanyName; }

set { strCompanyName = value; }

}

public List<Employee> Employees

{

get { return employees; }

set { employees = value; }

}

public Company(string Cname)

{

strCompanyName = Cname;

}

}

}

Next you’ll need to add UltraDataSource component in the form

Here UltraDataSource Designer is used in order to define DataBounds (tables), their relationship and their DataColumns (fields).









 

 

 

Now You’ll define a DataBand called Company with a single DataColumn called CompanyName.











 

 

 

Next, you will define a DataBind called Employee with two DataColumns: FirstName and LastName.











 

 

 

Next, you will add an instance of the UltraGrid control and bind it to the UltraDataSource component.

Click on the Finish button.









 

 

 

The UltraGrid control is still selected. You will set its Dock property to Fill so that the UltraGrid fills the entire area of the form.

Click on the Fill option.

The UltraGrid control provides two load styles: PreloadRows and LoadOnDemand. In this exercise, you will use the LoadOnDemand option.

Expand the DisplayLayout section.

Click on the LoadStyle down arrow.

Click on the LoadOnDemand option.

You bind the UltraDataSource component (with the schema that you defined) to the UltraGrid control by using the UltraGrid’s DataSource property.






 

 

 
























using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

namespace NestedTableUltraGrid

{

public partial class Form1 : Form

{

List<Company> companies = new List<Company>(100);

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

for (int i = 0; i <>

{

Company company = new Company("CN " + i.ToString());

company.Employees.Add(new Employee("FName " + i.ToString(), "LName " + i.ToString()));

companies.Add(company);

ultraDataSource1.Rows.SetCount(companies.Count);

}

}

private void ultraDataSource1_CellDataRequested(object sender, Infragistics.Win.UltraWinDataSource.CellDataRequestedEventArgs e)

{

switch (e.Column.Key)

{

case "CompanyName":

e.Data = companies[e.Row.Index].StrCompanyName;

break;

case "FirstName":

e.Data = companies[e.Row.ParentRow.Index].Employees[e.Row.Index].StrFirstName;

break;

case "LastName":

e.Data = companies[e.Row.ParentRow.Index].Employees[e.Row.Index].StrLastName;

break;

default:

break;

}

}

private void ultraGrid1_BeforeRowExpanded(object sender, Infragistics.Win.UltraWinGrid.CancelableRowEventArgs e)

{

ultraDataSource1.Rows[e.Row.Index].GetChildRows(0).SetCount(companies[e.Row.Index].Employees.Count);

}

}

}

Run the application expand the blocks and check the Output

Page copy protected against web site content infringement by Copyscape

About the Author

Bubbly
Full Name: Deepika Haridas
Member Level: Bronze
Member Status: Member
Member Since: 9/14/2009 10:33:08 AM
Country: India
++ Thanks & Regards, Deepika
http://www.angeldeeps.blogspot.com
Software Engineer

Login to vote for this post.

Comments or Responses

Posted by: Santosh4u on: 2/16/2016 | Points: 25
Very nice example.however i need to show two more hierarchy lebel to display data(databand under employee(department) and databand under department.
like all the department under employee and all the location under department(n.
need like below output

+- Company
------+ Employee 1
------------+ Department 1
---------------------- Loaction 1
---------------------- Loaction 2
-------+ Employee 2
--------------+ Department 1
----------------------- Loaction 1


its basically 4 label of hierarchy in Infragistics win grid


Thanks


Login to post response

Comment using Facebook(Author doesn't get notification)