MS Application Blocks question

[amber]

I'm trying to populate a dataset that contains 2 tables, using MS Applications Blocks.
In my searches on the internet, it seems that populating 2 tables in a dataset is as simple as:

[size=+0]dataAdapter1.fill(dataset1("table1")
dataAdapter1.newSelectCommandHere
dataAdapter1.fill(dataset1("table2")[/size]

But with the SQLHelper class, I don't seem to be able to specify which table to populate - my code is:

[size=+0]

Dim tables(1) As String
tables(0) = "table1"
tables(1) = "table2"

ds.Clear()

SqlHelper.FillDataset(SqlDbManager.GetConnectionString, CommandType.StoredProcedure, "StoredProcedure1", ds, tables, params)

[size=+0]SqlHelper.FillDataset(SqlDbManager.GetConnectionString,
CommandType.StoredProcedure, "StoredProcedure2", ds, tables, sqlPararameter1) [/size]

​

My "Table1" fills fine - but "Table2" is always empty.


Any suggestions?
Thansk!
Amber



[/size]

 

[TPM]

Your calling the table array, not the item. tables -> tables(0) or tables(1)

TPM

 

[amber]

MS App block - filling more than one table in a dataset

Yes, but if I specify a table
eg:
SqlHelper.FillDataset(SqlDbManager.GetConnectionString, CommandType.StoredProcedure, "StoredProcedure1", ds, tables(0), sqlParameter1)

I get an error. ("Overload resolution failed....")

That is my question...how do I specify a table to fill??

Amber

 

[TPM]

I must say I'm not all that farmiliar with DAAB, have you tried not specifying a table name? Normally tables will be added automatically and called table1, table2 etc.

 

[amber]

MS App block - filling more than one table in a dataset

Well that is how I was doing it.
But only my first table was ever populating.
The 2nd table always remained empty.

I'm not sure where the problem lies, but I thought maybe it was when I called the SQLHelper class.

Amber

 

[suddenelfilio]

If you can't solve this problem perhaps the more update version of the application blocks may help you it's called the Enterprise library and is freely downloadable at the msdn website