连接数据库
public static String connstr = "server=.;database=test2008;uid=sa;pwd=a123456";
public static DataTable ExecuteTable (String sql,params SqlParameter [] ps)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
sda.SelectCommand.Parameters.AddRange(ps);
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
}
组合+模糊查询
public Form2()
{
InitializeComponent();
textBox2.Enabled = false;
textBox3.Enabled = false;
}
private void checkBox2_CheckedChanged(object sender, EventArgs e)
{
if (checkBox2.Checked)
{
textBox2.Enabled = true;
}
else
{
textBox2.Enabled = false;
}
}
private void checkBox3_CheckedChanged(object sender, EventArgs e)
{
if (checkBox3.Checked)
{
textBox3.Enabled = true;
}
else
{
textBox3.Enabled = false;
}
}
private void button1_Click(object sender, EventArgs e)
{
String sql = "select SNO,SNMAE,SSEX,SSCORE,CNAME,ANAME from Student,Class,Academic where Student.CNO = Class.CNO and Class.ANO = Academic.ANO";
if (checkBox1.Checked)
{
sql += " and SNMAE like @SNMAE";
if (textBox1.Text.Length < 1)
{
MessageBox.Show("请输入正确的姓名");
return;
}
}
if (checkBox2.Checked)
{
sql += " and CNAME like @CNAME";
if (textBox2.Text.Length < 1)
{
MessageBox.Show("请输入正确的班级");
return;
}
}
if (checkBox3.Checked)
{
sql += " and ANAME like @ANAME";
if (textBox3.Text.Length < 1)
{
MessageBox.Show("请输入正确的学院");
return;
}
}
if (radioButton1.Checked)
{
sql += " order by SNO asc";
}
else
{
sql += " order by SNO desc";
}
DataTable dt = SqlHelper.ExecuteTable(sql, new SqlParameter("@SNMAE","%"+ textBox1.Text+ "%"), new SqlParameter("@CNAME", "%"+ textBox2.Text+ "%"), new SqlParameter("@ANAME", "%"+ textBox3.Text+ "%"));
dataGridView1.DataSource = dt;
if (dt.Rows.Count < 1)
{
MessageBox.Show("无相关信息");
}
}
public static String connstr = "server=.;database=test2008;uid=sa;pwd=a123456";
public static DataTable ExecuteTable (String sql,params SqlParameter [] ps)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
sda.SelectCommand.Parameters.AddRange(ps);
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
}
组合+模糊查询
public Form2()
{
InitializeComponent();
textBox2.Enabled = false;
textBox3.Enabled = false;
}
private void checkBox2_CheckedChanged(object sender, EventArgs e)
{
if (checkBox2.Checked)
{
textBox2.Enabled = true;
}
else
{
textBox2.Enabled = false;
}
}
private void checkBox3_CheckedChanged(object sender, EventArgs e)
{
if (checkBox3.Checked)
{
textBox3.Enabled = true;
}
else
{
textBox3.Enabled = false;
}
}
private void button1_Click(object sender, EventArgs e)
{
String sql = "select SNO,SNMAE,SSEX,SSCORE,CNAME,ANAME from Student,Class,Academic where Student.CNO = Class.CNO and Class.ANO = Academic.ANO";
if (checkBox1.Checked)
{
sql += " and SNMAE like @SNMAE";
if (textBox1.Text.Length < 1)
{
MessageBox.Show("请输入正确的姓名");
return;
}
}
if (checkBox2.Checked)
{
sql += " and CNAME like @CNAME";
if (textBox2.Text.Length < 1)
{
MessageBox.Show("请输入正确的班级");
return;
}
}
if (checkBox3.Checked)
{
sql += " and ANAME like @ANAME";
if (textBox3.Text.Length < 1)
{
MessageBox.Show("请输入正确的学院");
return;
}
}
if (radioButton1.Checked)
{
sql += " order by SNO asc";
}
else
{
sql += " order by SNO desc";
}
DataTable dt = SqlHelper.ExecuteTable(sql, new SqlParameter("@SNMAE","%"+ textBox1.Text+ "%"), new SqlParameter("@CNAME", "%"+ textBox2.Text+ "%"), new SqlParameter("@ANAME", "%"+ textBox3.Text+ "%"));
dataGridView1.DataSource = dt;
if (dt.Rows.Count < 1)
{
MessageBox.Show("无相关信息");
}
}