c# - Assign parameter to SqlDataSource -

c# - Assign parameter to SqlDataSource -

i have stored procedure has 2 varchar , 4 int parameters. want read content of textbox , filter sqldatasource when set of parameter type string , don't utilize varchar parameter things right when add together string parameter not work;

<selectparameters> <asp:parameter name="providerbranchid" defaultvalue="null" type="int32"/> <asp:parameter name="requestbranchid" defaultvalue="null" type="int32"/> <asp:parameter name="customerno" defaultvalue="null" type="int32" /> <asp:parameter name="boxestypecode" defaultvalue="null" type="int32" /> <asp:parameter name="boxesname" defaultvalue="null" type="string" /> </selectparameters>

and code behind in selecting event is...

temp1 = textbox1.text; temp2 = textbox2.text; temp3 = textbox5.text; temp4 = textbox6.text; temp5 = textbox4.text; temp6 = textboxname.text; e.command.parameters["@requestbranchid"].value = convert.toint32(temp1); e.command.parameters["@providerbranchid"].value = convert.toint32(temp2); e.command.parameters["@customerno"].value = convert.toint32(temp4); e.command.parameters["@boxestypecode"].value = convert.toint32(temp5); e.command.parameters["@boxesname"].value = temp6;

c# asp.net sql-server