private void DataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow dr = dataGridView1.CurrentRow; if (dr != null) { dr.Selected = true; txtMaBan.Text = dr.Cells[0].Value.ToString(); numSucChua.Value = decimal.Parse(dr.Cells[1].Value.ToString()); if (dr.Cells[2].Value.ToString() == "Đang Sử Dụng") { btSua.Enabled = btXoa.Enabled = false; } else { btSua.Enabled = btXoa.Enabled = true; } dataGridView2.DataSource = Ban.Ctdb(txtMaBan.Text); dataGridView2.Columns[0].HeaderText = "Tên"; dataGridView2.Columns[1].HeaderText = "Số Điện Thoại"; dataGridView2.Columns[2].HeaderText = "Thời Gian"; dataGridView2.Columns[3].HeaderText = "Số Người"; btThem.Enabled = false; } }
public void TestCtdb() { string maban = "1"; DataSet dsHienThi = new DataSet(); string l = "select * from DatBan where MaBan = " + maban; strcon.Open(); OleDbDataAdapter daShowData = new OleDbDataAdapter(l, strcon); daShowData.Fill(dsHienThi); daShowData.Dispose(); strcon.Close(); int expected = dsHienThi.Tables[0].Rows.Count; int actual = Ban.Ctdb(maban).Rows.Count; Assert.AreEqual(expected, actual); }