我想从名为PoliceAccount的表中获取当handle列等于下拉列表的值时,policeid和fullname两个字段,并将值放入标签中进行显示。然而,使用下方提供的代码,我只能得到最后一行policeid和fullname的结果。但是,我的表格中包含两个具有handle列等于下拉列表值的警务账户。请帮助解决问题。谢谢!
conn.Open();
sql = "Select policeid, fullname From PoliceAccount Where handle = '"+ ddlReportDateTime.SelectedValue +"'";
using (var cmd2 = new SqlCommand(sql, conn))
{
SqlDataReader dr;
dr = cmd2.ExecuteReader();
while (dr.Read())
{
String policeid = dr.GetString(0);
String fullname = dr.GetString(1);
String result = policeid + " " + fullname;
lblAssignTo.Text = result;
}
}
conn.Close();