How to populate a particular column n inForms c# appli from database......
View Complete Post
2 Questions. I am trying out Data Entities in VWD 2010 Express. I have a parent (Customers) and child (Orders) table. Customers table has FirstName, LastName and Email columns.
Q1. When I view/edit/insert an Order, it shows the customer's first name in dropdown list whereas I want the full name. How can this be done?
Q2. How can I change the default behavior of PK/FK relationship so that customer's Email is displayed instead of Name?
Any help will be much appreciated.
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)
I had an infopath form with few rich text field. When i copy some content from somewhere and paste in the richtext Box then while Printing the form I get Lot of Blank Spaces Infront of the rich text box.
I tried creating teh print view too but still i get bunch of empty pages printed before by richtext box control.
Is there a way we can remove those blank spaces.....
I am not able to find out what is going wrong here....
i m wanting to know if it is possible to pre populate content within a webpart so the user only has to add the web part to the page, and not make any configurations changes.
What i am trying to achieve is with the image web part and pre loading this with an image which is hyper linked to another of our systems
Could you let me know if this is possible and if so how i go about doing this.