医院信息系统课程：选择患者（模拟刷卡）编号ID后自动加载病人信息[代码片段]

页面启动：private void Reg_Load(object sender, EventArgs e)

 //填充病号下拉框
try
{
    string sql3 = string.Format("select p_id from patient_infor");
    SqlCommand cmd = new SqlCommand(sql3, DBConn.conn);
    DBConn.conn.Open(
    SqlDataReader dr = cmd.ExecuteReader();
    while (dr.Read())
    {
        this.comboBox5.Items.Add(dr[0].ToString()
    }
    dr.Close();

catch (Exception ex)
{
    Console.WriteLine(ex.Message
}
finally
{
    DBConn.conn.Close();
}

监听：comboBox发生改变触发事件: comboBox_SelectedIndexChanged加载患者信息：

private void comboBox5_SelectedIndexChanged(object sender, EventArgs e)
{
    int p_id = 107; //默认编号
    int.TryParse(comboBox5.Text.Trim(), out p_id); //自带try
    try
    {
        string sql_doc = string.Format("select * from patient_infor where p_id = '{0}'", p_id);
        SqlCommand cmd = new SqlCommand(sql_doc, DBConn.conn);
        DBConn.conn.Open()
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            //将患者信息加载到textBox上
            this.textBox4.Text = dr[1].ToString();
            this.textBox3.Text = dr[5].ToString();
            this.textBox5.Text = dr[4].ToString()
        }
        dr.Close();
    
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message)
    }
    finally
    {
        DBConn.conn.Close();
    
}

实现效果：