"Index was outside the bounds of the array" on Add

[kim]

Scenario (I'm a newbie): I have a datagrid with countries
listed and 5 parameters in each row. I want to add a row
to this datagrid via an Event Handler. Very basic stuff.
This method then call a Business method, which calls a
Data method which calls an SP in MS SQL.

My code compiles well, but the page throws "Index was
outside the bounds of the array". I really can't figure
why, take a look maybe you pros see can read between the
lines:

----- .apsx page:

protected void AddNew_Click(ob ject sender, EventArgs e)
{
if (Page.IsValid)
{
//convert to Int
int milobs =
Convert.ToInt32 (NewContribMilo bs.Text);
int contingent =
Convert.ToInt32 (NewContribCont ingent.Text);

Business.Contri bCountry
contribCountry = new Business.Contri bCountry();
//SiteIdentity currUser =
(SiteIdentity)C ontext.User.Ide ntity;

// add the new record
contribCountry. Create
(NewContribCoun try.Text.Trim() , NewContribPays. Text.Trim
(), milobs, contingent, currUser.UserID ).Visible = true;

ShowAddNewContr ols(false);
BindGrid();
}
}

---- business class:
// create a new record
public int Create(string country, string
pays, int milobs, int contingent, int userID)
{
Data.Military military = new
Data.Military(s ettings.Connect ionString);
countryID = military.Add(co untry,
pays, milobs, contingent, userID);
return countryID;
}

---- data class:
// add a military
public int Add(string country, string
pays, int milobs, int contingent, int userID)
{
int numAffected;

// create the parameters
SqlParameter[] parameters = {

new SqlParameter
("@Country", SqlDbType.VarCh ar, 25),

new SqlParameter("@ Pays",
SqlDbType.VarCh ar, 25),

new SqlParameter
("@Milobs", SqlDbType.Int, 4),

new SqlParameter
("@Contingen t", SqlDbType.Int, 4),

new SqlParameter
("@UserID", SqlDbType.Int, 4)

};

// set the values
parameters[0].Value = country.Trim
();
parameters[1].Value = pays.Trim();
parameters[2].Value = milobs;
parameters[3].Value = contingent;
parameters[4].Value = userID;
parameters[5].Direction =
ParameterDirect ion.Output;

RunProcedure
("sp_Contributi ons_Military_In sert", parameters, out
numAffected);

return (int)parameters[5].Value;
}

---- end

Thanks in advance for any help.

[Marina]

It would be very helpful if you told us which line of code throws the error.

"kim" <ki********@yah oo.com> wrote in message
news:01******** *************** *****@phx.gbl.. .

Scenario (I'm a newbie): I have a datagrid with countries
listed and 5 parameters in each row. I want to add a row
to this datagrid via an Event Handler. Very basic stuff.
This method then call a Business method, which calls a
Data method which calls an SP in MS SQL.

My code compiles well, but the page throws "Index was
outside the bounds of the array". I really can't figure
why, take a look maybe you pros see can read between the
lines:

----- .apsx page:

protected void AddNew_Click(ob ject sender, EventArgs e)
{
if (Page.IsValid)
{
//convert to Int
int milobs =
Convert.ToInt32 (NewContribMilo bs.Text);
int contingent =
Convert.ToInt32 (NewContribCont ingent.Text);

Business.Contri bCountry
contribCountry = new Business.Contri bCountry();
//SiteIdentity currUser =
(SiteIdentity)C ontext.User.Ide ntity;

// add the new record
contribCountry. Create
(NewContribCoun try.Text.Trim() , NewContribPays. Text.Trim
(), milobs, contingent, currUser.UserID ).Visible = true;

ShowAddNewContr ols(false);
BindGrid();
}
}

---- business class:
// create a new record
public int Create(string country, string
pays, int milobs, int contingent, int userID)
{
Data.Military military = new
Data.Military(s ettings.Connect ionString);
countryID = military.Add(co untry,
pays, milobs, contingent, userID);
return countryID;
}

---- data class:
// add a military
public int Add(string country, string
pays, int milobs, int contingent, int userID)
{
int numAffected;

// create the parameters
SqlParameter[] parameters = {

new SqlParameter
("@Country", SqlDbType.VarCh ar, 25),

new SqlParameter("@ Pays",
SqlDbType.VarCh ar, 25),

new SqlParameter
("@Milobs", SqlDbType.Int, 4),

new SqlParameter
("@Contingen t", SqlDbType.Int, 4),

new SqlParameter
("@UserID", SqlDbType.Int, 4)

};

// set the values
parameters[0].Value = country.Trim
();
parameters[1].Value = pays.Trim();
parameters[2].Value = milobs;
parameters[3].Value = contingent;
parameters[4].Value = userID;
parameters[5].Direction =
ParameterDirect ion.Output;

RunProcedure
("sp_Contributi ons_Military_In sert", parameters, out
numAffected);

return (int)parameters[5].Value;
}

---- end

Thanks in advance for any help.