I am having trouble listing two columns from a SQL database into a DDL. I dont want to concatenate them but just want to list them down as a list in the DDL.Here is the code for the DDL which currently is concatenating the two fields:
<asp:DropDownList ID="DropDownList10" runat="server"
DataSourceID="SqlDataSource3" DataTextField="Vendor_Name"
DataValueField="Vendor_Name"
[code]...
I have drop down list box that I would like to show two columns, is this possible? Or can it be done with a list box?The query correctly retrieves all of the table data to be displayed, one colum is an abbreviation, the other a bit longer description.
View 2 Repliesadding data from more than one columns of a table in drop down list but not concatening them.
Like a table having columns Station_1 , Station_2 , Station_3. All these columns having place names.
Now I want to list the distinct station/place names from each columns Station_1, Station_2 and Station_3 in my drop down list.
How to do this I serched everywhere in but not found the solution..
Is there any good solution to maintain listing conditions such as page#, search text when navigates from list -> edit -> list ?
When goes to edit it just pass id as below and lost whole listing condition.
<%= Html.ActionLink("Edit", "Edit", new { id = id })%>
I have a drop down list that has the initials of about 12 of our sales guys.How can I make it so that when they select their initials from the list, the next drop down list only shows their customers.In my database there is a column for customer name and salesman.
View 6 RepliesHow can I have 2 Cascading Drop Down Lists for the same Drop Down List?here is my problemi have 3 drop down lists read from database1- Schools List 2- Classes List3- Teachers ListEvery School will have more than 1 Class and more than 1 TeacherWhat I want is when user select a School from Schools Drop Down List then BOTH (Classes and Teachers) should be refreshed based on the School Drop Down List
View 1 RepliesI have the following Students class:
[Code]....
I need the 1 since it's a foreign key in another table. For the life of me, I can't get this to work like this.
I have a requirement in my application that, while saving the application, need to get all the value from drop down list and pass it to the view model. But application should not allow the user to select more than one item from drop down list manually, ie, only one value at a time. My view model is like ...
public class ListManagement
{
public IEnumerable<selectListItem> InactiveProduct { get; set; }
public string[] InactiveProductSelected { get; set; }
public IEnumerable<selectListItem> ActiveProduct { get; set; }
}
[code]...
I am getting this error yet I know it to be untrue.This is the code:
ddlPartnerOrganisation.DataSource = agency.AgencyGetListOfEYDN();
string temp = ddlPartnerOrganisation.SelectedValue.ToString();
ddlPartnerOrganisation.DataValueField = "AgencyID"
;
ddlPartnerOrganisation.DataTextField = "AgencyName"
;
ddlPartnerOrganisation.DataBind();
I have two drop down list on a page. The first one list projects and the second list users. The userlist is populated with an object datasourse that pulls a list of users for the selected Project.Whenever the Project list selection changes the second ddl Userlist always reverts to the first person in the list instead the person that was selected before a new Project was chosen.
View 1 RepliesI am trying to create an MVC List View that can be filtered by the value selected from a drop down list.
Selecting a value should repost the page ... Since there is no concept of view state data I am having some issues with this ... I can get the repost to take place but my drop down resets and I am not able to get the value that was selected.
ASSET CONTROLLER:
[Code]....
[Code]....
I have tried many of the posts that refer to setting up drop down lists but can't set them up in the content because this is a List View.
I have a drop down list box that I would like to show two columns, is this possible? Or can it be done with a list box?
The query correctly retrieves all of the table data to be displayed, one colum is an abbreviation, the other a bit longer description.
BLDGRNDS | Building and Grounds
MAINT | Facility Maintenance
etc.
I also need to acquire the results of the first column when a row is selected for updating the database.
I have a Drop Down List which I need to bind to the database. Here is the situation. I am not using a SQLDataSource. It is built on the n-tier application. The datasource of the dropdown is referring to a method in the C#class. That method has a generic array list which populates information into the arraylist. The Arraylist is the parameter that is returned to the DropDown List.
I have also set the Text property of the Drop down list
Text='<%DataBinder.Eval(Container.DataItem,"Employee_ID")%>'>
However, it is not populating the DropDown list, what should I do?
I retrieved values from database to drop down ,how can i make them as sortable.
View 5 RepliesI want to make a button that changes the value in a dropdown list (dropdown populated from SQLdatasource)This sounds strange i know but i have 4 dropdowns each hidden by panels, unless the preceeding dropdown's value is changed from it's initial value. So i make a selection from my first dropdown list & a postback occurrs triggering the next panel (and as such
the dropdown list) to become visible, this occurs again until eventually my users will see 4 drop down boxes...(all required field vals etc)
I am trying to write a web page where i have to select an item form a drop down list.
I am using linq to sql to get the data from the database.the strange thing is that i can register the data to the drop down list but when i select one of them the drop down list lets me to the first item. I set post back = true because i want to update the page every time an item get selected. I wrote a really simple code to check what was going wrong but still...no success. Below i am bringing the code i wrote.
.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication7.WebForm1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[Code]....
I have combined my SQL result to display in drop down list in such manner:
" SAV 123-423-231 "
" CUR 234-234-212"
User selects which account to view. So if the user selects SAV 123-423-231, I have to pass in the bank account number. How do I do that?
By split? I tried doing this:
ddlAcc.text.split(" ")
i'm getting an error. .js files are not present in my application folder. am i need to copy those .js files to my applikation folder?
View 7 RepliesIam working on a web based form where I have a DDL to which I have attached a field validator which is not working. It should function in such a way that whenever the DDL is left to blank, it gives user an error. I have introduced that BLANK in the DDL using ListItem as I found that as the easisest way out.
<asp:DropDownList ID="DropDownList4" runat="server"
DataSourceID="AccessDataSource4" DataTextField="myState"
DataValueField="myState" AppendDataBoundItems="true">
<asp:ListItem Selected = "True" Text = "" Value = ""></asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="reqState" runat="server"
ErrorMessage="RequiredFieldValidator" Text="Required Field"
InitialValue="None" ControlToValidate="DropDownList4" Display="Dynamic">
</asp:RequiredFieldValidator>
How can I make the first item in a drop down list non selectable. I want this first list-item to show up when the page is opened and want to populate the rest of the DDL from a backend DB. I don't want this default first item in the list to be selected (just want to show it as a default value)
I want it to look something like this.
Choose a State: (Appearing on the top of DDL, but cant be selected)
TX
IL
NY
FL
i am using SQL table to cascading 3 drop down list. this is search fields for cars by manifacture, model and year. the 2 first ddl has autopostback and AppendDataBoundItems (true) i want the user will select the facture first, then the 2th ddl will display the models of that manifacture and then the year. for the first time its working good, but when i change the manifacture for the second time, in the model i have the new values + the old values, and go on and on, if i select diffrent facture the model ddl have now values of 3 diffrent manifacture,
[Code]....
In my web application, their is a drop down list item that contains arround 5000 items, and becuase of this the viewstate grows upto 160 to 180 kb and my sever reponses a viewstate error...
View 5 RepliesI want to get a additional information (Other than DataTextField, DataValueField) in a drop-down list for each record.
how i can get this functionality?
I'm trying to use a drop down menu and button to link to a site. You click the selection you want from the drop down list and then click the button which will take you to that section.
I need to know the method that will allow me to change the address of the website.
I have just got the login control working, and would like to grab the currently logged in username (I'm guessing via the loginname control), and then have the Drop Down list on the default.aspx select the matching name. The names don't exactly match so, I could hard code compare them via a select case or if statement, but the problem is I don't how to get the logged in username into a variable, and I don't know how to have the drop down list (which is databound) select the record.
View 4 Replies
