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

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

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'.

Or

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

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.

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)

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