ADO.NET Execute Stored Procedure with Parameter

SqlConnection myConnection = new SqlConnection(Environment.GetEnvironmentVariable("SqlDbConnectionString"));
myConnection.Open();

SqlCommand myCommand = new SqlCommand("pr_UPDATE_Table", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(new SqlParameter("@AppAlertId", dtList.Rows[i]["TableId"]));
myCommand.ExecuteNonQuery();

myConnection.Close();