1.radiobox: radio按钮!!!
(1)对每个按钮都要单独做一个事件,用switch函数
(2)要在这个类里面声明一个代表这个radio变量的对象 例如: string sex;
private void rdbtnM_CheckedChanged(object sender, EventArgs e)
{
if (!((RadioButton)sender).Checked)
{
return;
}
switch (((RadioButton)sender).Text.ToString())
{
case "男":
sex = "男";
break;
case "女":
sex = "女";
break;
default:
break;
}
}
2.combobox:下拉列表!!!
load方法,最开始界面初始时候的调用:
string sqlD = @"SELECT [DeptNo]
,[DeptName]
FROM [test2016].[dbo].[Department]"; //从sql server中剪切出
DataTable dtD = DBHelper.TableSelect(sqlD);
cboDeptNo.DataSource = dtD;
cboDeptNo.DisplayMember = dtD.Columns["DeptNo"].ToString();
cboDeptNo.ValueMember = dtD.Columns["DeptNo"].ToString();
cboDeptNo.SelectedIndex = 0;
之后在选择了下拉列表之后,显示更改的方法:
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = @"select a.TNo,c.TNmae,b.CName,b.CTime,a.Term,a.WYear
from WORKS a,COURSES b,TEACHERS c
where a.CNo=b.CNo and c.TNo=a.TNo and a.TNo=@TNo";
SqlParameter[] para = { new SqlParameter("@TNo", comboBox1.SelectedValue.ToString()) };
dataGridView1.DataSource = DBHelper.TableSelect(sql, para);
}
3.checkbox:单选按钮!!!
if (checkBox1.CheckState == CheckState.Checked) // if语句,判断是否处于选中状态
{
sql += string.Format(@"and b.DeptNo='{0}' ", cboDeptNo.SelectedValue.ToString());
}
dv.DataSource = DBHelper.TableSelect(sql);
if (checkBox3.CheckState == CheckState.Checked)
{
sql += string.Format(@"and a.SName like '%{0}%' ", textBox1.Text); //模糊查询,text中的操作方式
}