There are any number of ways. Basically you just need to know that the tables in the dataset can be retrieved through the Tables collection of the dataset. One possible way is

' Get the DataSet
Dim ds As DataSet = oParticipantCheckDetail.GetProcessingCheckDetailByBatchId(CInt(Me.cboProcessingBatchSelection.Value))

'Get the datatable
Dim dt As DataTable = ds.Tables("ProcessingBatchCheckDetails")

then databind the grid to the datatable. Another way is to rewrite the business object method to return a datatable instead.

Public Function GetProcessingCheckDetailByBatchId(ByVal batchID As Integer) As DataTable
        Return Me.GetDataSet(("SELECT * FROM ParticipantCheckDetail WHERE BatchId  = " + batchID.ToString()), "ProcessingBatchCheckDetails").Tables("ProcessingBatchCheckDetails")
End Function

Can you explain what you mean by "hydrating"? The method is simply returning a reference to an object that is already in memory, there is no conversion taking place.


>Still stuck trying to implement using GetDataSet(SQL Command, TableName).
>I presently have this setup in my BO as follows:
>

>Public Function GetProcessingCheckDetailByBatchId(ByVal batchID As Integer) As DataSet
>        Return Me.GetDataSet(("SELECT * FROM ParticipantCheckDetail WHERE BatchId  = " + batchID.ToString()), "ProcessingBatchCheckDetails")
>    End Function
>

>In my form, I am hydrating the dataset as follows:
>

>   Me.dsParticipantCheckDetail = Me.oParticipantCheckDetail.GetProcessingCheckDetailByBatchId(CInt(Me.cboProcessingBatchSelection.Value))
>

>
>Is there any other code I need to make this work?
>Perhaps, should I identify ProcessingBatchCheckDetails as a Table? If so how?
>How should I configure the mmInfragisticsDataGrid's BindingValueSource to use the specified Table of the BO?
>
>THANKS FOR ANY IDEAS!