.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

DropDownList, SelectedValue, From Database

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net

I have a form, using a few DropDownLists.  The DropDownList pulls the list of items from a Table in the database. But, I would like it to select the value from the UserProfile Table, also in the database.  It populates correctly, but it is not selecting the value correctly.  The data from the UserProfile Table will be a string, not an ID column.

Here is the code I am using:



<asp:Label ID="lblSportName" runat="server" Text="Sport:"></asp:Label>
                    <asp:DropDownList ID="ddSportName" runat="server" DataSourceID="edsSports" DataTextField="SportName" DataValueField="SportID" Width="80%" ></asp:DropDownList>
                    <asp:EntityDataSource ID="edsSports" runat="server" 
                        ConnectionString="name=BFEntities" DefaultContainerName="BFEntities" 
                        EnableFlattening="False" EntitySetName="Sports" >


var query = (
                                                from c in context.aspnet_Users.OfType<UserProfile>()
                                                where c.UserId == _userGuid
                                                select c

View Complete Post

More Related Resource Links

Filling state dropdownlist according to country dropdownlist from database

Hello,I've been looking for an answer to this problem of mine but not yet able to get any solution.Please help me out. I'm having 2 dropdownlists, one for country and another for state.I want the states to be filled according to the country selected from the country ddl. I'm having:  Two dropdownlist controls as-ddlCountry and ddlState Two database tables as-Country and State Country table has fields named- C_ID(pk) and Country State table fields are-S_ID(pk), State, C_ID During page load, I'm able to bind the ddlCountry to the "Country" table in  databaseHence I could bind ddlState too  But I'm getting confused, how to bind the ddlState control so that it will show state as per country selected. I don't want to use ajax Please help me out. Thanks and Regards, Zinnia

Populating DropDownList from Database

Hi there,I'm really struggling with this tonight (this being exactly what it says on the tin, (or the subject!)).  Code I'm working with right now is:If Not Page.IsPostBack Then Dim Category As String Dim CategoryReader As OdbcDataReader = Database.Read("SELECT * FROM tblBlogCategory") While CategoryReader.Read() Category = CategoryReader("Category").ToString() End While DropDownList1.DataSource = Category DropDownList1.DataBind() End IfI've also tried things likeDropDownList1.DataSource = Database.Read("SELECT * FROM tblBlogCategory") but it just stubbornly refuses to populate the list (i.e. the pagealways loads with a blank drop down list).  An idea I'm playing around with is putting the values of the Category table into an array, but it seems to have a problem with that as well.  Hope someone can advise me and point me in the right direction.  Feel free to be critical of my code too.ThanksDouglas

DropDownList - .SelectedValue Not Changing



I have many dropdownlists in my application, and have never had a problem binding the data to them and setting the selectedvalue.  The ddl is in a DataGrid, and I look for the value in a label control and set the .SelectedValue to that.  I actually copied my code from a different page in my application that functions exactly the same way, except on the "original" page the .SelectedValue changes as expected.  On the "new" page I can see that the Value in the label control in the datagrid has the expected value, and as I step through the code everything is just fine until I hit the .SelectedValue = NewValue.  I can see that the current .SelectedValue is populated with the default value from the databinding, and that the NewValue has the new value I want, but after I step over that statement, the .SelectValue remains what it was as the default value.  So, here is the code:


Protected Sub dgWatchList_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs)

Dim ddlAuditor As System.Web.UI.WebControls.DropDownList
Dim AuditorID As Integer
If e.Item.DataSetIndex >= 0 Then

            AuditorID = CType(e.Item.FindControl("lblAuditor"), Label).Text
            ddlAuditor = e.Item.FindControl("ddlAuditor&

how to display the database value in to the Dropdownlist box


dynamically populating the database in the dropDownlist using c# in asp.net


hi everyone , plz listen my question very carefully

i have 2 tables  Desgn & EmpForm

Desgn table is lik this

CREATE TABLE [dbo].[Desgn](
    [DesignationCode] [int] IDENTITY(1,1) NOT NULL,
    [DesignationName] [varchar](50) NOT NULL,
    [DesignationCode] ASC

EmpForm table is like this

CREATE TABLE [dbo].[Empform](
    [EmpId] [varchar](50) NOT NULL,
    [EmpName] [varchar](50) NOT NULL,
    [EmpSalary] [numeric](18, 0) NULL,
    [EmpDesignationcode] [numeric](18, 0) NOT NULL,
    [EmpDateofBirth] [date] NOT NULL

now my ques is i want to dynamically populate the dropdown list of designation on the basis of the code but instead of code name should get populated .i have written the code like this 

public void Populate1()
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["co

'Dropdownlist' has a SelectedValue which is invalid because it does not exist in the list of items


I have a dropdown list that has a bind on it and I get this error. Why am I getting this error and what can I do to fix it. here is the code for the dropdown I currently have:


 <asp:DropDownList  ID="DDLPreferred" AppendDataBoundItems="true" SelectedValue='<%# Bind("PREFERRED_COMMUNICATION") %>'  runat="server" TabIndex="15">
                <asp:ListItem Text="none" Value=""></asp:ListItem>

				<asp:ListItem>Home Phone</asp:ListItem>
				<asp:ListItem>Work Phone</asp:ListItem>
				<asp:ListItem>Cell Phone</asp:ListItem>


DropDownList with CascadingDropDown no SelectedValue...?


Hi All,

I cannot get selected value from DropDownList in my codebehind, is there any possibility to get the value?

Below is which i am trying:

<asp:DropDownList id="DDL" AutoPostBack="False" runat="server">

 <cc1:CascadingDropDown ID="ccDD"

Here is my tow behind code and both are failed to get selected value.

'            With AjaxControlToolkit.CascadingDropDown
 Protected Sub FilterData()
        Dim frm As Control = Me.FindControl("searchbox").FindControl("ctl04") 'Form1 is the HTML
        For Each ctrl As Control In frm.Controls
            If TypeOf (CType(ctrl, Control)) Is AjaxControlToolkit.CascadingDropDown Then
                Dim ddl As AjaxControlToolkit.CascadingDr

Dropdownlist error: SelectedValue which is invalid because it does not exist in the list of items.


I have a dropdownlist in a detailsview edit Item template. Also I have two tables - Employee and Main. In the Employee table I have column EmpId and AssignedTo. In the main table I have EmpId which is connected to the Employee table. 

The detailsView has a label which shows the AssignedTo name for a particular record and it works fine. But if I click the edit button to shwo the dropdownlist in the editItemTemplate it is givig me the above error.

The code is:

<asp:DetailsView ID="dtvAssign" runat="server" AutoGenerateRows

how to create dropdownlist user control(acsx) and fill from database


how to create dropdownlist user control(acsx) and fill from database

DropDownList in DetailsView, invalid SelectedValue


I believe my question is not new here, but I think it is valuable because there are so many results from google with the 'dropdownlist in detailsview' as keywords.

Well, my question is described as below. (ASP.net and C#)

1)  I need a detailsview to add and edit record of table T1, which contains products information. T1 has a field 'catalog' which indicates the catalog of the product. All possible catalogs is stored in table T2. The simplified tables is described in 2)

2)  Simplified tables:

  • T1 fields: id, prodname,  catalog;  which is the datasource of the DetailsView.
  • T2 fields: id, catalog; which is the datasource of the dropdownlist in the detailsview.
  • all record of T1 have a catalog, which is picked up from T2.

3)  Functions I need are:

  • when detailsview in edit mode and insert mode, the field catalog should turns from a textbox to a dropdownlist which contains the catalogs stored in T2 .
  • when the item(catalog) of dropdownlist is selected and the 'update' button is clicked, the selected catalog (from T2) should replace the exist one of T1.

4)  My procedures to achieve the functions were:

  • drag and drop a detailsview control to a page, bind a datasource to it, en

DropDownList SelectedIndexChanged event not fired when programatically setting SelectedValue


In our asp.net web application we load the dropdown list boxes in the page load.  We than set the SelectedValue of each dropdown list box to an object from session.  We have event handlers for many of the SelectedIndexChanged events of the drop down lists boxes, but these do not get executed when we set the selected value programmatically.


Someone else mentioned this is by design, and only when a user manually changes the drop down list selected index, will the event get raised.


I would think this is a common scenario of wanting the selectedindexchanged event handled when setting the selectedvalue/selectedindex/listitem's selected property, of a DropDownList.  What is the suggested way to handle this?  Is there a significant drawback of creating a custom control inherited from DropDownList that has the functionality of raising this event when changing the SelectedIndex or SelectedValue?



dropdownlist selectedvalue


hi All,

What is the best way to set a selectedvalue if I am working with double types

How to set the value without having comma or decimal point issues?


How to bind the selectedvalue from asp.net dropdownlist to list



Sharepoint Designer 2007:

How can i bing data from asp.net contorl dropdownlist (selectedvalue) to list.

Thank you

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

jQuery: Styling DropDownList Alternating Items (Rows)

In the following example, I will show how you can style any asp:dropdownlist very easily.

The example demonstrates how you can change alternating row items background color, using the fadeTo() to add a nice touch in the dropdownlist. You can change alt rows with a couple lines.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend