[方法一]:
动态向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);
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);