页面启动:(private void Reg_Load(object sender, EventArgs e)
)
//获取医生 默认内科的医生
update_combox_doctor(comboBox2.Text.Trim());
封装函数,方便复用
//切换科室, 获取医生信息
public void update_combox_doctor(String officeName)
{
try
{
//连接查询
//select a.staffID,a.name from staffInfor a inner join officeInfor b on a.officeID = b.officeID where b.officeName = '内科'
string sql_doc = string.Format("select a.staffID,a.name from staffInfor a inner join officeInfor b on a.officeID = b.officeID where b.officeName = '{0}'",officeName);
SqlCommand cmd = new SqlCommand(sql_doc, DBConn.conn);
DBConn.conn.Open()
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
this.comboBox3.Items.Add("[" + dr[0].ToString() + "]" + dr[1].ToString())
/