public DataTable getdatadoan() { kn.connect(); SqlDataAdapter da = new SqlDataAdapter("SELECT *FROM DOAN", kn.con); DataTable dt = new DataTable(); da.Fill(dt); return(dt); kn.disconnect(); }
public DataTable getdataNCP() { kn.connect(); SqlDataAdapter dt = new SqlDataAdapter("SELECT *FROM NGCUNGPHONG", kn.con); DataTable da = new DataTable(); dt.Fill(da); return(da); kn.disconnect(); }
private void QuanlyThe_Load(object sender, EventArgs e) { tv.connect(); string sql1 = "select*from The"; dgrQuanlythe.DataSource = tv.Taobang(sql1); tv.disconnect(); //hien thi ma sinh vien cmbMaSV.DataSource = CapMathe(); cmbMaSV.DisplayMember = "MaSV"; }
public DataTable getdatachitietdv() { kn.connect(); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM CHITIETSDDV", kn.con); DataTable dtp = new DataTable(); da.Fill(dtp); return(dtp); kn.disconnect(); }
//Lấy dữ liệu //public void connect() //{ // string cn = @"Data Source=THANH_HUYEN\SQLEXPRESS;Initial Catalog=PHONG_KHACHSAN;Integrated Security=True"; // try // { // con = new SqlConnection(cn); // con.Open(); // } // catch // { // MessageBox.Show("Khong the ket noi", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); // } //} //public void disconnect() //{ // con.Close(); // con.Dispose(); // con = null; //} public DataTable getdatap() { kn.connect(); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM PHONG", kn.con); DataTable dtp = new DataTable(); da.Fill(dtp); return(dtp); kn.disconnect(); }
private void QuanLyDocGia_Load(object sender, EventArgs e) { tv.connect(); string sql = "Select*from Docgia"; dgrQuanlydocgia.DataSource = tv.Taobang(sql); Xoa(); tv.disconnect(); }
public DataTable getdatahoadon() { kn.connect(); SqlDataAdapter hd = new SqlDataAdapter("SELECT *FROM HOADON ", kn.con); DataTable dt = new DataTable(); hd.Fill(dt); return(dt); kn.disconnect(); }
private void Thongke_Load(object sender, EventArgs e) { tv.connect(); string sql = "select * from Theloai"; cmbMatheloai.DataSource = tv.Taobang(sql); cmbMatheloai.DisplayMember = "MaTheLoai"; dgrThongke.DataSource = tv.Taobang("select * from Sach"); tv.disconnect(); }
public DataTable getdataP_thue() { kn.connect(); SqlDataAdapter p = new SqlDataAdapter("SELECT *FROM PHIEUTHUEPHONG", kn.con); DataTable dt = new DataTable(); p.Fill(dt); return(dt); kn.disconnect(); }
public DataTable getdatanv() { kn.connect(); SqlDataAdapter nv = new SqlDataAdapter("SELECT *FROM NHANVIEN", kn.con); DataTable dt = new DataTable(); nv.Fill(dt); return(dt); kn.disconnect(); }