Hi, I was wondering if you could help.

I have a DataSet with two seperate TableAdapters, I can connect to either of them perfectly well. This is how I connect to the first one:

Dim dbAdapter As New DepartmentObjectTableAdapters.DepartmentArticlesTa bleAdapter
Dim dbRecordSet As DepartmentObject.DepartmentArticlesDataTable
dbRecordSet = dbAdapter.GetArticles(strViewArchive))

What I would like to do is connect to a different TableAdapter after say, a PostBack... but I get errors saying 'dbAdapter and dbRecordSet are not declared'. This is how I have unsuccessfully tried to do it:


If Page.IsPostBack Then
     Dim dbAdapter As New DepartmentObjectTableAdapters.DepartmentArticlesTa bleAdapter
     Dim dbRecordSet As DepartmentObject.DepartmentArticlesDataTable
Else
     Dim dbAdapter As New DepartmentObjectTableAdapters.DepartmentArticlesArchiveTableAdapter
     Dim dbRecordSet As DepartmentObject.DepartmentArticlesArchiveDataTable
End If
dbRecordSet = dbAdapter.GetArticles(strViewArchive))

Thanks in advance, any help would be appreciated.

I don't see why that wouldn't work. Trace through the code and see if you can find at what point you get the error

Thanks for your reply.

I think the cause of the problem is that dbAdapter and dbRecordSet are Dim'd inside of the If statement... and at runtime .Net compiles the page but cannot cannot see that they have been set when it gets to dbRecordSet = dbAdapter.GetArticles(strViewArchive)).

Can I Dim them first (outside of an If statement) and then use an If statement to set where they actually point?

The fact that you dim them inside of the IF does not matter. I have tried your code on a test page and it works fine. You can try dimming them ouside, although it should not matter.