Newbie Questions

Re: Programmatically populate a Drop-Down List Box

elizas — Mon, 22 Mar 2010 13:43:56 GMT

1. From ServerSide (In c#) To change ListBox to DropDownList just change the Rows property of the ListBox with “1” Then it will behave as the Dropdown list in UI. → ListBox1.Rows = 1; For the reverse Add → DropDownList1.Attributes.Add("size", "3"); 2. In ClientSide (By Javascript) DropDownList & Listbox Both rendered as select in the browser differentiate in their size property. So to change the UI of DropDownList to ListBox just change this property function ToggleView() { document.getElementById('ListBox1').size = 1; // This will Change from listBox to Dropdown List. document.getElementById('DropDownList1').size = 3;// This will Change from Dropdown List to listBox. } A small may be useful idea can be: Save the page space by showing the options in a DropDownList & on mousover change it to listbox & again on mouseout do the reverse. Here is the sample code Option 1 Option 2 Option 3 http://www.mindfiresolutions.com/Change-the-UI-of-ListBox-and-DropDownList-on-the-fly-853.php

Re: Programmatically populate a Drop-Down List Box

Shiva — Thu, 02 Oct 2008 06:16:10 GMT

Hello,

We can pass the parameters to stored procedure using code as below,

SqlCommand sqlCommand = new SqlCommand("Stroed Procedure Name", sqlConnection);

sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;

sqlCommand.Parameters.Add(sqlParameter);

Re: Programmatically populate a Drop-Down List Box

MonkeyCMonkeyDo — Wed, 28 Nov 2007 22:44:19 GMT

Clay,

My data connection is working properly because I can use the same stored proc with different parameters to fill textboxes.

Everything I am doing is behind in code...I'm using ADO.NET (C#) a sqlDataReader to read in the data.

I would use the InfoPath UI to set the values of the dropdown, but I need it to be dynamic as possible, and I don't want to hard-code the parameters in the 'edit sql' of the data connection. If there is a way to pass a value from the form to the 'edit sql' in the data connection wizard that would solve my problem.

Thank you for the response Clay...you're awesome!!

Re: Programmatically populate a Drop-Down List Box

Clay Fox — Wed, 28 Nov 2007 22:23:12 GMT

First step would be to verify your data connection is performing properly.

Are you setting up your Data Connection in InfoPath or doing it behind in code?

In the InfoPath UI you would just det the dropdown to use the secondary data connection. You would need to requery oviously to get the data updated as you needed.

I have not configured a drop down control in code.

Programmatically populate a Drop-Down List Box

MonkeyCMonkeyDo — Wed, 28 Nov 2007 17:32:19 GMT

Hello,

I am trying to populate a Drop-Down List Box with values I receive from an ADO.NET connection behind InfoPath. I am hitting a Stored Proc with 4 parameters and will received back a list of numbers, I would like those number to populate my Drop-Down List Box. Depending on what view I'm at those parameters will change and so will the list of numbers. Any advice would be far beyond appreciated at this point!

Thank you:)