473,387 Members | 1,404 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,387 software developers and data experts.

Database cursors in .NET 2003

Hi,

What was lacked in .NET 2002 was a database cursor that
did the same thing as in traditional ASP, i.e. .MoveFirst,
MoveNext and so on.

I've been reading articles and books where it's been said
that in a future version of ADO.NET there should come
these cursors that where you can move through a dataset
with .MoveNext and it's alike, not having to deal with the
index of the dataset.

Has tis been implemented in .NET 2003? And if, where can I
find it in MSDN?

/Kenneth
Nov 17 '05 #1
3 990
Kenneth,

Maybe someone from Microsoft will correct me, but I don't think it's been
implemented yet.

Sincerely,

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
"Kenneth" <ke***********@chello.se> wrote in message
news:0c****************************@phx.gbl...
Hi,

What was lacked in .NET 2002 was a database cursor that
did the same thing as in traditional ASP, i.e. .MoveFirst,
MoveNext and so on.

I've been reading articles and books where it's been said
that in a future version of ADO.NET there should come
these cursors that where you can move through a dataset
with .MoveNext and it's alike, not having to deal with the
index of the dataset.

Has tis been implemented in .NET 2003? And if, where can I
find it in MSDN?

/Kenneth

Nov 17 '05 #2
Thought so, because I can't find anything about it in MSDN.

/Kenneth
-----Original Message-----
Kenneth,

Maybe someone from Microsoft will correct me, but I don't think it's beenimplemented yet.

Sincerely,

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
"Kenneth" <ke***********@chello.se> wrote in message
news:0c****************************@phx.gbl...
Hi,

What was lacked in .NET 2002 was a database cursor that
did the same thing as in traditional ASP, i.e. .MoveFirst, MoveNext and so on.

I've been reading articles and books where it's been said that in a future version of ADO.NET there should come
these cursors that where you can move through a dataset
with .MoveNext and it's alike, not having to deal with the index of the dataset.

Has tis been implemented in .NET 2003? And if, where can I find it in MSDN?

/Kenneth

.

Nov 17 '05 #3
There is no direct correlation, but you can use a DataReader in a manner
very similar to the Recordset object. You use Read() to get a record and
then manipulate the items in it. You Read() again to advance.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge

************************************************** **************************
****
Think Outside the Box!
************************************************** **************************
****
"Kenneth" <ke***********@chello.se> wrote in message
news:0c****************************@phx.gbl...
Hi,

What was lacked in .NET 2002 was a database cursor that
did the same thing as in traditional ASP, i.e. .MoveFirst,
MoveNext and so on.

I've been reading articles and books where it's been said
that in a future version of ADO.NET there should come
these cursors that where you can move through a dataset
with .MoveNext and it's alike, not having to deal with the
index of the dataset.

Has tis been implemented in .NET 2003? And if, where can I
find it in MSDN?

/Kenneth

Nov 17 '05 #4

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

Similar topics

3
by: EMW | last post by:
How can I put everything that is in a datagrid into a SQL server database (which should be readable by an PocketPC program)? There is probably a simple solution for it, but as always it is...
49
by: Relaxin | last post by:
It is just me or has MS created some of the worst ways to access and display data? You can use a DataSet, but if you want to sort or filter the data to must use a DataView which is created from...
346
by: rkusenet | last post by:
http://biz.yahoo.com/rc/040526/tech_database_marketshare_1.html Interesting to see that database sales for windows is more than Unix.
2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
10
by: Just Me | last post by:
Does Me.Cursor.Current=Cursors.WaitCursor set the current property of Me.Cursor to Cursors.WaitCursor And Me.Cursor.Current=Cursors.Default set the Me.Current property to something (default)...
2
by: Alan Kemp | last post by:
Hi, I have a problem that is half python, half design. I have a multithreaded network server working, each client request spawns a new thread which deals with that client for as long as it is...
13
by: Robin Haswell | last post by:
Hey people I'm an experience PHP programmer who's been writing python for a couple of weeks now. I'm writing quite a large application which I've decided to break down in to lots of modules...
4
by: ImOk | last post by:
I need to program generically. I am familiar with the ODBC layer but never used PDO or DB. Does anyone have any experience with these database layers? Thanks
3
dmjpro
by: dmjpro | last post by:
My web application sometimes exceeds the maximum open cursors.. My database server is oracle9i. I want to reutilize the connection without closing the connection. How can i trap the idle cursors...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...
0
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...

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.