执行带参的sql和带参的存储过程以及不带参

  

    SqlParameter myparm = new SqlParameter();
        myparm.ParameterName = "@id";
        myparm.SqlDbType = SqlDbType.NVarChar;
        myparm.Size = 20;
        myparm.Value = "10";
       
       // SqlParameter myparm=new SqlParameter("@id",SqlDbType.NVarChar,20);
       // myparm.Value="10";
       
        string sql = "update myTable set name='my51aspx' where id=@id ";

        SqlConnection conn;

        if (conn = null)
        {

            conn=new SqlConnection(ConfigurationManager.AppSettings["connectionstring"]);
            //<add key="GLD.DBConnectionString" value="server=LIUDE-0BE49E08D;uid=sa;pwd=sa;database=PA;" />
            //conn = new SqlConnection("Data Source=LIUDE-A4AEE2093;Initial Catalog=db_Student;User ID=sa;pwd=sa ");

        }

        if (conn.State = System.Data.ConnectionState.Closed);
        conn.Open();
      
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = sql;
       
        cmd.CommandType = CommandType.Text;

        cmd.Parameters.Add(myparm);
        cmd.ExecuteNonQuery();
        cmd.Parameters.Clear();

      //  在这段程序于中只要把

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "写上存储过程的名字";
        //那么上述程序，就是带参数的存储过程：

        //若不带参数的话，就不要参数即可