Table Adapter vs SQL Adapter

  • Thread starter Thread starter Miro
  • Start date Start date
M

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
 
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
 
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.
 
Cor said:
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
Click to expand...
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
 
Back
Top