public static DataTable GetDataSanPham() { try { DataTable dt = new DataTable(); string sql = "select MaSP,TenSP from SanPham "; conn = ConectToSQL_Datvd.Connect(); SqlDataAdapter da = new SqlDataAdapter(sql, conn); da.Fill(dt); conn.Close(); return(dt); } catch { conn.Close(); return(null); } }
public static DataTable GetData(string s) { try { DataTable dt = new DataTable(); string sql = "select s.TenSP,p.SoLuong,p.ChungLoai from PhieuXuatChiTiet p right join SanPham s on p.MaSP=s.MaSP where p.MaPX ='" + s + "'"; conn = ConectToSQL_Datvd.Connect(); SqlDataAdapter da = new SqlDataAdapter(sql, conn); da.Fill(dt); conn.Close(); return(dt); } catch { conn.Close(); return(null); } }
public static DataTable GetDataNhanVien() { try { DataTable dt = new DataTable(); string sql = "select MaNV,TenNV from NhanVien "; conn = ConectToSQL_Datvd.Connect(); SqlDataAdapter da = new SqlDataAdapter(sql, conn); da.Fill(dt); conn.Close(); return(dt); } catch { conn.Close(); return(null); } }
public static DataTable GetDataKhachHang() { try { DataTable dt = new DataTable(); string sql = " select MaKH,TenkH from KhachHang"; conn = ConectToSQL_Datvd.Connect(); SqlDataAdapter da = new SqlDataAdapter(sql, conn); da.Fill(dt); conn.Close(); return(dt); } catch { conn.Close(); return(null); } }
public static DataTable GetData() { try { DataTable dt = new DataTable(); string sql = " select a.MaPX,a.NgayXuat,a.TenNV,k.TenKH from KhachHang k right join (select p.MaPX,p.NgayXuat,n.TenNV,p.MaKH from PhieuXuat p left join NhanVien n on p.MaNV=n.MaNV) a on a.MaKH=k.MaKH"; conn = ConectToSQL_Datvd.Connect(); SqlDataAdapter da = new SqlDataAdapter(sql, conn); da.Fill(dt); conn.Close(); return(dt); } catch { conn.Close(); return(null); } }