modify SqlDataSource parameters in code behind?

[Dabbler]

I have a TextBox used to enter a search value and a DropDownList used to
select which field should be searched on. I need to load a GridView with the
search results.

I have setup multiple select stored procedures and need to set the
SqlDataSource to use the required stored procedure and pass the value in the
TextBox to search with.

The following code sets up the SelectParameter s for the SqlDataSource:
RegistrantsSqlD ataSource.Selec tParameters.Cle ar();
switch(selectio nChoice){ // from DropDownList
case "Name":
Session["SelectComm and"] = "GetRegListbyNa me";
RegistrantsSqlD ataSource.Selec tParameters.Add ( "Name",
TypeCode.String .ToString());
break;
case "Phone":
Session["SelectComm and"] = "GetRegListbyPh one";
RegistrantsSqlD ataSource.Selec tParameters.Add ( "Phone",
TypeCode.String .ToString());
break;
etc...
I don't know how to pass the search value from the TextBox to the
SqlDataSource which the GridView is bound to.

Any suggestions would be appreciated, I'm going crosseyed looking at this.

[Phillip Williams]

The syntax in the codebehind:
RegistrantsSqlD ataSource.Selec tParameters["Name"].DefaultValue =
txtSearchKeyWor d.Text;

The declarative syntax:
<SelectParamete rs>
<asp:ControlPar ameter ControlID="txtS earchKeyWord" Name="SearchKey Word"
PropertyName="T ext" />
<asp:ControlPar ameter ControlID="ddlS earchCategory" Name="Category"
PropertyName="S electedValue" />
</SelectParameter s>
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I have a TextBox used to enter a search value and a DropDownList used to
select which field should be searched on. I need to load a GridView with the
search results.

I have setup multiple select stored procedures and need to set the
SqlDataSource to use the required stored procedure and pass the value in the
TextBox to search with.

The following code sets up the SelectParameter s for the SqlDataSource:
RegistrantsSqlD ataSource.Selec tParameters.Cle ar();
switch(selectio nChoice){ // from DropDownList
case "Name":
Session["SelectComm and"] = "GetRegListbyNa me";
RegistrantsSqlD ataSource.Selec tParameters.Add ( "Name",
TypeCode.String .ToString());
break;
case "Phone":
Session["SelectComm and"] = "GetRegListbyPh one";
RegistrantsSqlD ataSource.Selec tParameters.Add ( "Phone",
TypeCode.String .ToString());
break;
etc...
I don't know how to pass the search value from the TextBox to the
SqlDataSource which the GridView is bound to.

Any suggestions would be appreciated, I'm going crosseyed looking at this.

[Dabbler]

Thanks so much.. I was going batty, and I thought this propery was for a
value if you didn't have a value to set. I also forgot to set the
SelectCommandTy pe. But it all works now!
"Phillip Williams" wrote:

The syntax in the codebehind:
RegistrantsSqlD ataSource.Selec tParameters["Name"].DefaultValue =
txtSearchKeyWor d.Text;

The declarative syntax:
<SelectParamete rs>
<asp:ControlPar ameter ControlID="txtS earchKeyWord" Name="SearchKey Word"
PropertyName="T ext" />
<asp:ControlPar ameter ControlID="ddlS earchCategory" Name="Category"
PropertyName="S electedValue" />
</SelectParameter s>
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com
"Dabbler" wrote:

I have a TextBox used to enter a search value and a DropDownList used to
select which field should be searched on. I need to load a GridView with the
search results.

I have setup multiple select stored procedures and need to set the
SqlDataSource to use the required stored procedure and pass the value in the
TextBox to search with.

The following code sets up the SelectParameter s for the SqlDataSource:
RegistrantsSqlD ataSource.Selec tParameters.Cle ar();
switch(selectio nChoice){ // from DropDownList
case "Name":
Session["SelectComm and"] = "GetRegListbyNa me";
RegistrantsSqlD ataSource.Selec tParameters.Add ( "Name",
TypeCode.String .ToString());
break;
case "Phone":
Session["SelectComm and"] = "GetRegListbyPh one";
RegistrantsSqlD ataSource.Selec tParameters.Add ( "Phone",
TypeCode.String .ToString());
break;
etc...
I don't know how to pass the search value from the TextBox to the
SqlDataSource which the GridView is bound to.

Any suggestions would be appreciated, I'm going crosseyed looking at this.