How can I create multiple sqldataadapters by using string names

Question

0.00/5 (No votes)

See more:

I am waiting to create dataadapters by using table names.

here is what I have so far

Dim IDlibrary As DataSet = New DataSet("all_tables")
IDlibrary.Tables.Add("Profile")

'fill datatables in dataset
        For Each tab As DataTable In IDlibrary.Tables
            alltabadaptors.SelectCommand = New SqlCommand("select * from " + tab.TableName, sqlconn1)
            alltabadaptors.SelectCommand.ExecuteNonQuery()
            alltabadaptors.Fill(IDlibrary, tab.TableName)
        Next

this works extremely well when filling all datatables. However, because there has to be a seperate table adapter per table. How can I call by string a dataadapter?

so instead of this

alltabadaptors.SelectCommand = New SqlCommand("select * from " + tab.TableName, sqlconn1)

is there a way to call a manually made dataadapter

("stringname for dataadapter here").SelectCommand = New SqlCommand("select * from " + tab.TableName, sqlconn1)

What I have tried:

I have tried to do research on call a dataadapter by string name but I could not find much.

Posted 8-Jun-20 16:12pm

Member 11856456

Updated 8-Jun-20 19:58pm

Add a Solution

Comments

Dave Kreskowiak 8-Jun-20 23:37pm

First question, why are you using TableAdapters?

Next, why are you loading every table in your database into a DataSet?

Member 11856456 9-Jun-20 19:15pm

if there is something better than table adapters I would like to know about it that way I can expand my knowledge. Also, I am loading them all so I can find an update the row found in my match statement. I am doing what I can to increase the speed of my match statement code. I appreciate any help.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2020-06-08T19:58:00

YOu can't.
But ... You could store the DataAdapters in a Dictionary and access them that way:

VB

Dim adapters As Dictionary(Of String, SqlDataAdapter) = New Dictionary(Of String, SqlDataAdapter)()
adapters.Add("Customers", New SqlDataAdapter())
adapters.Add("Invoices", New SqlDataAdapter())
...
Dim tableName As String = "Invoices"
adapters(tableName).SelectCommand = New SqlCommand("SELECT * FROM " & tableName, con)