how to access related columns in a dropdown list? In the example below I have a dropdown which is bound to a list of countries, I know how to access the text & value fields but how would I access data such as "Region"? I know I could do this by spinning through the list until CountryCode on the lsit and selected item match but wondered if there was a better way.
[Code]....
I would like to display students and their grades with a GridView and LinqToSQL like this:
[Code]....
I found this topic but it doesn't answer my question: http://forums.asp.net/t/1557987.aspx
I have a many-to-many relationship between students and assignments called "grades".The grade for the assignment is stored in that table in a "gradeNumber" column.The many-to-many relationship seems to be a problem.I tried adding a TemplateField to my grid:
[Code]....
It doesn't work:
...student does not contain a property with the name grade.
It does work when I use class.name however to get a student's class he is in.In code students .grade[0].something works however My LINQ entities are extended with custom code to allow me to retrieve studentx.Assignments or assignmentx.Students.(I would also like to specify which assignments should be displayed in the grid.)
I have an improvised system to enter data, below the gridview. I need to populate one dropdown only with the values which relate to the value selected in the drop down before that. For example. I have a dropdown for Customers and another for ShipTo. I want Shipto dropdown to populate only with the values which relate to the particular Customer selected.
[Code]....
I need to know how to loop through all the selected items of a listbox.
View 3 RepliesActually I and doing my college Project and I have some Problem.I have 3 sections in my web page:1. The Search Part, which search a product by its name or Id.2. Result Part, which is a grid view showing Product ID,Product name ,its stock and Price.3. Billing Part, where The bill will be created which contains Sr.no. ,Product Id, Product name, Qty,Price,Total Price as attributes.Now I want that if any one search the product then result is shown in result part and then from the list of the products i click a product and add it in the bill list.But I am not able to understand here how to access a data from the grid view i.e. accessing Product Id,Product name, Price and add it to bill.
View 5 RepliesHow to add Items in the Dropdown at the Runtime..?
View 2 RepliesI am getting this error: "Cannot have multiple Items Selected in Dropdown", when I Edit the data.
I want to loop thru dropdown list and check the individual list item text using C#, let me know what is the best way to do this?
View 4 RepliesI have a situation where some dropdown listboxes contain some items, then there's a separator line, and then there are more items. The ones above the separator line reflect the "commonly used items". To better highlight these I was using code like this to individually color those specfic items:
foreach (ListItem item in ddList.Items)
{
if (item.Value == "-1")
unAssigned = true;
if (!unAssigned)
item.Attributes.Add("style", "color:#5558ff");
}
This code works fine EXCEPT that once a PostBack occurs then the highlighting disappears. The items in the dropdown listbox remain (without repopulation) but not the highlighting.
I'm curious why this is happening and whether there's a way for the highlighting to "stick" short of calling this code from the Page_Load event handler every Postback?
I have a dropdown which i have binded code behind as:
protected void PriorityType()
{
DPriority.Items.Add(new ListItem("--Select--", "0"));
DPriority.Items.Add(new ListItem("High", "1"));
DPriority.Items.Add(new ListItem("Medium", "2"));
DPriority.Items.Add(new ListItem("Low", "3"));
}
It shows the items in gridview correctly but when i insert in database as DPriority.SelectedValue . it does not save the text but the index
Like if i choose High in database it saves as 1 but it should save as text not index.
i have the requirement that to set the 'Timetable' for school..
i need weekdays vertically and periodnames horizentally as headings in the gridveiw.. and with in the gridveiw the client can able get those many periods dynamically with in the dropdown....
i have over 100 items all loaded in a dropdown list. They all are assigned a value between 1-10 which represent 10 categories. When certain buttons are clicked, i want the dropdown list to display only items with a value "1" or "2", etc.
View 3 RepliesAfter I execute a data reader and put the readed string from the database in my dropdownlistbox, I cannot add another item in it.Here's my code:
con.Open()
Dim com As New OleDbCommand("Select Status from Table where Id = 'somevalue' ", con)
Dim dr As OleDbDataReader
[code]...
i have a dropdownlist for which i have items like red,blue,yellow,green...etc but these items default static color will be black for all items,
but my requirement is to Red as red color Blue as blue color Green as green color
[Code]....
Is it possible to display the items in a dropdown list not by the order of insertion?
i want to display the orders alphabetically.
I've noticed that page load time increases dramatically as you load up a ddlistbox with items. 10,000 or so results in a pretty much unacceptable wait time for my setup. The dropdown I'm trying to load is Airports - like all of them. What are some alternative UI solutions that give the user the ability to easily select any (literally) airport, but without a ginormous page loading time? (Currently the dd is keyed to the airport's 3 letter code, so it's convenient for the prepared user to just type the 3-letter code and have the right airport selected. The display is then set to code, city, country.)
View 7 RepliesI 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]....
I have a DropDownList inside the EditTemplateItem (if the user clicks edit) in a GridView.The DropDownList receives all available rows from the database. My problem is,if the user clicks Edit in the GridView to edit a row and opens the DropDownList Box the original item is not selected but the first one.That means the items are sorted. Have someone an idea how I can solve this issue that the right item / the original is selected if I change to edit mode of the grid view?
View 2 RepliesI have on server control(dropdown) and One button.user can select some values in dropdown and click button.I have to show a pop-up.In this pop-up I have show data based upon value selected in dropdown.How to access a dropdown in codebehind of pop-up screen.I am loading a .aspx in pop-up using javascript.
View 1 RepliesOn my website, registered users can make a profile about themselves suchas name, Favoirite color, hobbies, etcI have a DataTable called User which hold this information.also there are other datatables for Hobbies and Colors which list all possible options.To let the user update their choices I have a FormView in Edit mode on the aspx page whichis binded to the UserTable with a GetProfileByUserId Method and objectdatasource.
Within the formview, i have added drop down lists that are binded to the hobbies and Colors tables so they can edit their previous selection.On clicking Uodate update formview calls an Update Method that adds new selections to the User databaseNow I have two questionsIs it possible to show in the dropdown list the selected value that the User has already made?If the user only changes hobbies and not colors when they click update will a null value be passed into the data table for colors that replaces their previous selection?
i have two drop down list in web form..for both of them i've used following code to bind with sql..but whenever i'm trying to bind second drop down list with same method..it's giving error..
the code i've used:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlPropertyType.AppendDataBoundItems = true;
String strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
String strQuery = "select ID, PropertyName from PropertyType";
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
ddlPropertyType.DataSource = cmd.ExecuteReader();
ddlPropertyType.DataTextField = "PropertyName";
ddlPropertyType.DataValueField = "ID";
ddlPropertyType.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
}
I am running into some additional difficulties with dropdown lists, and I'm hoping you can correct my thinking.
I have a table populated with items; ITEM_ID, ITEM_NAME, ITEM_COST.
Here is my code:
[Code]....
With this code I get this error: DataBinding: 'ITEM' does not contain a property with the name '2'.
If I remove the assignment of DataSource to c1, the dropdown generates this error: 'DropDownList3' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value
How should I code this so that the user is presented with a list of ITEM_NAMES, and that the ITEM_ID is stored in the value field so I can use it when the selection event is fired? I know I could databind the source directly to the dropdown list, but I am trying to understand the behind the scenes working of a dropdown list object.
i have a class Parent in which i have a drop down list (ddlNames) it contains some name
i have another class Relatives form this class i want to append some more names to ddlNames
How can get my drop down menu sub items shown over the slider . The problem is shown in the image added
menu html
<ul id="menu">
<li class="vous"><a href="#">Acceuil</a></li>
<li class="nous"><a href="#">Votre Secteur</a></li>
<li class="actus"><a href="#" class="selected">Nos expertises</a></li>
[Code] ....
I have a dropdown list with four options like:
New Reviewed
To be Reviewed Presented
I need to display only specific items in the dropdown list based on some conditions.I mean sometimes with only 2 items
New Review Sometimes with 3 items
New Review To be Reviewed and sometimes all items.How can I do this? I am using C#.