public System.Data.DataTable GetPatientByID(string PatientID) { string strSql = "select * from [Patient] where id=" + PatientID; try { DataSet ds = OLEDBHelper.Query(strSql); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(null); } } catch (Exception ex) { throw ex; return(null); } }
public DataTable GetPatientList() { string strSql = "select * from [Patient] "; try { DataSet ds = OLEDBHelper.Query(strSql); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(null); } } catch (Exception ex) { throw ex; return(null); } }