StringDictionary does not persist values after sometime

[rajmgopal]

Hi
I am using a StringDictionary to store and pass a few string values
retrieved from sql server database.
I am using these values as inputs to several stored procedures
After processing a few 100 or 1000 records , I get an error saying that

one of the stored procedure parameter is expecting a value (which I
assign from StringDictionary) but not receiving the same

I have not been able to resolve the issue.

I would appreciate it if someone could give me some suggestions to
solve the problem

For now in the method where I get the error, I am explicitly
re-assigning the value of the missing variable.

Thank you
Regards
Raj

 

[Herfried K. Wagner [MVP]]

I am using a StringDictionary to store and pass a few string values
retrieved from sql server database.
I am using these values as inputs to several stored procedures
After processing a few 100 or 1000 records , I get an error saying that

one of the stored procedure parameter is expecting a value (which I
assign from StringDictionary) but not receiving the same

Re-check all places where write-access to the dictionary occurs. I assume
that there is a bug somewhere in your implementation. If you are not able
to locate it, even not using the debugger, you could post relevant pieces of
the code here.

 

[dotNetDeveloper]

Hi Mr Wagner
There was indeed a bug which I had not taken into account the previous
time I was trying to locate the problem
I was able to identify and rectify it

Thank you for your prompt reply and helpful suggestion
Regards
RK