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");

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.

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.

Hi MacDonald

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