Table Adapter vs SQL Adapter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Miro - 08 Oct 2007 06:19 GMT

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

Reply to this Message

Cor Ligthert[MVP] - 08 Oct 2007 06:20 GMT

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

Reply to this Message

Miro - 08 Oct 2007 17:25 GMT

> Miro,
>
[quoted text clipped - 9 lines]
>
> 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

Reply to this Message

Stephany Young - 08 Oct 2007 13:17 GMT

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.

> Im assuming these two adapters are the same thing.
>
[quoted text clipped - 11 lines]
>
> Miro

Reply to this Message

Table Adapter vs SQL Adapter

Free Magazines