public DataTable Showhoso() { string sql = "SELECT manhanvien , hoten ,ngaysinh , gioitinh , maphongban FROM HOSO"; DataTable dt = new DataTable(); dt = xl.Gettable(sql); return(dt); }
public DataTable Shownphongban() { string sql = "SELECT *FROM PHONGBAN"; DataTable dt = new DataTable(); dt = xl.Gettable(sql); return(dt); }