private void button1_Click(object sender, EventArgs e)
{
string zhiri = maskedTextBox1.Text;
if (radioButton1.Checked == true)
{
sql = "select * from ******* where ******* like '%" + zhiri + "%'";
cmd = new SqlCommand(sql, Class1.me_conn);
sdr = cmd.ExecuteReader();
if (!sdr.Read())
{
MessageBox.Show("********");
maskedTextBox1.Clear();
maskedTextBox1.Focus();
}
//sdr.Close();
else
{
sdr.Close();
dataGridView1.Visible = true;
SqlDataAdapter sda = new SqlDataAdapter(sql, Class1.me_conn);
ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
sdr.Close();
}
if (radioButton2.Checked == true)
{
sql = "select * from **** where **** like '%" + zhiri + "%'";
cmd = new SqlCommand(sql, Class1.me_conn);
sdr = cmd.ExecuteReader();
if (!sdr.Read())
{
MessageBox.Show("**********");
maskedTextBox1.Clear();
maskedTextBox1.Focus();
}
//sdr.Close();
else
{
sdr.Close();
dataGridView1.Visible = true;
SqlDataAdapter sda = new SqlDataAdapter(sql, Class1.me_conn);
ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
sdr.Close();
}
if (radioButton3.Checked == true)
{
sql = "select * from ******* where ******* like '%" + zhiri + "%'";
cmd = new SqlCommand(sql,Class1.me_conn);
sdr = cmd.ExecuteReader();
if (!sdr.Read())
{
MessageBox.Show("*********");
maskedTextBox1.Clear();
maskedTextBox1.Focus();
}
//sdr.Close();
else
{
sdr.Close();
dataGridView1.Visible = true;
SqlDataAdapter sda = new SqlDataAdapter(sql, Class1.me_conn);
ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
sdr.Close();
}
//sdr.Close();
else
{
sdr.Close();
dataGridView1.Visible = true;
SqlDataAdapter sda = new SqlDataAdapter(sql, Class1.me_conn);
ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
sdr.Close();
}
这是一个单击事件下的带吗!还有其中****的地方为项目相应的词语!
温馨提示:答案为网友推荐,仅供参考