//查询语句 /* * public DataTable SelectYardid() * { * Start ioj = new Start(); * String iu = Start.CUser; * SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True"); * conn.Open(); * string sql = "select yARDID from Booking where book_personid='" + iu + "'"; * SqlCommand cmd = new SqlCommand(sql, conn); * SqlDataAdapter sda = new SqlDataAdapter(cmd); * DataTable dt = new DataTable(); * sda.Fill(dt); * conn.Close(); * cmd.Dispose(); * return dt; * * } */ private void Test_QX_Load(object sender, EventArgs e) { // TODO: 这行代码将数据加载到表“场馆预约系统DataSet17.Booking”中。您可以根据需要移动或删除它。 this.bookingTableAdapter.Fill(this.场馆预约系统DataSet17.Booking); //comboBox1.DataSource = SelectYardid();//绑定数据 //comboBox1.DisplayMember = "yARDID"; Start ll = new Start(); String LL = Start.CUser; List <Booking> user_list = new List <Booking>(); listView1.Items.Clear(); chloe_control_all chloe_obj = new chloe_control_all("Data Source=DESKTOP-O4C25KM;Initial Catalog=场馆预约系统;Integrated Security=True"); user_list = chloe_obj.person_search(LL); for (int i = 0; i < user_list.Count; i++) { ListViewItem user_item = new ListViewItem((i + 1).ToString(), i + 1); //user_item.SubItems.Add(user_list[i].UserName.ToString()); user_item.SubItems.Add(user_list[i].Book_personid.ToString()); user_item.SubItems.Add(user_list[i].Book_person.ToString()); user_item.SubItems.Add(user_list[i].yARDID.ToString()); user_item.SubItems.Add(user_list[i].OpenTime.ToString()); user_item.SubItems.Add(user_list[i].CloseTime.ToString()); user_item.SubItems.Add(user_list[i].BookDate.ToString()); user_item.SubItems.Add(user_list[i].REALDate.ToString()); user_item.SubItems.Add(user_list[i].Tel.ToString()); user_item.SubItems.Add(user_list[i].BookCondition.ToString()); listView1.Items.Add(user_item); } }