Try something like this:

string conn_str1="Data Source=localhost;Initial Catalog=master;User Id=sa;Password=xxxx;";

using (SqlConnection conn = new SqlConnection(conn_str1))

{

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText= [proc_name_here];

conn.Open();

cmd.ExecuteNonQuery();

}

Edit: You'll have to add the parameter in separately, but that shouldn't be too much trouble.