Hmm. Thanx a lot. I find no issues with the above apart from the extra over head of creating a data set row by row and then binding it rather than simply adding the rows directly.

Though through trail and error I have been able to create it. Following is the code for that  (firstEverGrid is a grid already declared at design time)

UltraGridBand firstBand = new UltraGridBand(true);

firstBand.Columns.Add("column2", "doosra column");

secondBand.Columns.Add("column3", "teesra column");

firstEverGrid.Bands.Add(firstBand);

UltraGridCell cell3 = new UltraGridCell("hello baby3");

UltraGridCell cell5 = new UltraGridCell("hello baby5");

UltraGridCell cell7 = new UltraGridCell("hello baby7");

neebz said:

None of the events are working.
 Is it because I am creating the grid without binding any data to it?

I would expect so.  Most of the events I use are part of the basic binding sequence.

What events do you expect to fire without any binding?

(And, out of curiosity, what data do you expect you grid to display without any binding?  Are you creating rows at design time?)

Hello everyone,

I got around creating the Hierarchical Grid in 2 levels (level1 and level2), but how do you bind to a grid with N-Level (Level3....and so on). Please advise!

Thanks 

You could save youself (and us) a bit if time if you read the entire thread before you post a question that has already been answered.

*grin*

See my post, above, that provides a link to an example.  If that turns out not to be what you're looking for, then explain why it doesn't work for you.

Good luck.

Good morning Edward,

I overlooked and missed the link you provided. Thank you for the nice working code you posted! I added a few more lines just to help someone new like I am.

Reference to Edward McCarroll's original post

Public Function CreateDataset() As DataSet
        Dim lResult As New DataSet("myDataset")
        Dim getLevel1QStr As String = "SELECT InvoiceNo, Description FROM Level1"
        Dim getLevel2QStr As String = "SELECT InvoiceNo, PartNo, Description FROM Level2"
        Dim getLevel3QStr As String = "SELECT PartNo, SerialNo, Description FROM Level3"

        Dim level1Table As New DataTable("Level1")
        lResult.Tables.Add(level1Table)
        lResult.Tables("Level1").Load(GetDataReader(getLevel1QStr))

        Dim level2Table As New DataTable("Level2")
        lResult.Tables.Add(level2Table)
        lResult.Tables("Level2").Load(GetDataReader(getLevel2QStr))

        lResult.Relations.Add(lResult.Tables("Level1").Columns("InvoiceNo"), lResult.Tables("Level2").Columns("InvoiceNo"))

        Dim level3Table As New DataTable("Level3")
        lResult.Tables.Add(level3Table)
        lResult.Tables("Level3").Load(GetDataReader(getLevel3QStr))

        lResult.Relations.Add(lResult.Tables("Level2").Columns("PartNo"), lResult.Tables("Level3").Columns("PartNo"))

        Return lResult
End Function

Public Function GetDataReader(ByVal queryString As String) As SqlDataReader

        'AppConnectionString = connection string
        Dim myConnection As New SqlConnection(AppConnectionString)
        Dim myCommand As New SqlCommand(queryString, myConnection)
        'Set the command
        myCommand.CommandType = CommandType.Text
        'Execute the command
        myConnection.Open()
        Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
        'Return SqlDataReader
        Return result

End Function

Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load

        If Not IsPostBack = True Then
            Me.UG1.DataSource = CreateDataset() 'Create and return a dataset
            Me.UG1.DataBind() 'Bind to Grid
            Me.UG1.DisplayLayout.ActiveRow = Me.UG1.Rows(0) 'Set pointer to first row
        End If

End Sub 'Page_Load

Thanks,
Thai Nguyen

Hi ,

I m also suffering from same problem ....can you help me. I have code snippest which is bind DataSet .

DataSet dsSearch = new DataSet();

new DataColumn[ { dsSearch.Tables["Table1"].Columns[0], dsSearch.Tables["Table1"].Columns[2] }, false);

new DataColumn[ { dsSearch.Tables["Table2"].Columns[7] }, false);

this.UG1.DataSource = dsSearch;

Problem is ....It is not display third level data. Its only display 2 level data.

I want to display

1.Comapnay

2.Contact Name

3.Matter Name

Is it possible with Hierarchical grid.

Hi MacDonald

Thank you for ur support....can we have any other control thru wich i achive this functionality.

If I'm correctly reading the code where you're creating your DataRelation objects, you have three tables:  Table, Table1, and Table2.  The relations you're creating mean that Table1 is a child of Table, and Table2 is also a child of Table.

WebGrid isn't capable of showing multiple sets of child tables in this fashion.  You can only have one child band (roughly analagous to a single DataTable) for any one parent band.