
private void NewMethod() { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select * from table1 "); List<string> wheres = new List<string>(); List<SqlParameter> listParameters = new List<SqlParameter>(); if (textBox1.Text.Trim().Length > 0) { wheres.Add(" txt1 like @txt1"); listParameters.Add(new SqlParameter("@txt1", SqlDbType.NVarChar, 100) { Value = "%" + textBox1.Text.Trim() + "%" }); } if (textBox2.Text.Trim().Length > 0) { wheres.Add(" txt2 like @txt2"); listParameters.Add(new SqlParameter("@txt2", SqlDbType.NVarChar, 100) { Value = "%" + textBox1.Text.Trim() + "%" }); } if (textBox3.Text.Trim().Length > 0) { wheres.Add(" txt3 like @txt3"); listParameters.Add(new SqlParameter("@txt3", SqlDbType.NVarChar, 100) { Value = "%" + textBox1.Text.Trim() + "%" }); } if (wheres.Count > 0) { sqlStr.Append(" where "); sqlStr.Append(string.Join(" and ", wheres)); } string s = sqlStr.ToString(); SqlParameter[] pms = listParameters.ToArray(); //SqlHelper.ExecuteReader(s, pms); }