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();
}