Error: Index is outside the bounds of the array

[weird0]

I have no idea why this error this is coming and how can i fix it?
Can anyone please help me with it............. .?

public static class BillManager
{
private static Object ExecuteSP(Objec t[] argArray)
{
SqlCommand sqlcmd = new SqlCommand();
SqlConnection sqlconnection1 = new SqlConnection() ;
sqlcmd.Connecti on = sqlconnection1;
Object returnValue;
int paramCount = (int)argArray[1]; // the number of
parameters
sqlcmd.CommandT ext = (string)argArra y[2]; // the whole
query
sqlcmd.CommandT ype = CommandType.Sto redProcedure;

for (int j = 0, i = 3; j < paramCount; i += 4, j++)
{
SqlParameter myPrm = new
SqlParameter((s tring)argArray[i],

(SqlDbType)argA rray[i + 1],

(int)argArray[i + 2]); // Line of Error
myPrm.Value = argArray[i + 3];
sqlcmd.Paramete rs.Add(myPrm);
}

sqlconnection1. Open();

if ((int)argArray[0] == 0)
returnValue = sqlcmd.ExecuteN onQuery(); //
returns the number of rows affected
if ((int)argArray[0] == 1)
returnValue = sqlcmd.ExecuteS calar(); //
returns a single value
else
returnValue =
sqlcmd.ExecuteR eader(CommandBe havior.CloseCon nection); //returns
multiple values

return returnValue;

}
public static void Insert_Utility_ Bill(string CompanyName,
string CustomerId, string Alias, string UserName)
{
object[] prms = new object[11];

prms[0] = 0;
prms[1] = 4;
prms[2] = "INSERT_UTILITY _BILL";
prms[3] = "@COMPANYNA ME";
prms[4] = SqlDbType.VarCh ar;
prms[5] = 50;
prms[6] = CompanyName;
prms[7] = "@CUSTOMERI D";
prms[8] = SqlDbType.NChar ;
prms[9] = 10;
prms[10] = CustomerId.ToCh arArray();
prms[7] = "@ALIAS";
prms[8] = SqlDbType.VarCh ar;
prms[9] = 50;
prms[10] = Alias;
prms[7] = "@USERNAME" ;
prms[8] = SqlDbType.VarCh ar;
prms[9] = 50;
prms[10] = UserName;

ExecuteSP(prms) ;

}
}

[Nicholas Paldino [.NET/C# MVP]]

Well, it's rather obvious. You have an array that you giving an index
to which is outside the bounds of the array.

What happens when you debug this? The debugger will most certainly tell
you what the problem is.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"weird0" <am********@gma il.comwrote in message
news:11******** **************@ l77g2000hsb.goo glegroups.com.. .

I have no idea why this error this is coming and how can i fix it?
Can anyone please help me with it............. .?

public static class BillManager
{
private static Object ExecuteSP(Objec t[] argArray)
{
SqlCommand sqlcmd = new SqlCommand();
SqlConnection sqlconnection1 = new SqlConnection() ;
sqlcmd.Connecti on = sqlconnection1;
Object returnValue;
int paramCount = (int)argArray[1]; // the number of
parameters
sqlcmd.CommandT ext = (string)argArra y[2]; // the whole
query
sqlcmd.CommandT ype = CommandType.Sto redProcedure;

for (int j = 0, i = 3; j < paramCount; i += 4, j++)
{
SqlParameter myPrm = new
SqlParameter((s tring)argArray[i],

(SqlDbType)argA rray[i + 1],

(int)argArray[i + 2]); // Line of Error
myPrm.Value = argArray[i + 3];
sqlcmd.Paramete rs.Add(myPrm);
}

sqlconnection1. Open();

if ((int)argArray[0] == 0)
returnValue = sqlcmd.ExecuteN onQuery(); //
returns the number of rows affected
if ((int)argArray[0] == 1)
returnValue = sqlcmd.ExecuteS calar(); //
returns a single value
else
returnValue =
sqlcmd.ExecuteR eader(CommandBe havior.CloseCon nection); //returns
multiple values

return returnValue;

}
public static void Insert_Utility_ Bill(string CompanyName,
string CustomerId, string Alias, string UserName)
{
object[] prms = new object[11];

prms[0] = 0;
prms[1] = 4;
prms[2] = "INSERT_UTILITY _BILL";
prms[3] = "@COMPANYNA ME";
prms[4] = SqlDbType.VarCh ar;
prms[5] = 50;
prms[6] = CompanyName;
prms[7] = "@CUSTOMERI D";
prms[8] = SqlDbType.NChar ;
prms[9] = 10;
prms[10] = CustomerId.ToCh arArray();
prms[7] = "@ALIAS";
prms[8] = SqlDbType.VarCh ar;
prms[9] = 50;
prms[10] = Alias;
prms[7] = "@USERNAME" ;
prms[8] = SqlDbType.VarCh ar;
prms[9] = 50;
prms[10] = UserName;

ExecuteSP(prms) ;

}
}

[=?Utf-8?B?SHVzYW0gQWwtQScnYXJhag==?=]

Hi,
Ckech the content of the Array object you are sending. This error means that
Your index value grater then the array you are sneding

Regards,
Husam Al-a'araj

"weird0" wrote:

I have no idea why this error this is coming and how can i fix it?
Can anyone please help me with it............. .?

public static class BillManager
{
private static Object ExecuteSP(Objec t[] argArray)
{
SqlCommand sqlcmd = new SqlCommand();
SqlConnection sqlconnection1 = new SqlConnection() ;
sqlcmd.Connecti on = sqlconnection1;
Object returnValue;
int paramCount = (int)argArray[1]; // the number of
parameters
sqlcmd.CommandT ext = (string)argArra y[2]; // the whole
query
sqlcmd.CommandT ype = CommandType.Sto redProcedure;

for (int j = 0, i = 3; j < paramCount; i += 4, j++)
{
SqlParameter myPrm = new
SqlParameter((s tring)argArray[i],

(SqlDbType)argA rray[i + 1],

(int)argArray[i + 2]); // Line of Error
myPrm.Value = argArray[i + 3];
sqlcmd.Paramete rs.Add(myPrm);
}

sqlconnection1. Open();

if ((int)argArray[0] == 0)
returnValue = sqlcmd.ExecuteN onQuery(); //
returns the number of rows affected
if ((int)argArray[0] == 1)
returnValue = sqlcmd.ExecuteS calar(); //
returns a single value
else
returnValue =
sqlcmd.ExecuteR eader(CommandBe havior.CloseCon nection); //returns
multiple values

return returnValue;

}
public static void Insert_Utility_ Bill(string CompanyName,
string CustomerId, string Alias, string UserName)
{
object[] prms = new object[11];

prms[0] = 0;
prms[1] = 4;
prms[2] = "INSERT_UTILITY _BILL";
prms[3] = "@COMPANYNA ME";
prms[4] = SqlDbType.VarCh ar;
prms[5] = 50;
prms[6] = CompanyName;
prms[7] = "@CUSTOMERI D";
prms[8] = SqlDbType.NChar ;
prms[9] = 10;
prms[10] = CustomerId.ToCh arArray();
prms[7] = "@ALIAS";
prms[8] = SqlDbType.VarCh ar;
prms[9] = 50;
prms[10] = Alias;
prms[7] = "@USERNAME" ;
prms[8] = SqlDbType.VarCh ar;
prms[9] = 50;
prms[10] = UserName;

ExecuteSP(prms) ;

}
}

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

weird0 wrote:

I have no idea why this error this is coming and how can i fix it?
Can anyone please help me with it............. .?

--8<-- snip

>
public static void Insert_Utility_ Bill(string CompanyName,
string CustomerId, string Alias, string UserName)
{
object[] prms = new object[11];

prms[0] = 0;
prms[1] = 4;
prms[2] = "INSERT_UTILITY _BILL";
prms[3] = "@COMPANYNA ME";
prms[4] = SqlDbType.VarCh ar;
prms[5] = 50;
prms[6] = CompanyName;
prms[7] = "@CUSTOMERI D";
prms[8] = SqlDbType.NChar ;
prms[9] = 10;
prms[10] = CustomerId.ToCh arArray();

Hm... What number might be following 10? ;)

prms[7] = "@ALIAS";
prms[8] = SqlDbType.VarCh ar;
prms[9] = 50;
prms[10] = Alias;
prms[7] = "@USERNAME" ;
prms[8] = SqlDbType.VarCh ar;
prms[9] = 50;
prms[10] = UserName;

ExecuteSP(prms) ;

}
}

--
Göran Andersson
_____
http://www.guffa.com

[rossum]

On 4 Apr 2007 12:45:07 -0700, "weird0" <am********@gma il.comwrote:

I have no idea why this error this is coming and how can i fix it?
Can anyone please help me with it............. .?

[snip]

>(int)argArra y[i + 2]); // Line of Error

Step through your program with the Debugger. Set a watch on the
values of i and on argArray. Check the value of i+2 against the size
of argArray every time through your loop.

rossum