动态添加SqlParameter

[方法一]：

动态向SqlParameter 里添加相应参数,方法如下

先定义一个List,然后再往List里面添加SqlParameter对象,然后将List转为SqlParameter数组即可 

List<SqlParameter> ilist = new List<SqlParameter>();

            ilist.Add(new SqlParameter("@Param1", "1"));

            ilist.Add(new SqlParameter("@Param2", "2"));

            ilist.Add(new SqlParameter("@Param3", "3"));

            ilist.Add(new SqlParameter("@Param4", "4"));

            ilist.Add(new SqlParameter("@ParamLike","%5%"));//Like的写法

            SqlParameter[] param = ilist.ToArray();

（demo1）

 List<SqlParameter> sqlList = new List<SqlParameter>();
            StringBuilder  sqltext = new StringBuilder("select * from ProductSn where REF >@REF");
            if (checkBox1.Checked == true & textBox1.Text.ToString().Trim() != "")
            {
                sqltext.Append(" and INVOICENO= @INVOICENO ");                
                SqlParameter INVOICENO =  new SqlParameter("@INVOICENO", SqlDbType.NVarChar, 50);
                INVOICENO.Value = textBox1.Text.ToString().Trim();
                INVOICENO.Direction = ParameterDirection.Input;
                sqlList.Add(INVOICENO); 
            }
            if (checkBox1.Checked == true & textBox2.Text.ToString().Trim() != "" & textBox3.Text.ToString().Trim() != "")
            {
                sqltext.Append(" and [BIKE SN]  @beginSn and @endsn");
                SqlParameter BeginSn = new SqlParameter("@beginSn", SqlDbType.NVarChar, 50);
                BeginSn.Direction = ParameterDirection.Input;
                BeginSn.Value = this.textBox2.Text.ToString();
                SqlParameter EndSn = new SqlParameter("@endsn", SqlDbType.NVarChar, 50);
                EndSn.Direction = ParameterDirection.Input;
                EndSn.Value = this.textBox3.Text.ToString();
                sqlList.Add(BeginSn);
                sqlList.Add(EndSn);
            }
            SqlParameter[] parms = sqlList.ToArray();
            _DBConfig.DB.SqlQuery(sqltext.ToString(), parms);

 

 [方法二]

sqlsp = "BlogArticle_Update";                SqlParameter[] param = {                                        new SqlParameter("Content",Content.Value),                                    };                //重构数组                SqlParameter[] param2;                if (IsDefineWeight == "1")                {                    int newNum = param.Length + 1;                    param2 = (SqlParameter[])Redim(param, newNum);                    param2[newNum - 1] = new SqlParameter("Weight", weight.Text);