OleDbDataAdapter vs. SqlDataAdapter

microsoft.public.dotnet.framework.adonet

14 Nov 2006 6:23 PM

CompSci

I am wondering which DataAdapter to go with OleDbDataAdapter or
SqlDataAdapter? We are using this in a webservice using sql server 2005
and .net 1.1

Ruchir

14 Nov 2006 6:29 PM

Marina Levit [MVP]

SqlDataAdapter. If you are using SQL Server, you should be using the
classes in the SqlClient namespace.

Show quote

"CompSci" <ruchir.jaipuri***@gmail.com> wrote in message
news:1163528609.062582.6620@b28g2000cwb.googlegroups.com...
>I am wondering which DataAdapter to go with OleDbDataAdapter or
> SqlDataAdapter? We are using this in a webservice using sql server 2005
> and .net 1.1
>
> Ruchir
>