Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Ploblem with Da.Fill(Ds)

Reply
Thread Tools

Ploblem with Da.Fill(Ds)

 
 
Jorge Maganto
Guest
Posts: n/a
 
      12-02-2003
Hi!
I'm building a site in ASP.NET which makes a query that
return 50.000 results, this result is read by
a DataAdapter to a DataSet (myDataAdter.Fill(myDataSet)).
The problem is if the query is made by two users at the
same time, the second user take a error.
The problem is that 'Fill' internal uses a DataReader and
only one DataReader can be opened at the time,
and when the 2 users open the DataReader (internal to
Fill) throw a exception.
How can read the results in other way, without use Fill or
DataReader?

Thanks in advance.
 
Reply With Quote
 
 
 
 
anon
Guest
Posts: n/a
 
      12-02-2003
I am not aware of any issues regarding data adapters and
filling datasets - at least not the kind you mention

Are you sure each session is using its own instance of the
database connection, command and adapter objects?

What type of database are you connecting to? The CSV file
driver does not permit shared connections in some
situations.

Regards,

Darren
>-----Original Message-----
>Hi!
>I'm building a site in ASP.NET which makes a query that
>return 50.000 results, this result is read by
>a DataAdapter to a DataSet (myDataAdter.Fill(myDataSet)).
>The problem is if the query is made by two users at the
>same time, the second user take a error.
>The problem is that 'Fill' internal uses a DataReader and
>only one DataReader can be opened at the time,
>and when the 2 users open the DataReader (internal to
>Fill) throw a exception.
>How can read the results in other way, without use Fill

or
>DataReader?
>
>Thanks in advance.
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ploblem doing HTTP POST via URLConnection Mário Java 6 02-10-2010 06:49 AM
checkbox ploblem pls help!! yew y via JavaKB.com Java 15 04-19-2005 02:48 AM
ploblem in jcheckbox yew y via JavaKB.com Java 0 03-30-2005 02:48 AM
CD Rom ploblem Scratch Computer Support 4 08-30-2004 09:34 PM
Having ploblem with sending e-mail elliott parkhurst Computer Support 2 04-03-2004 01:30 PM



Advertisments