62,072
社区成员
发帖
与我相关
我的任务
分享
string sql = "data source=.;initial catalog=shetuan;integrated Security=sspi;";
SqlConnection cn = new SqlConnection(sql);
cn.Open();
string cd = "select * from 会员管理 where 1=1";
string s = TextBox1.Text.Trim ();
string t = TextBox2.Text.Trim ();
string r = TextBox3.Text.Trim ();
if (s!= "")
cd+="or xingming like '%"+s+"%' ";
if (t != "")
{
cd += "or zhuanye like '%" + t + "%' ";
}
if (r != "")
{
cd += "or name like '%" + r + "%' ";
}
SqlCommand cmd = new SqlCommand(cd, cn);
SqlDataAdapter da = new SqlDataAdapter(cd, cn);
DataSet ds = new DataSet();
da.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];
cmd.ExecuteNonQuery();
cn.Close();