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
}