Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO.Net SqlDataReader Record Locking? timeout!

Status
Not open for further replies.
JFritzler

JFritzler

Programmer
Jul 19, 2001
18
US
I am using an ADO.Net SqlDataReader to read through a rather large query. As I process the data I want to execute an "update set x = y" statement on the database using a different command and a different connection (different connect string, timeout value is different) for the row I just read. At runtime I get an sql exception saying my update command timed out. (timeout expired). But the same "update" statement works fine outside the app!

Does a SqlDataReader lock the all records it is reading? I was hoping that because they are "fastforward read-only" that they would not lock records!

Am I stuck?
 
Status
Not open for further replies.

Similar threads

sugu1
  • Locked
  • Question
sound editing in web site to record, cut/trim, paste and save as wav file
Replies
0
Views
319
sugu1
sugu1
dvannoy
  • Locked
  • Question
Session Timeout Question
Replies
1
Views
150
jbenson001
jbenson001
dvannoy
  • Locked
  • Question
Getting Value from Last Record in DB 1
Replies
4
Views
96
jbenson001
jbenson001
stinkybee
  • Locked
  • Question
Getting the ID of a deleted record within a ListView
Replies
3
Views
92
MakeItSo
MakeItSo
dvannoy
  • Locked
  • Question
Checking if DataAdapter has records
Replies
1
Views
94
dvannoy
dvannoy

Part and Inventory Search

Sponsor

Back
Top