Table Adapter vs SQL Adapter

[Miro]

Im assuming these two adapters are the same thing.

For example, go to your data sources in your project and drag and drop a
datagrid on your form. You will get a TableAdapter automatically added
to the form.

The only "Table Adapter" i was able to find it the toolbox is, if I add
the "SQL Data Adapter" to the toolbox manually.

So my question is, are these the same, or where can I find the "table
adapter" that is added by the wizard in the toolbox?

Thanks

Miro

 

[Cor Ligthert[MVP]]

Miro,

I assume that most people who use direct the SqlDataAdapter are using it in
code.

\\\
Dim da as new SqlDataAdapter
///
That is for most less work than dragging it. (It becomes than as well nice
in your method, while the dragged methods create forever global objects).

Cor

 

[Stephany Young]

You won't find (and you cannot add) a TableAdapter to the toolbox.

A TableAdapter is generated when you execute certain operations, one of
which is as you described.

If you are using SQL Server with SqlClient then the generated TableAdapter
enscapsulated a SqlDataAdapter along with other functionality that allows
you to interact with the TableAdapter object.

If you want more information on what a TableAdapter encapsulates then
dissect the generated code.

 

[Miro]

Miro,

I assume that most people who use direct the SqlDataAdapter are using it
in code.

\\\
Dim da as new SqlDataAdapter
///
That is for most less work than dragging it. (It becomes than as well
nice in your method, while the dragged methods create forever global
objects).

Cor

Thanks,

I just was looking for the actual object so i can click on it and see
all the properties and see if there was something i could be missing. I
do plan to do it by code - i don't see anyway around it once a screen
becomes complicated, or becomes more than a datagrid dragged over from
the dataset.

Baby Steps ;-)

Thanks again,

Miro