110,502
社区成员
发帖
与我相关
我的任务
分享
private void comboBox1_TextChanged(object sender, EventArgs e)
{
SqlConnection sqlconn = new SqlConnection(MyInfo.conn);
SqlCommand cmd = new SqlCommand("select name,sex,birthday,sid from Patient where name like'" + comboBox1.Text.ToString().Trim() + "%'", sqlconn);
sqlconn.Open();
SqlDataReader read;
read = cmd.ExecuteReader();
while (read.Read())
{
comboBox1.Items.Add((string)read[0].ToString() + "," + (string)read[1] + "," + (string)read[2] + "," + (string)read[3]);
}
sqlconn.Close();