VS 2005 [RESOLVED] Binding Drop Down List

nolim8ts · Nov 25th, 2009, 12:43 AM

Hi All,

I currently have two dropdown lists which are bound to a SQL DataSource. The two controls have the following properties set:

AppendDataBoundItems = True
AutoPostBack = False
CausesValidation = True

When a Button Click Event fires, the dropdown lists default to the first value in the SQL DataSource.

I've removed the DataBinding and manually added items and upon clicking a button, the value originally selected in the dropdown list remains as is.

Below is the code I am using to bind one of the drop down lists.

VB Code:

Protected Sub BindAuthorityDDL()

        Me.ddlAuthority.Items.Clear()

        Try

            Using da As New SqlDataAdapter("SELECT Activity, TimeUnit FROM tblATU WHERE FieldName = 'ddlAuthority' ORDER BY Activity ASC", ConfigurationManager.ConnectionStrings("DEEstimatorConnectionString").ToString())

                Dim dt As New DataTable
                da.Fill(dt)
                da.Dispose()
                Me.ddlAuthority.DataSource = dt
                Me.ddlAuthority.DataTextField = "Activity"
                Me.ddlAuthority.DataValueField = "TimeUnit"
                Me.ddlAuthority.DataBind()

            End Using

        Catch ex As Exception

        End Try

    End Sub

VB Code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        If Not Page.IsPostBack Then

            BindAuthorityDDL()

        End If

    End Sub

gep13 · Nov 25th, 2009, 01:44 AM

Hey,

I take it the question that you have is that you want the currently selected item in the list to remain after a postback, when you bind it to the DataSource, is that correct?

You imply that, but it is not clearly stated.

Gary

nolim8ts · Nov 25th, 2009, 01:54 AM

Quote:

Originally Posted by gep13

Hey,

I take it the question that you have is that you want the currently selected item in the list to remain after a postback, when you bind it to the DataSource, is that correct?

You imply that, but it is not clearly stated.

Gary

Hi Gary,

That would be correct.

gep13 · Nov 25th, 2009, 02:13 AM

Hey,

With the exception of the querying of the database, I have done exactly the same thing in the following:

Code:

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            BindDLL()
        End If
    End Sub

    Private Sub BindDLL()
        Dim list As New List(Of String)
        list.Add("First")
        list.Add("Second")
        list.Add("Third")
        list.Add("Fourth")
        list.Add("Fifth")
        DropDownList1.DataSource = list
        DropDownList1.DataBind()
    End Sub

Code:

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm3.aspx.vb" Inherits="VBWebApplication.WebForm3" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True" CausesValidation="True">
        </asp:DropDownList>
        <asp:Button ID="Button1" runat="server" Text="Button" />
    </div>
    </form>
</body>
</html>

For sake of curiousity, can you create a new page, with just the above?

Does it work?

Gary

nolim8ts · Nov 25th, 2009, 02:34 AM

Hi Gary,

I created a new .ASPX page and copied your code which resulted in the effect that I'm after.

I then changed it to bind to a SQL DataSource and the same thing is happening.

gep13 · Nov 25th, 2009, 02:54 AM

Hey,

I have just checked an application where I have done a similar thing, and it looks like I have to manually set the SelectedValue of the DropDownList to the currently selected value on subsequent postbacks to the server. This was achieved by putting the selected value of the Drop Down List into a session variable.

What I don't know off the top of my head though is whether this was a "workaround" for me not being able to find a better solution, or whether it was the only way of achieving it.

Gary

nolim8ts · Nov 25th, 2009, 03:09 AM

Hi Gary,

After further investigation, I worked out why the Post Back is defaulting to the first item in the drop down list.

Looking at the Selected Index for the 5 Data Bound Items, there index goes as follows:

0,1,2,0,0

Why this is happening when the Data Bind occurs I have no idea.

gep13 · Nov 25th, 2009, 03:17 AM

Hey,

Does that mean that if you select the second or the third item in the DDL that it is retained after post back, but if you select the fourth and the fifth options, you get the first item. Is that right?

Can you show the result of your query that you are executing?

Gary

nolim8ts · Nov 25th, 2009, 03:23 AM

Quote:

Originally Posted by gep13

Hey,

Does that mean that if you select the second or the third item in the DDL that it is retained after post back, but if you select the fourth and the fifth options, you get the first item. Is that right?

Gary

Hi Gary,

That is correct...

What do you mean by "Can you show the result of your query that you are executing?"

gep13 · Nov 25th, 2009, 03:25 AM

Hey,

Can you execute the following query against SQL Server:

Code:

SELECT Activity, TimeUnit FROM tblATU WHERE FieldName = 'ddlAuthority' ORDER BY Activity ASC

And show the results that you get?

Gary

nolim8ts · Nov 25th, 2009, 03:36 AM

ACTIVITY TIMEUNIT

Better to Administer 90
Election 25
Grant on Probate 35
Letter to Administer Will Annexed 90
No Grant AAPA 90

gep13 · Nov 25th, 2009, 03:38 AM

Hey,

So there is your answer.

90 is the same value for 1, 4 and 5, which equates to the 0's that you are seeing.

Normally, you want to make the "value" of the DDL items unique, as this is what is used to distinguish it from another item in the DDL.

Gary

nolim8ts · Nov 25th, 2009, 03:44 AM

If there anyway of overcoming this as some items will have the same value?

gep13 · Nov 25th, 2009, 03:48 AM

Hey,

Not that I am aware of. Why would the entries have the same value?!?

Surely they would have to have a different value, otherwise, why are they available for selection in multiple places?!?

Gary

nolim8ts · Nov 25th, 2009, 04:06 AM

Hi Gary,

There are different types of activities to select from but some of those activities have the same value. This could change in the future.

gep13 · Nov 25th, 2009, 04:57 AM

Hey,

What does the value represent though?

Gary

mendhak · Nov 25th, 2009, 02:27 PM

You need to introduce an ATUID in your tblATU table which is unique and use that as the value in your dropdownlist. When a user selects a value, look at it and use it to get the time value out from the database.

nolim8ts · Nov 26th, 2009, 12:08 AM

Quote:

Originally Posted by mendhak

You need to introduce an ATUID in your tblATU table which is unique and use that as the value in your dropdownlist. When a user selects a value, look at it and use it to get the time value out from the database.

Worked as suggested...

gep13 · Nov 26th, 2009, 02:09 AM

Hey,

Glad to hear that you got it worked out.

Can you remember to go back and mark your thread as resolved (there are links in my signature if you are unsure), helps keep the place tidy.

Gary

Nov 25th, 2009, 01:44 AM	#2
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, I take it the question that you have is that you want the currently selected item in the list to remain after a postback, when you bind it to the DataSource, is that correct? You imply that, but it is not clearly stated. Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Nov 25th, 2009, 02:13 AM	#4
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, With the exception of the querying of the database, I have done exactly the same thing in the following: Code: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then BindDLL() End If End Sub Private Sub BindDLL() Dim list As New List(Of String) list.Add("First") list.Add("Second") list.Add("Third") list.Add("Fourth") list.Add("Fifth") DropDownList1.DataSource = list DropDownList1.DataBind() End Sub Code: <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm3.aspx.vb" Inherits="VBWebApplication.WebForm3" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True" CausesValidation="True"> </asp:DropDownList> <asp:Button ID="Button1" runat="server" Text="Button" /> </div> </form> </body> </html> For sake of curiousity, can you create a new page, with just the above? Does it work? Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Nov 25th, 2009, 02:34 AM	#5
nolim8ts Lively Member Join Date: Jan 06 Posts: 111	Re: Binding Drop Down List Hi Gary, I created a new .ASPX page and copied your code which resulted in the effect that I'm after. I then changed it to bind to a SQL DataSource and the same thing is happening.

Nov 25th, 2009, 02:54 AM	#6
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, I have just checked an application where I have done a similar thing, and it looks like I have to manually set the SelectedValue of the DropDownList to the currently selected value on subsequent postbacks to the server. This was achieved by putting the selected value of the Drop Down List into a session variable. What I don't know off the top of my head though is whether this was a "workaround" for me not being able to find a better solution, or whether it was the only way of achieving it. Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Nov 25th, 2009, 03:09 AM	#7
nolim8ts Lively Member Join Date: Jan 06 Posts: 111	Re: Binding Drop Down List Hi Gary, After further investigation, I worked out why the Post Back is defaulting to the first item in the drop down list. Looking at the Selected Index for the 5 Data Bound Items, there index goes as follows: 0,1,2,0,0 Why this is happening when the Data Bind occurs I have no idea.

Nov 25th, 2009, 03:17 AM	#8
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, Does that mean that if you select the second or the third item in the DDL that it is retained after post back, but if you select the fourth and the fifth options, you get the first item. Is that right? Can you show the result of your query that you are executing? Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Nov 25th, 2009, 03:25 AM	#10
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, Can you execute the following query against SQL Server: Code: SELECT Activity, TimeUnit FROM tblATU WHERE FieldName = 'ddlAuthority' ORDER BY Activity ASC And show the results that you get? Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Nov 25th, 2009, 03:36 AM	#11
nolim8ts Lively Member Join Date: Jan 06 Posts: 111	Re: Binding Drop Down List ACTIVITY TIMEUNIT Better to Administer 90 Election 25 Grant on Probate 35 Letter to Administer Will Annexed 90 No Grant AAPA 90

Nov 25th, 2009, 03:38 AM	#12
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, So there is your answer. 90 is the same value for 1, 4 and 5, which equates to the 0's that you are seeing. Normally, you want to make the "value" of the DDL items unique, as this is what is used to distinguish it from another item in the DDL. Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Nov 25th, 2009, 03:44 AM	#13
nolim8ts Lively Member Join Date: Jan 06 Posts: 111	Re: Binding Drop Down List If there anyway of overcoming this as some items will have the same value?

Nov 25th, 2009, 03:48 AM	#14
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, Not that I am aware of. Why would the entries have the same value?!? Surely they would have to have a different value, otherwise, why are they available for selection in multiple places?!? Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Nov 25th, 2009, 04:06 AM	#15
nolim8ts Lively Member Join Date: Jan 06 Posts: 111	Re: Binding Drop Down List Hi Gary, There are different types of activities to select from but some of those activities have the same value. This could change in the future.

Nov 25th, 2009, 04:57 AM	#16
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, What does the value represent though? Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Nov 25th, 2009, 02:27 PM	#17
mendhak ASP.NET Moderator Join Date: Feb 02 Location: Ulaan Baator GooGoo: Frog Posts: 37,382	Re: Binding Drop Down List You need to introduce an ATUID in your tblATU table which is unique and use that as the value in your dropdownlist. When a user selects a value, look at it and use it to get the time value out from the database. __________________ Mendhak.com\|MVP\|Flickr\|Mactards!\|

Nov 26th, 2009, 02:09 AM	#19
gep13 ASP.Nut Join Date: Nov 04 Location: The Granite City Posts: 9,868	Re: Binding Drop Down List Hey, Glad to hear that you got it worked out. Can you remember to go back and mark your thread as resolved (there are links in my signature if you are unsure), helps keep the place tidy. Gary __________________ Remember to mark your thread as resolved. Check out the new Forum features, including tagging here. Remember to rate posts that help. Check out my site - ASP.Net Website running on CentOS 5.3 with Mono Free Stuff: Microsoft WebsiteSpark\|Microsoft DreamSpark Learning Resources: MSDN\|LearnVisualStudio\|TrainingSpot\|ScottGu's Blog\|ASP.Net Starter Kits\|Regex\|RegExLib Useful Tools: XPath Builder\|UltraMon\|RegExBuddy\|CopySourceAsHtml\|TracExplorer\|SQLyog\|Chart Controls for .Net\|SharePoint Designer\|CodeRush Express Coding Links: XPath\|ConnectionStrings\|VB and MySQL\|MySQL Connector.Net\|My.Settings ADO.Net: MSDN Reference\|Introduction\|Using Access\|Always use Parameters\|Save and Retrieve Data - jm\|An Explanation - jm Code Bank Submissions: Code Snippets\|Profile Provider\|Serialization: C# VB\|Restricted Menu\|Compressed HttpWebRequest

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode