Connected vs. Disconnected ADO.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
Hi,

From my understanding DataSet is used for disconnected data access in
Click to expand...
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?
 
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 said:
Hi,

From my understanding DataSet is used for disconnected data access in
Click to expand...
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?
 
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/default.asp?url=/library/en-us/dndotnet/html/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 said:
Hi,

From my understanding DataSet is used for disconnected data access in
Click to expand...
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?
 
Back
Top