private void ultraBtnPRefresh_Click(object sender, EventArgs e)
{
dsPatient = new DataSet();
try
{
ultraTextPSearch.Text = "";
ultraDateTimePSearch.Value = "";
objHospitalDB = new HospitalDB();
Patient objPatient = new Patient(objHospitalDB);
PatientRow objPatientRow = new PatientRow();
dtPatient = objPatient.GetAllAsDataTable();
ultraGridPatient.DataSource = dtPatient;
/*SqlCommand cmd = objHospitalDB.CreateCommand("Select * from [Hospital].[dbo].[Patient]", false);
* SqlDataAdapter sda = new SqlDataAdapter();
* sda.SelectCommand = cmd;
* sda.Fill(dsPatient);
* ultraGridPatient.DataSource = dsPatient.Tables[0];*/
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
if (objHospitalDB != null)
{
objHospitalDB.Dispose();
}
}
}
private void frmPatientView_Load(object sender, EventArgs e)
{
objHospitalDB = new HospitalDB();
Patient objPatient = new Patient(objHospitalDB);
dtPatient = objPatient.GetAllAsDataTable();
ultraGridPatient.DataSource = dtPatient;
// con.Open();
/* SqlCommand cmd=objHospitalDB.CreateCommand( "SELECT * FROM Patient");
* SqlDataAdapter sdap = new SqlDataAdapter(cmd);
* dtPatient = new DataTable();
* sdap.Fill(dtPatient);
* ultraGridPatient.DataSource = dtPatient;*/
}