On Mar 26, 5:16 pm, j...@auto-soft.co.za wrote:
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;