p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   ADO.NET (http://p2p.wrox.com/forumdisplay.php?f=109)
-   -   Curosrs in dotnet (http://p2p.wrox.com/showthread.php?t=27272)

er_jyoti March 24th, 2005 05:20 AM

Curosrs in dotnet
Hi ,
Can we use cursors in dotnet if yes how?

ashu_from_india March 24th, 2005 12:58 PM

wht exactly u wanna ask ?????
we have Cursors in SQL Server

gokul_blr March 28th, 2005 01:21 AM

Yes, please post your exact requirement.

Mousepointer cursor :
'Cursor.Current = Cursors.WaitCursor' or by setting the form's/control's 'Cursor' property to 'Cursors.WaitCursor'.


Cursors in SQL Server:
What are cursors and its types?
Cursors allow row-by-row prcessing of the resultsets.
Types of cursors: Static, Dynamic, Forward-only, Keyset-driven.

Gokulan Ethiraj

er_jyoti March 28th, 2005 02:16 AM

Hi ,
I wanted to know about the CursorType property to specify the type of cursor that should be used when opening the Recordset object.
Like in VB there are four cursor types, three of which are supported under Connector/ODBC:
adOpenStatic (Client-Side)
adOpenForwardOnly (Server-Side)
adOpenDynamic (Server-Side)
Is thr anything similar in dotnet also.

joefawcett March 28th, 2005 10:13 AM

ADO.NET uses a different approach. Look at DataReader for a connected firehose style cursor. Dataset, on the other hand, is a client side snapshot of a datastore, either one table or many but always disconnected from the actual data except when it is filled or updates are posted.


Joe (Microsoft MVP - XML)

ashu_from_india March 31st, 2005 06:15 AM

ADO .NET uses a different technology.

DataReader object is like a Read Only Forward Only strear of data
and DataTable and DataSet object is like client side cursor
they contain a snapshot of the database at any point of time

All times are GMT -4. The time now is 12:36 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.