private void ucHoaDonNhap_Load(object sender, EventArgs e) { String query = "select MAHDN from HOADONNHAP"; DataTable tbl = db.DocDuLieu(query); cboMAHDN.DataSource = tbl; cboMAHDN.DisplayMember = "MAHDN"; cboMAHDN.ValueMember = "MAHDN"; }
private void frmThemHDB_Load(object sender, EventArgs e) { String queryNV = "select TENNV from NHANVIEN"; DataTable tblNV = db.DocDuLieu(queryNV); AutoCompleteStringCollection autoNV = new AutoCompleteStringCollection(); foreach (DataRow row in tblNV.Rows) { autoNV.Add(row["TENNV"].ToString()); } txtnv.AutoCompleteSource = AutoCompleteSource.CustomSource; txtnv.AutoCompleteMode = AutoCompleteMode.SuggestAppend; txtnv.AutoCompleteCustomSource = autoNV; nmrsoluong.Enabled = false; nmrgiamgia.Enabled = false; DataTable tblLuu = db.DocDuLieu("Select * from HOADONBAN"); string str = "HDB" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString(); txtmahdb.Text = td.SinhMaTuDong("HOADONBAN", str, "MAHDB"); }