public void Update() { DataTable dt = new DataTable("table1"); oracleConnection.Open(); string cmdStr = @"select * from borrow_info WHERE READER_ID='" + user.Id + "'"; OracleCommand command = new OracleCommand(cmdStr, oracleConnection); OracleDataAdapter adapter = new OracleDataAdapter(command); adapter.Fill(dt); adapter.Dispose(); oracleConnection.Close(); ltCus.Clear(); foreach (DataRow dataRow in dt.Rows) { ReturnUtil util = new ReturnUtil { Id = dataRow["BOOK_ID"].ToString(), Name = dataRow["BOOK_NAME"].ToString(), BorrowTime = dataRow["BORROW_TIME"].ToString(), Count = ltCus.Count + 1, ReturnTime = dataRow["RETURN_TIME"].ToString() }; ltCus.Add(util); } listView.ItemsSource = ltCus; }
private void listView_SelectionChanged(object sender, SelectionChangedEventArgs e) { button1.IsEnabled = true; button2.IsEnabled = true; util = (ReturnUtil)listView.SelectedItem; }