SqlDataSource - parameters?

[realgeek]

I have the following code:

SqlDataSource ds = new SqlDataSource() ;
ds.ConnectionSt ring =
WebConfiguratio nManager.Connec tionStrings["AnketaDBConnec tionString"].ToString();
ds.UpdateComman d = "ad_SetAnsw er";
ds.UpdateComman dType = SqlDataSourceCo mmandType.Store dProcedure;
ds.UpdateParame ters.Add(new Parameter("@Que stionID"));
ds.UpdateParame ters.Add(new Parameter("@Ans wer"));
foreach (RepeaterItem li in Repeater1.Items )
{
int QuestionID =
int.Parse(((Htm lInputHidden)li .FindControl("h dQuestionID")). Value);
int Answer =
int.Parse(((Rad ioButtonList)li .FindControl("r blAnswers")).Se lectedValue);
ds.UpdateParame ters["@QuestionI D"].DefaultValue =
QuestionID.ToSt ring();
ds.UpdateParame ters["@Answer"].DefaultValue = Answer.ToString ();
ds.Update();
}
On the very first loop iteration I get the following:
Procedure or Function 'ad_SetAnswer' expects parameter '@QuestionID',
which was not supplied.

What's up with that? How do I work with parameters in SqlDataSource?
In fact, is there a better way to model SqlCOmmand cmd = ...;
cmd.ExecuteNonQ uery();?

[Miha Markic [MVP C#]]

I suggest you to use SqlCommand instead.
It will be easier..

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

<re******@gmail .com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

I have the following code:

SqlDataSource ds = new SqlDataSource() ;
ds.ConnectionSt ring =
WebConfiguratio nManager.Connec tionStrings["AnketaDBConnec tionString"].ToString();
ds.UpdateComman d = "ad_SetAnsw er";
ds.UpdateComman dType = SqlDataSourceCo mmandType.Store dProcedure;
ds.UpdateParame ters.Add(new Parameter("@Que stionID"));
ds.UpdateParame ters.Add(new Parameter("@Ans wer"));
foreach (RepeaterItem li in Repeater1.Items )
{
int QuestionID =
int.Parse(((Htm lInputHidden)li .FindControl("h dQuestionID")). Value);
int Answer =
int.Parse(((Rad ioButtonList)li .FindControl("r blAnswers")).Se lectedValue);
ds.UpdateParame ters["@QuestionI D"].DefaultValue =
QuestionID.ToSt ring();
ds.UpdateParame ters["@Answer"].DefaultValue = Answer.ToString ();
ds.Update();
}
On the very first loop iteration I get the following:
Procedure or Function 'ad_SetAnswer' expects parameter '@QuestionID',
which was not supplied.

What's up with that? How do I work with parameters in SqlDataSource?
In fact, is there a better way to model SqlCOmmand cmd = ...;
cmd.ExecuteNonQ uery();?