Wht is the advantage of using SqlDataAdapter

Ashish

Hi Guys

Why exactly one should use SqlDataAdapter?
Regards
Ashish

Nov 18 '05 #1

Subscribe Post Reply

1801

Carl Prothman [MVP]

Ashish wrote:

Why exactly one should use SqlDataAdapter?

To fill a DataTable (or DataSet which contains a DataTable).
And to apply the changes in a DataTable back to the data source.

Remember, the DataSet / DataTable are disconnected.
Whereas the SqlCommand / SqlDataReader are connected.

http://msdn.microsoft.com/library/en...ClassTopic.asp
- See the Remarks section.

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP

Hire top-notch developers at
http://www.able-consulting.com

Nov 18 '05 #2

Naveen K Kohli

Advantage is that it does not use OLE DB to transport the data back and
forth. It uses the SQL Server native protocol for that. So it is faster.
"Ashish" <as****@globsyn.co.in> wrote in message
news:u6**************@TK2MSFTNGP11.phx.gbl...

Hi Guys

Why exactly one should use SqlDataAdapter?
Regards
Ashish

Nov 18 '05 #3

Kevin Spencer

> Why exactly one should use SqlDataAdapter?

One should use it only because it is needed for what one is doing.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Ashish" <as****@globsyn.co.in> wrote in message
news:u6**************@TK2MSFTNGP11.phx.gbl...

Hi Guys

Why exactly one should use SqlDataAdapter?
Regards
Ashish

Nov 18 '05 #4

by: RitaG | last post by:

Hi. Is it possible to run a Stored Procedure that takes 1 parameter using the SQLDataAdapter. I'm currently using the SQLCommand with the SQLDataReader to do this but would like to use a...

.NET Framework

Data Access using SqlDataAdapter

by: rkbnair | last post by:

In the below listed code, instead of using GetValue(2), is there any way to retrieve fields by calling the field name itself? (for example GetValue("str_mail_from") ?????) ...

.NET Framework

Why SqlConnection is needed if I can query database using SqlDataAdapter only?

by: goodstart123 | last post by:

For example, the following code works fine without SqlConnection. Any Answer to the question? string connectionString = "server=YourServer; uid=sa; pwd=YourPassword;...

C# / C Sharp

Using SqlDataAdapter

by: W Akthar | last post by:

I am trying to use SqlDataAdapter to execute a Stored Procedure. The Stored Procedure is as follows CREATE Procedure SP_GetAddressesFromContactID @ID int AS SELECT b.StreetAddress1,

C# / C Sharp

Update more than 1 table in a DataSet using SqlDataAdapter.Update

by: LP | last post by:

Hello, In the past I used SqlCommandBuilder and SqlDataAdapter .Update method to apply changes in a DataTable back to its table source in SQL Server. It worked fine when DataSet had only 1...

C# / C Sharp

How to update the Database by using SqlDataAdapter object in asp.net?

by: zhaoJian | last post by:

Here it is my code ,but it can't update the database.How to do it ? In _UpdateUnit event, I can not get the original value to @Original_UnitID,so I set a hidden column named LabelKey.But It...

ASP.NET

Database updates (using SqlDataAdapter) during runtime but Database Table Does Not Update

by: dakvanslam | last post by:

I apologize if this is a simple question, but I am very new to SQL Server. I feel like I am missing something easy here. I an running VB ..NET from Visual Studio 2005 and SQL Server Express. The...

Microsoft SQL Server

Update records using SqlDataAdapter

by: Matteo Migliore | last post by:

Hi. I writed a method that takes two DataTable with same schema and return a third DataTable that: - insert new rows from "compare" DataTable - delete rows contained in "source" and not in...

C# / C Sharp

Stored Procedure using SQLDataAdapter , DropDownList

by: suganya | last post by:

Hi I have to bind the DropDownList box with ID field hidden using SQLDataAdapter. For that I have given the coding as protected void Page_Load(object sender, EventArgs e) { ...

.NET Framework

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Wht is the advantage of using SqlDataAdapter

Similar topics