private void 餐桌状态_Load(object sender, EventArgs e)
{
textBox1.Text = txt;
string roomid = this.textBox1.Text;
SqlConnection conn = new SqlConnection("Server=.;Integrated Security=true;Database=YKL");
conn.Open();
SqlCommand cmd = new SqlCommand("select*from table1 where RoomID='" + roomid + "'", conn);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
if (sdr["RoomID"].ToString() == textBox1.Text)//如果与条件相符就将记录显示到textbox2里
textBox2.Text = sdr["PeopleNum"].ToString();
}
sdr.Close();
sdr.Dispose();
cmd.Dispose();
}
textbox中显示数据库中内容
最新推荐文章于 2023-06-17 16:02:33 发布