public void createTable_HOADON() { string sql = "select * from HOADON"; ada_HOADON = conn.getDataAdapter(sql, "HOADON"); primaryKeyHD[0] = conn.Dset.Tables["HOADON"].Columns["MAHD"]; conn.Dset.Tables["HOADON"].PrimaryKey = primaryKeyHD; }
public void createTable_TAIKHOAN() { // tao 1 table tren Dataset string strSQL = "SELECT * FROM TAIKHOAN"; ada_TAIKHOAN = conn.getDataAdapter(strSQL, "TAIKHOAN"); primaryKey[0] = conn.Dset.Tables["TAIKHOAN"].Columns["ID"]; conn.Dset.Tables["TAIKHOAN"].PrimaryKey = primaryKey;// thiet lap khoa chinh cho ID }
public void createTable_CTNhap() { // tao 1 table tren Dataset string strSQL = "select * from CHITIETNHAP"; ada_ChiTietNhap = conn.getDataAdapter(strSQL, "CHITIETNHAP"); primaryKeys2[0] = conn.Dset.Tables["CHITIETNHAP"].Columns["MAPN"]; primaryKeys2[1] = conn.Dset.Tables["CHITIETNHAP"].Columns["MAVT"]; conn.Dset.Tables["CHITIETNHAP"].PrimaryKey = primaryKeys2;// thiet lap khoa chinh cho bang chi tiết phiếu nhập }
public void createTable_NHAVIEN() { // tao 1 table tren Dataset string strSQL = "SELECT * FROM NHANVIEN"; ada_NhanVien = conn.getDataAdapter(strSQL, "NHANVIEN"); primaryKey[0] = conn.Dset.Tables["NHANVIEN"].Columns["MANV"]; conn.Dset.Tables["NHANVIEN"].PrimaryKey = primaryKey;// thiet lap khoa chinh cho bang nhà cung cấp }
public void createTable_KhachHang() { // tao 1 table tren Dataset string strSQL = "SELECT * FROM KHACHHANG"; ada_KH = conn.getDataAdapter(strSQL, "KHACHHANG"); primaryKey[0] = conn.Dset.Tables["KHACHHANG"].Columns["MAKH"]; conn.Dset.Tables["KHACHHANG"].PrimaryKey = primaryKey;// thiet lap khoa chinh cho bang vat tu }
public void createTable_LoaiVatTu() { // tao 1 table tren Dataset string strSQL = "SELECT * FROM LOAIVT"; ada_LoaiVT = conn.getDataAdapter(strSQL, "LOAIVT"); primaryKey[0] = conn.Dset.Tables["LOAIVT"].Columns["MALOAI"]; conn.Dset.Tables["LOAIVT"].PrimaryKey = primaryKey;// thiet lap khoa chinh cho bang loai vat tu }
public void createTable_VatTu() { // tao 1 table tren Dataset string strSQL = "SELECT * FROM VATTU"; ada_VatTu = conn.getDataAdapter(strSQL, "VATTU"); primaryKey[0] = conn.Dset.Tables["VATTU"].Columns["MAVT"]; conn.Dset.Tables["VATTU"].PrimaryKey = primaryKey;// thiet lap khoa chinh cho bang vat tu }