I have an InfoPath web enabled form that gets published to a SharePoint site. I need to add a list box to the form that gets populated with data returned from an existing call to a SQL Stored Proc.
As the form works now, the user types in a patient id #, then clicks a button that calls the Stored Proc and returns any patients that match the given patient ID. This part works.
My task is to add a list box so that if more than one patient is returned , display the list box with all of these patients populated in it.
I am hoping to do this within the confines of the existing code. The existing code looks like this:
private bool LoadPatientInformationFromDB(string patientId, string patientFirstName,
string patientLastName, string patientMiddleInitial, string birthDate, string gender,
string admitDate, string location)
bool completed = false;
//Load from DB
SqlConnection conn = new SqlConnection(GetOrderSetDBConnectionString());
//Create Form Builder
formBuilder = new FormBuilder();
SqlDataAdapter adpt = null;
if (!String.IsNullOrEmpty(patientId) || !String.IsNullOrEmpty(patientFirstName) ||
!String.IsNullOrEmpty(patientLastName) || !String.IsNullOrEmpty(patientMiddleInitial)
View Complete Post