what's causing this array index error?!?!?

  • Thread starter Thread starter ChrisB
  • Start date Start date
C

ChrisB

Hello:

I am attempting to execute the following code which was created with Visual
Studio 2003:

SqlParameter[] DateParameters = new SqlParameter[5];
DateParameters[0] = new SqlParameter("@ConsumerDateID", _dateID);

DateParameters[1] = new SqlParameter("@ConsumerID", Consumer.ConsumerID);

DateParameters[2] = new SqlParameter("@ConsumerDateTypeID", _typeID);

DateParameters[3] = new SqlParameter("@Value", _value);

DateParameters[4] = new SqlParameter("@Index", _index);

I am receiving the following error each time the runtime attempts to store
the DateParameter[3] value (error thrown before next line even reached):

"Index (zero based) must be greater than or equal to zero and less than the
size of the argument list."

I have tried closing and recompiling my code on several occasions, and
altering the size of the array, but cannot get this to execute properly.

Is there an error in my code? Is there some type of IDE or compilation
issue that might be causing this?

Thanks for any insight!

Chris
 
Have you tried just copying the SqlParameter construction call from one of
the first 3 that work over the one that's failing, just to make sure the
error isn't in that somewhere? The assignment statements look fine...
 
ChrisB said:
Hello:

I am attempting to execute the following code which was created with Visual
Studio 2003:

SqlParameter[] DateParameters = new SqlParameter[5];
DateParameters[0] = new SqlParameter("@ConsumerDateID", _dateID);

DateParameters[1] = new SqlParameter("@ConsumerID", Consumer.ConsumerID);

DateParameters[2] = new SqlParameter("@ConsumerDateTypeID", _typeID);

DateParameters[3] = new SqlParameter("@Value", _value);

DateParameters[4] = new SqlParameter("@Index", _index);

I am receiving the following error each time the runtime attempts to store
the DateParameter[3] value (error thrown before next line even reached):

"Index (zero based) must be greater than or equal to zero and less than the
size of the argument list."

I have tried closing and recompiling my code on several occasions, and
altering the size of the array, but cannot get this to execute properly.

Is there an error in my code? Is there some type of IDE or compilation
issue that might be causing this?

Thanks for any insight!

Chris
Click to expand...


Well, Is this a a stored proceudre that you are trying to call? If yes,
you might want to show the stored procedure as well. I think the first
one is the RETURNVALUE from the stored procedure.. And, make sure that
its hitting the stored procedure that you think it should be hitting. :)
 
Thanks for the input Michael and Girish.

After spending some more time reviewing this code, I determined that the
problem was related to the fact that
_value contains an object (not a string).

The related line of code had to be changed to
DateParameters[3] = new SqlParameter("@Value", _value.date);

The index error message being thrown made debugging this a little confusing!

Thanks again.

Chris
 
Back
Top