What is difference between SqlDataAdapter and DataSet ?

Please give me similarity / equivalent of VB-6 ?

Is sqlDataAdapter works like  Recordset of VB-6 ?

Best Regards,

Luqman

Luqman,

The classes you mention don't map directly to VB6 classes.

The DataAdapter object doesn't really have anything like it in VB6. It's
purpose is to manage the Command objects so that you can retrieve and modify
the rows through the Connection object. You have to use it to save your
changes to the database.

The DataSet object is a collection of DataTables. This functionality existed
in VB6 because you could open a collecion of recordsets. But there wasn't a
seperate object just for this purpose. The DataSet is much more powerful
because you can create new relationships between DataTables.

The DataTable is similar to a recordset. It holds a collection of data rows.
It is disconnected and any changes made to it must be posted back to the
database using the DataAdapter object.

The DataReader is also similar to a recordset object. It can be thought of
as a read-only, forward only recordset. If you just want to read a large
amount of data from start to finish, this is the fastest way to do it.

The Connection and Command objects are pretty much VB6 equivalents.

Brian
--
Moving from VB6 to VB.NET?  It just got easier...
"The .NET Languages: A Quick Translation Guide"
www.bischofsystems.com/vbnet.asp

Brian is correct.  You can think of the ADO Recordset's object equivalent
to the ADO.NET DataAdapter + Dataset.  They each are optimized for the task
at hand.

-Brian

This posting is provided 'AS IS' with no warranties, and confers no rights.
<http://www.microsoft.com/info/terms.htm>

Please do not send email directly to this alias. This is our online account
name for newsgroup participation only.

--------------------


| Subject: Re: What is difference between SqlDataAdapter and DataSet ?
| Date: Tue, 12 Mar 2002 11:51:10 -0800
| Lines: 49
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000

| Newsgroups: microsoft.public.dotnet.languages.vb
| NNTP-Posting-Host: dsl-64-130-200-213.telocity.com 64.130.200.213
| Path: cpmsftngxa07!tkmsftngxs01!tkmsftngp01!tkmsftngp07
| Xref: cpmsftngxa07 microsoft.public.dotnet.languages.vb:34960
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
|
| Luqman,
|
| The classes you mention don't map directly to VB6 classes.
|
| The DataAdapter object doesn't really have anything like it in VB6. It's
| purpose is to manage the Command objects so that you can retrieve and
modify
| the rows through the Connection object. You have to use it to save your
| changes to the database.
|
| The DataSet object is a collection of DataTables. This functionality
existed
| in VB6 because you could open a collecion of recordsets. But there wasn't
a
| seperate object just for this purpose. The DataSet is much more powerful
| because you can create new relationships between DataTables.
|
| The DataTable is similar to a recordset. It holds a collection of data
rows.
| It is disconnected and any changes made to it must be posted back to the
| database using the DataAdapter object.
|
| The DataReader is also similar to a recordset object. It can be thought of
| as a read-only, forward only recordset. If you just want to read a large
| amount of data from start to finish, this is the fastest way to do it.
|
| The Connection and Command objects are pretty much VB6 equivalents.
|
| Brian
| --
| Moving from VB6 to VB.NET?  It just got easier...
| "The .NET Languages: A Quick Translation Guide"
| www.bischofsystems.com/vbnet.asp
|
|

| > What is difference between SqlDataAdapter and DataSet ?
| >
| > Please give me similarity / equivalent of VB-6 ?
| >
| > Is sqlDataAdapter works like  Recordset of VB-6 ?
| >
| > Best Regards,
| >
| > Luqman
| >
| >
| >
| >
| >
|
|
|