Click here to Skip to main content
16,012,821 members

Comments by anuradha.sardesai (Top 20 by date)

anuradha.sardesai 28-May-14 6:26am View    
Deleted
Also in your function I don't see a con.open line. Are you sure it's open?
anuradha.sardesai 28-May-14 6:22am View    
sorry @Member 10248768, all I can suggest is check if the data is there in the dataset. Shift the call of loadPatient in form load, pass a hardcoded value which you know works for sure
anuradha.sardesai 28-May-14 5:56am View    
If you try to debug, till where are you getting expected results? ANd at the query I mentioned above, add a breakpoint, check the value of SelectString and execute EXACTLY the same query on backend. See if you get any data back.
anuradha.sardesai 28-May-14 5:50am View    
Secondly, check if this query works on the backend directly,

"Select p.patient_id as patient_id,p.patient_dob as patient_dob,n.patient_first_name as patient_fname,n.patient_middle_name as patient_mname,n.patient_last_name as patient_lname,p.patient_sex as patient_sex,n.virology as virology,h.homenumber as homenumber,h.mobilenumber as mobilenumber,a.apartment_name as apartment_name,a.door_number as door_number,a.street_name_1 as street_name_1,a.Street_name_2 as Street_name_2,a.Street_name_3 as Street_name_3,a.village as village,a.city as city,a.state as state,a.country as country,a.apartment_number as apartment_number,a.pincode as pincode,o.doctor_first_name+' '+o.doctor_last_name+' '+o.doctor_middle_name as doctor_name from patient_id p,patient_name n,patient_contact h,address a,doctordetail o where n.patient_id=p.patient_id and a.patient_id=p.patient_id and p.patient_id=h.patient_id and p.patient_id=o.doctor_id and p.patient_id=@patientId"

If you patient_id is string / char field, it will have to be in a pair of quotes
anuradha.sardesai 28-May-14 5:47am View    
after this line
dPatientID = Convert.ToString(cboPatientID.SelectedValue);
are you getting correct value of dPatientID?