I have a typed DS (xsd) file with numerous tables.

I want to parse through the tables and:

Create a dataadapter for each table
Create the

Something like this...

Sub GetData()
' Open a connection
Dim con As New SqlConnection(CS)
con.Open()

  Dim t As DataTable
    For Each t In MyDs.Tables
    'Create the DataAdapters
     Dim "da" & t.TableName() As New SqlDataAdapter()
     Dim "cb" & t.TableName() As SqlCommandBuilder = New SqlCommandBuilder("da" & t.TableName())

     "da" & t.TableName().SelectCommand = ("select * from " & t.tablename,con)

      "da" & t.TableName().DeleteCommand = "cb" & t.TableName().GetDeleteCommand
      "da" & t.TableName().InsertCommand = "cb" & t.TableName().GetInsertCommand
      "da" & t.TableName().UpdateCommand = "cb" & t.TableName().GetUpdateCommand


"da" & t.TableName().Fill(MyDs, t.TableName())

end sub

Has anyone been able to do something like this???

Thanks!

For generating multiple 'things' like you desire to do, I'd suggest using a HashTable. The SqlDataAdapter will be the object of each HashTable element and the element key can be the name you construct from "da" + t.TableName.

-Peter

thanks Peter, but I have no idea what you mean by building a hash table. I'll do some research on it, but if you have an example I'd greatly appreciate it!

Thanks!
David

A hash table is a .NET class that allows you to store a collection of objects. You access the object thru a known key (usually a string). This is compared to a simpler collection such as an array which you can't as easily "find" a particular element in the collection.

Dim hshMyTables As New HashTable

hshMyTables.Item("daTableName") = New SqlDataAdapter

-Peter