Click here to Skip to main content
15,900,511 members
Home / Discussions / C#
   

C#

 
GeneralRe: IE DOM in C# Pin
Heath Stewart29-Mar-04 4:20
protectorHeath Stewart29-Mar-04 4:20 
GeneralRe: IE DOM in C# Pin
Dave Kreskowiak30-Mar-04 1:49
mveDave Kreskowiak30-Mar-04 1:49 
QuestionHow to change URL of a WebService? Pin
User-37793628-Mar-04 23:44
User-37793628-Mar-04 23:44 
AnswerRe: How to change URL of a WebService? Pin
jillellamudi29-Mar-04 0:23
jillellamudi29-Mar-04 0:23 
AnswerRe: How to change URL of a WebService? Pin
Heath Stewart29-Mar-04 4:08
protectorHeath Stewart29-Mar-04 4:08 
GeneralRe: How to change URL of a WebService? Pin
User-37793630-Mar-04 4:42
User-37793630-Mar-04 4:42 
Generalopen DataReader associated with this Connection which must be closed first Pin
dabuskol28-Mar-04 23:09
dabuskol28-Mar-04 23:09 
GeneralRe: open DataReader associated with this Connection which must be closed first Pin
Colin Angus Mackay28-Mar-04 23:44
Colin Angus Mackay28-Mar-04 23:44 
One of two possibilities that I can think of.

(1) You read data with a DataReader and didn't close it when you were done reading.

(2) You are still reading data with the DataReader when you call the code to insert data on the same connection as the DataReader.

The solution for (1) is to remember to Close() DataReaders when you're done with them.

The solution for (2) is to open a new connection because you cannot run two or more commands on the same connection at the same time. (The Data Reader is still running the command because it doesn't get the data from the database until it neads it) - Since you're using Connection pooling this isn't much of an overhead.
Actually since you're using Connection pooling why not close the connection after each operation the any subsequent operations will just pull the connection back out of the pool.


"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)


GeneralRe: open DataReader associated with this Connection which must be closed first Pin
dabuskol29-Mar-04 1:35
dabuskol29-Mar-04 1:35 
GeneralRe: open DataReader associated with this Connection which must be closed first Pin
Colin Angus Mackay29-Mar-04 2:00
Colin Angus Mackay29-Mar-04 2:00 
GeneralBorderless CheckBox control Pin
Andy H28-Mar-04 22:16
Andy H28-Mar-04 22:16 
GeneralRe: Borderless CheckBox control Pin
jillellamudi29-Mar-04 1:00
jillellamudi29-Mar-04 1:00 
GeneralNumeric Pin
quocbao28-Mar-04 21:57
quocbao28-Mar-04 21:57 
GeneralRe: Numeric Pin
Colin Angus Mackay28-Mar-04 22:16
Colin Angus Mackay28-Mar-04 22:16 
GeneralRe: Numeric Pin
bertcox28-Mar-04 22:45
bertcox28-Mar-04 22:45 
GeneralRe: Validating data during row changes Pin
Mazdak28-Mar-04 21:52
Mazdak28-Mar-04 21:52 
Generalhooking keyboard and mouse messages Pin
Saleh Alshadheli28-Mar-04 21:46
Saleh Alshadheli28-Mar-04 21:46 
GeneralRe: hooking keyboard and mouse messages Pin
Mazdak28-Mar-04 21:50
Mazdak28-Mar-04 21:50 
GeneralRe: hooking keyboard and mouse messages Pin
oOomen28-Mar-04 22:08
oOomen28-Mar-04 22:08 
GeneralRe: hooking keyboard and mouse messages Pin
Heath Stewart29-Mar-04 4:13
protectorHeath Stewart29-Mar-04 4:13 
Questionscrolling listView ?? Pin
azusakt28-Mar-04 21:21
azusakt28-Mar-04 21:21 
AnswerRe: scrolling listView ?? Pin
Heath Stewart29-Mar-04 3:45
protectorHeath Stewart29-Mar-04 3:45 
GeneralRe: scrolling listView ?? Pin
azusakt29-Mar-04 15:05
azusakt29-Mar-04 15:05 
GeneralRe: scrolling listView ?? Pin
Heath Stewart29-Mar-04 17:20
protectorHeath Stewart29-Mar-04 17:20 
GeneralThe connection is already Open (state=Open). Pin
dabuskol28-Mar-04 21:04
dabuskol28-Mar-04 21:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.