Hi,

I need help for above issue, I need to bind a master-detail relationship into a gridview...

 I know how to do it when the content of the data is known ahead of time.

Design your GridControl with two related GridView objects.  The outer view will contain the "master" data and the inner view will contain the "detail" data.  Design each view with appropriate grid columns for the data you want to fetch and display.  Provide a suitable label, like "Details", for the RelationName.

In a location that you find suitable to fetch and display the data, use the following code.  Replace the invocations of FetchMasterData() and FetchDetailData() with your own methodology for obtaining the data for each view.  Replace "MasterID" with your own column name that represents the relationship between your two query results.  Replace "Details" with the RelationName you provided in the GridControl designer.
__________

DataTable masterTable = FetchMasterData();
DataTable detailTable = FetchDetailData();

DataSet dataSet = new DataSet();
dataSet.Tables.Add( masterTable );
dataSet.Tables.Add( detailTable );
dataSet.Relations.Add( "Details", masterTable.Columns[ "MasterID" ], detailTable.Columns[ "MasterID" ] );

DataViewManager dvm = new DataViewManager( dataSet );
DataView dv = dvm.CreateDataView( masterTable );
gridControl1.DataSource = dv;
__________

Hi, Thanks for the reply, I will try it :)

but another question is "Design each view with appropriate grid columns for the data you want to fetch and display"

Did you mean that I have to set the columns for the view? If we bind the datatable to the view, the columns will be shown automatically, is it correct? pls correct me if I'm wrong.. :)

Hi, I found below error, please  help me to solve it, :)

error: DataTable already belongs to another DataSet.

clsOne

Public function LoadDataMaster() as datatable

    Dim ds As New DataSet
        Dim dt As DataTable = ds.Tables.Add("tblData")
        Dim da As MySqlDataAdapter
    Dim str As String
        str = "SELECT EmployeeID, EmployeeName FROM tblemployee"
        da = New MySqlDataAdapter(str, Connection.conn)
       
        Open()
        da.Fill(ds, "tblData")
        Close()
  
        Return ds.tables("tblData")

end function

Public function LoadDataDetail() as datatable

    Dim ds As New DataSet
        Dim dt As DataTable = ds.Tables.Add("tblData")
        Dim da As MySqlDataAdapter
    Dim str As String
        str = "SELECT DependentID, DependentName FROM tbldependent"
        da = New MySqlDataAdapter(str, Connection.conn)
       
        Open()
        da.Fill(ds, "tblData")
        Close()
  
        Return ds.tables("tblData")

end function

FormLoad

  Dim masterdt As DataTable = Employee.LoadDataMaster()
        Dim detaildt As DataTable = Employee.LoadDataDetail()
        Dim ds1 As DataSet = New DataSet
        ds1.Tables.Add(masterdt)
        ds1.Tables.Add(detaildt)
        ds1.Relations.Add("Details", masterdt.Columns("EmployeeID"), detaildt.Columns("EmployeeID"))

        Dim dvm As DataViewManager = New DataViewManager(ds1)
        Dim dv As DataView = dvm.CreateDataView(masterdt)

        GridControl1.DataSource = dv

Already, but still got no luck, got any options or ways to do it?

Still the same error... :)

Hi, Thanks again for the reply.

I have tried above codes, but still got the error at here,

'column' argument cannot be null. Parameter name: column -> pointed to  dataSet1.Relations.Add("Details", masterdt.Columns("EmployeeID"), detaildt.Columns("EmployeeID"))

I think that doesn't have data bound... that is so annoying can't solve it, :) btw thanks to you.. Does it really has no other options? Or do you have any samples?

Below is the code,

        Dim dataSet1 As New DataSet
        Dim masterdt As DataTable = dataSet1.Tables.Add("Employee")
        Dim detaildt As DataTable = dataSet1.Tables.Add("Dependent")

        Dim str As String
        Dim da As MySqlDataAdapter

        str = "SELECT EmployeeID, EmployeeName FROM tblemployee"
        da = New MySqlDataAdapter(str, Connection.conn)

        Connection.Open()
        da.Fill(dataSet1, "Employee")
        Connection.Close()

        str = "SELECT DependentID, DependentName FROM tbldependent"
        da = New MySqlDataAdapter(str, Connection.conn)

        Connection.Open()
        da.Fill(dataSet1, "Dependent")
        Connection.Close()

        dataSet1.Relations.Add("Details", masterdt.Columns("EmployeeID"), detaildt.Columns("EmployeeID"))

        Dim dvm As DataViewManager = New DataViewManager(dataSet1)
        Dim dv As DataView = dvm.CreateDataView(masterdt)

        GridControl1.DataSource = dv

Hi, Thanks, after reviewed provided tutorials, I realized that we need 2 data adapter to fill the dataset.

I have done it bro... thanks a lot :)