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