This data provider can be used to combine multiple other data providers into one datasource. Use it if you have e.g. multiple DataSet classes from where to pull data or if you would like to have a mix of XML and custom object data.
It must be ensured that the table names within the collection of registered data sources are unique and therefore do not exist more than once under the same name.
DataSet ds1 = CreateDataSet();
DataSet ds2 = CreateOtherDataSet();
// combine the data from ds1 and ds2 into one datasource
DataProviderCollection providerCollection = new DataProviderCollection();
providerCollection.Add(new AdoDataProvider(ds1));
providerCollection.Add(new AdoDataProvider(ds2));
LL.DataSource = providerCollection;
LL.Design();
Dim ds1 As DataSet = CreateDataSet()
Dim ds2 As DataSet = CreateOtherDataSet()
' combine the data from ds1 and ds2 into one datasource
Dim providerCollection AsNew DataProviderCollection()
providerCollection.Add(New AdoDataProvider(ds1))
providerCollection.Add(New AdoDataProvider(ds2))
LL.DataSource = providerCollection
LL.Design()