473,320 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Connected vs. Disconnected ADO.NET

Hi,

From my understanding DataSet is used for disconnected data access in ADO.NET. However, I haven’t come across an example to use continuous data access with ADO.NET using C# . Is continuously connection possible and allowed in ADO.NET and Is there a simple example available?

Thanks.
Nov 15 '05 #1
3 8764
Yes, the connected part of ADO.NET is to use a DataReader. Do an MSDN search
on DataReader and you should get plenty of information and examples.

--
Sam Gentile [C#/.NET MVP]
..NET Blog http://samgentile.com/blog/
MSDN Column:
http://msdn.microsoft.com/library/de...tml/bridge.asp
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
"light_wt" <an*******@discussions.microsoft.com> wrote in message
news:E1**********************************@microsof t.com...
Hi,

From my understanding DataSet is used for disconnected data access in ADO.NET. However, I haven't come across an example to use continuous data
access with ADO.NET using C# . Is continuously connection possible and
allowed in ADO.NET and Is there a simple example available?
Thanks.

Nov 15 '05 #2
Hi,

a DataReader is a connected data access. See MSDN to more details.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"light_wt" <an*******@discussions.microsoft.com> wrote in message
news:E1**********************************@microsof t.com...
Hi,

From my understanding DataSet is used for disconnected data access in ADO.NET. However, I haven't come across an example to use continuous data
access with ADO.NET using C# . Is continuously connection possible and
allowed in ADO.NET and Is there a simple example available?
Thanks.

Nov 15 '05 #3
Hi,

Yes, take a look at the SqlDataReader class or the OleDbDataReader class
topics in MSDN.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://www.x-unity.net/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"light_wt" <an*******@discussions.microsoft.com> wrote in message
news:E1**********************************@microsof t.com...
Hi,

From my understanding DataSet is used for disconnected data access in ADO.NET. However, I haven’t come across an example to use continuous data
access with ADO.NET using C# . Is continuously connection possible and
allowed in ADO.NET and Is there a simple example available?
Thanks.


Nov 15 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Steve Le Monnier | last post by:
The ADO.NET DataSet is idea for application development, especially if you need disconnected data. DataReader objects are great in the connected environment but are forward only. What do you do...
0
by: Cat | last post by:
Hello. Is it POSSIBLE to get notified when the machine is connected to the internet or disconnected from the internet? I mean, using .NET class not using Windows API. Other than pinging a website...
3
by: leveraged | last post by:
Why can I only connect to or create a web app in VS 2003 using localhost while I am connected to the internet. I have no problems using VS 2002 but for some reason I get Microsoft Development...
2
by: Robert Scheer | last post by:
Hi. My site needs to know if the user is connected before executing some queries on my database. Actually, I have a page loaded by an Iframe that runs every 30 seconds and updates a field on my...
9
by: Steven Nagy | last post by:
I know that .NET is based on a disconnected architecture, but I can't conceive of why continually opening and closing a connection would be faster than leaving a connection open. So I ran a test...
1
by: dejavue82 | last post by:
Hello fellow programmers! My question concerns the scalability of database access. In coldfusion (or php for that matter) for example, there seems to be only the connected model for accessing a...
7
by: semedao | last post by:
Hi all, I view many posts about this issue , the connected property does not tell us the current status of the socket. based on couple of suggestions of msdn , and some article here , I try to...
2
by: Gabriel | last post by:
Hello, I'm looking for documentation with "Best Practice" for ASP.NET application In which case use Connected or Disconnected mode Typed dataset or not ? I didn'd find anything pertinent...
4
by: keithseah | last post by:
Hi all, i've been having this problem and its kiiling me! i'm a newbie at this so i hope someone would be able to help me. picture link:...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.