pass textbox value to storedprocedure

[jed]

I need to pass a value that is inserted by the user in a textbox to a
variable in my stored procedure. please help

 

[Peter Bradley]

What have you tried?


Peter

 

[jed]

Well i have declared a variable in SQLExpress and need to assign the
value to it.i am
a newbie and am not sure how to start.should i create a connection to
sql in code then open the connection and try access it through there

 

[salman]

Well i have declared a variable in SQLExpress and need to assign the
value to it.i am
a newbie and am not sure how to start.should i create a connection to
sql in code then open the connection and try access it through there

very simple

this.SqlCommand = new SqlCommand("myProcedureName",
this.SqlConnection);
this.SqlCommand.CommandType = CommandType.StoredProcedure;

this.SqlCommand.Parameters.Add("@variableName1",
SqlDbType.VarChar).Value = variableValue1;
this.SqlCommand.Parameters.Add("@variableName2",
SqlDbType.Int).Value = variableValue2;