Web Forms :: Trying To Populate The Value (s) Of A Listbox That Has Multiple Selections?

Jan 20, 2010

I am trying to populate the value(s) of a listbox that has multiple selections:

Assignment Preference:<br />

<asp:ListBox ID="assignmentPreferenceList" SelectionMode="Multiple" runat="server">

<asp:ListItem Value="">None</asp:ListItem>

<asp:ListItem Value="CONTRACTING">CONTRACTING</asp:ListItem>

<asp:ListItem Value="DIRECT HIRE">DIRECT HIRE</asp:ListItem>

<asp:ListItem Value="CONTRACTING-DIRECT HIRE">CONTRACTING-DIRECT HIRE</asp:ListItem>

</asp:ListBox>

I am using a datareader in code behind to "loop" through the values:

string sql4 = "Select * from assignmentPref where tID=" + (dr["id"].ToString());

SqlCommand comm4 = new SqlCommand(sql4, con3);

SqlDataReader dr4 = comm4.ExecuteReader();

while (dr4.Read())

{

assignmentPreferenceList.SelectedValue = (dr["assignmentPref"].ToString());

}
Works great with 1 assignment preference but with 2 or 3 it craps out.

View 7 Replies


Similar Messages:

SQL Server :: Listbox Multiple Selections In Sql Insert Form?

Nov 11, 2010

New at SQL and ASP.NET C#, bear with me. I have a form to insert into mulitple tables of a sql db. The form includes two listbox's, categoryIDlistbox and subcategoryIDlistbox, both with the ability to select multiple choices. Idea is that there is one record for the user created (Table1) and then that user can have multiple categories and subcategories assign to him/her in Table2

Table1:
userID
fname
lname
etc...

Table2
userID
categoryID
subcategoryID

If I understand correctly I need to use an array to take the multiple listbox items and save them to the tables. Not sure where the array goes in my code behind page to process the listbox and loop for muliplte selections. Here's my current code behind, where do I place the listbox array?

[Code]....

View 4 Replies

SQL Server :: How To Code To Populate Gridview With Multiple Random List Box Selections

Oct 11, 2010

I have a list box that allows for multiple selections (holding down the control key) the selection quantity is basically unlimited, but realistically should never be more than 50 to 100 items from the listing of about 3000 items.

I need to collect the list of selected items from the drop down list and retrieve each of their full records from the item master and populate a gridview.

View 3 Replies

SQL Server :: Finding Code To Populate Gridview With Multiple Random List Box Selections?

Oct 29, 2010

I have a list box that allows for multiple selections (holding down the control key) the selection quantity is basically unlimited, but realistically should never be more than 50 to 100 items from the listing of about 3000 items.

I could really use some building the SQL statement to select the choosen record data. I think I have the selection list worked out by populating an array but I am not clear on how to build the SQL query.

View 11 Replies

Retrieveing Multiple Values From Session To Populate ListBox?

Jan 9, 2011

I am trying to retrieve multiple values from the session variable in which I stored the values as List. Here's the code I applied but this gives me only the lst value from the list in the output.

Array k= yourlist.ToArray();
for (Int32 i = 0; i < k.Length; i++)
{
Int32 x = Convert.ToInt32(k.GetValue(i));
SqlCommand cmd2 = new SqlCommand("select id,name from plugins where id =" + x, con);
SqlDataReader dr2 = cmd2.ExecuteReader();
if (dr2.HasRows)
{
while (dr.Read())
{
ListBox2.DataSource = dr2;
ListBox2.DataBind();
}
}
dr2.Close();
cmd2.Dispose();
}

View 2 Replies

Web Forms :: Dropdown To Exclude Or Disable List Items Based On Listbox Selections?

Mar 12, 2010

I have a drop down that lists all our 40+ locations.. I then have a list box with all our locations as well. The client is presented with the question which locations have you worked at before. If they pick say 3 locations, i need to remove or disable those 3 from the drop down. I have other code for creating a drop down, but not sure where to go with this.

Here is my code for the controls and code behind:

[Code]....

View 17 Replies

Postback - ListBox Selections Not Working In Panel?

Apr 30, 2010

I'm having trouble processing a listbox after selecting some items from it. In my markup, the listbox is contained within an asp:panel and is populated during page load in the codebehind. That part works fine.

It's when I select various items and submit that I have trouble. My handler loops through the listbox items but doesn't see any as being selected. I'm not sure why.

Here's the markup:

<asp:Panel ID="panEdit" runat="server" Height="180px" Width="400px" CssClass="ModalWindow">
<table width="100%">
<asp:label runat = "server">Choose your items</asp:label>
tr>
<td>
<asp:ListBox ID="lstFundList" runat="server" SelectionMode="Multiple" OnLoad="lstFundList_LoadData">
</asp:ListBox>
</td>
</tr>
</table>
<asp:Button ID="btnUpdate" runat="server" Text="Update" OnClick="btnUpdate_OnClick"/>
<asp:Button ID="btnCancel" runat="server" Text="Cancel" OnClientClick="$find('ModalPopupExtender1').hide(); return false;" />
</asp:Panel>

In my btnUpdate_OnClick handler I can't see any listbox items that are marked as selected. I assume something strange is going on with respect to postback and the panel?

View 3 Replies

Web Forms :: Multiple Selections In DropDownList

Jan 23, 2013

how to do multiple selection in dropdownlist in asp.net

View 1 Replies

Web Forms :: How To Change Code To Multiple Selections

Jul 31, 2010

string lvStatus =
string.Empty;

if (ClbLeaveStatus.SelectedIndex == 0) [code]..

how to change this code to multiple selections

View 1 Replies

Web Forms :: List Box Multiple Selections Spacing

Apr 6, 2010

I have a web form that when completed sends an e-mail with the data from the form. I have a list box that permits muptiple selections and it post to the email with the following code.

sb.Append("<br />Products of Interest:....");
for(int i = 0; i < ListBox2.Items.Count;i++)
{
if(ListBox2.Items[i].Selected)
sb.Append(ListBox2.Items[i].Text);
}

It works fine except that when multiple tiems are selected, they run together on the form. Instead of "Beds Dressers Tables", I get "BedsDressersTables".

View 3 Replies

Forms Data Controls :: Gridview Selections To Populate Another Gridview Or Control With Selection From First

Feb 19, 2010

I currently have a gridview that has 1 column with radiobuttons. I then have a update button to update all the selected records. But what i want to do is add a step before the update. I want to add a multi-line textbox for each radiobutton selected to allow them to add notes/comments for each record before the update occurs.

Because the textbox will be large to allow them to enter the comments, i wanted to list them out seperately per record selected. Maybe a gridview is not what i need for the 2nd part, but thats the scenario and looking for suggestions on what / how to do it.

Example:

GRIDVIEW1

ID column1 column2 column3 radiocolumn
1 1111 2222 3333 Yes / No (selected Yes)
2 2222 3333 4444 Yes / No

GRIDVIEW2

ID NotesColumn
1 Texbox displays here

View 20 Replies

Web Forms :: How To Display CheckBoxes In DropDownList For Multiple Selections

Jun 20, 2013

How to display checkboxes in dropdownlist ?

Actually I want to select any checkbox(For selecting months) which is listed in dropdownlist? 

View 1 Replies

Forms Data Controls :: Inserting Multiple Selections Into A Table?

Feb 3, 2010

Using SQL Server 2008, C#, .Net 3.5

I have two tables - Reports, Usage

Report table:
RId
RName
RGroup

Usage table:
UId
UUser

What I want to do is make a page that will list all the reports in the Reports table and have a checkbox next to each name. A user can check each report they use and when they click "submit" it will insert each ReportID into the Usage table.I'm guessing that I should use a GridView to display all the Reports?How would I make it so that the "submit" button would insert each "checked" record into the Usage table?

View 8 Replies

Forms Data Controls :: How To Save Multiple Selections For One 1 Item?

Feb 20, 2011

I'm storing details about clothing in a database, and I need to save multiple entries for colour. For example, a user selects a top, and then needs to select the colours red, black, white and blue from say a group of tick boxes. How should I store this infomation, and what web controls would I use to help the user make there selection?

View 10 Replies

Web Forms :: Process Radio Buttons As 'group' Allowing For Multiple Selections?

Feb 25, 2011

the form has 15 items to choose with radio buttons, any number can be selected. I would like to process them as a 'group' so I can do something like loop thru them, checking if each one has been selected to build a list and also be saving them to a table row, etc but it seems all the designations as a list or group make it mutually exclusive. just looking for better coding than checking them with an if statement or similar so the question is if there is some way to designate the radio buttons as a group but no force the group to be mutually exclusive

View 4 Replies

C# - How To Get Multiple Selections From .NET CheckBoxs

Feb 1, 2011

This seems like it should be prettty easy - but I just can't get it to work!I have an enum in my model, which I want to display as a list of checkboxes. The user can select multiple checkboxes, and I want to save this in the database.

So the enum is like so (approx 20 elements unabridged):

public enum ReferrerType
{
[Description("No Data")]
NoData = 9999,[code]....

And it doesn't work! I guess I'm missing something obvious, but I can't work out what. There are no errors - just an empty database table where referrers should be.

View 2 Replies

JQuery UI Autocomplete For Multiple Key/value Selections In .NET?

Jul 27, 2010

How do I handle selection of multiple items with autocomplete? The objects I return from my JSON web service contain an ID and a Label - the ID is the ID of the entity in the database, and the Label is some text to display for the user.

At the moment, when I select an item in the autocomplete dropdown, the value of the item's ID is stored in a hidden field, and the label is displayed. When I remove the label, I clear the ID of the hidden field - this is done by adding an anchor element to the DOM that handles this.

Now, I want to have multiple selections. I want to be able to enter some text, get an autocomplete dropdown, select an item and some other options, then be able to click an 'Add New' button or the likes to be able to select another instance.

For example, I'd type in a person's name and get an autocomplete selection. I'd select a person, and then enter their age, and click 'Add'. The person's id, name, and age will be stored somewhere so that I can retrieve it on the server side when I post back.

I'm not quite sure how to do it? I'm thinking of a hidden field - I assume that many hidden fields of the same name/id turn up on the server side as an array, which I can then use. But I haven't tried this yet in ASP.NET.

View 1 Replies

Web Forms :: Populate Listbox From Dropdownlist Selection?

Jan 3, 2011

1) 1 dropdownlist - department

2)Search button

3) 1 listbox that will display all the staff according to the selection of its department

So when i select the department and click search button, the listbox will be populated with the staff names.

View 3 Replies

Web Forms :: Populate A Multicolumn Listbox From Excel?

Jul 25, 2010

I need to know how to populate a multicolumn ASP listbox on a Web

form using excel 2003 data . ( 2 columns in the Listbox )

When the user makes a selection from the Web listbox I want to

populate part of the web form, but I want to post the full form data to

another spreadsheet. ( NOT ACCESS)

View 2 Replies

Web Forms :: How To Populate A Listbox Programmatically From 1 Of 2 Tables

Nov 8, 2010

I need to populate a listbox programmatically from 1 of 2 tables, depending upon user inputs at run time and I need to know how many rows to read. Otherwise, I get an exception error when I try to read data that does not exist after all rows have been read.

View 5 Replies

AJAX :: Multiple Selections In A Dropdown Control ?

Jul 23, 2010

I have a requirement to allow users select multiple "Agencies" and populate the "Types" based on that selection. Cascading Drop down would have been a great fit if there is no mutliple selection involved. I am wondering if I could use a popup dropdown with chekcboxes. However, these checkboxes need to be populated dynamically by a web service. I am not very familiar with AJAX toolkit and what control would work best in this case.

View 1 Replies

AJAX :: Cascading Drop Down Based On Multiple Selections

May 14, 2010

Does anyone know if it is possible to have Cascading DropDown Lists which are based on the selected value of more than a single list. Example - I have four tables in a database as follows:

Product
PartA
PartB
PartC

The items in Product are made up by one record from each of the other three tables (PartA + PartB + PartC = Product). What I wish to do is have 3 Cascading DropDown lists which refer to the three individual parts which can be used to select items fromt he Product table.

The first two work no problem but when it comes to the third the list is condition on only items which have the selects of both the first two lists.

View 4 Replies

Using Checkbox In Template Column - Denying Multiple Selections?

Mar 11, 2011

I have the followingh scenario where I have a radgrid and inside it, I have a template column containing a check box:

[code]....

However, I only really want the user to be able to select one checkbox at a time.

Therefore, how to I go about ensuring that the any previous 'checks' are removed or stopping multiple checking altogether?

View 1 Replies

Forms Data Controls :: Populate ListBox From Stored Procedure?

Aug 11, 2010

I have a listbox which I need to populate with the results from a stored procedure. I have a class Ethics and I can call my stored proc there but I don't know how to populate the listBox from this point on. Here's what I have so far:

[Code]....

View 2 Replies

Web Forms :: WebParts - Populate Form Immediately After ListBox Binded?

Feb 3, 2010

The user has to select from the ListBox to populate the DataGrid control. However, the Default value in the ListBox does not cause the DataGrid to be populated. Why is this?

[Code]....

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved