Ad:

ASP.NET Discussion Thread
Marked Solved
Views: 925

Oct 27th, 2009

DropDownList only returns the 1st value regardless of selection

Expand Post »

Ive successfully managed to bind my DropDownList control to the membership.getAllUsers class. The problem is, no matter who i select from the list, it always returns the same value which is the first selection. Is this some kind of postback issue? Yikes!

ASP.NET Syntax (Toggle Plain Text)
 
Protected Sub fillDropList(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        DropList1.DataSource = Membership.GetAllUsers()
        DropList1.DataBind()
    End Sub
 
Protected Sub DropList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropList1.SelectedIndexChanged
        results.Text = DropList1.SelectedItem.ToString()
 
    End Sub
 
Protected Sub fillDropList(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        DropList1.DataSource = Membership.GetAllUsers()
        DropList1.DataBind()
    End Sub
    
Protected Sub DropList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropList1.SelectedIndexChanged
        results.Text = DropList1.SelectedItem.ToString()

    End Sub

Similar Threads

queue in C++
Problem Related Dropdownlist in Data Grid in ASP.NET
pass array by reference in C
Help with Creating Unique Numbers for a Lottery Simulation in Java
populating dropdownlist based on gridview selection in ASP.NET

ricksvoid

Reputation Points: 9

Solved Threads: 0

Light Poster

Offline

39 posts
since May 2008

Permalink

Oct 28th, 2009

Re: DropDownList only returns the 1st value regardless of selection

Your dropdownlist bound to datasource for every submit. It should not be.

You need to check IsPostBack property on load event before binding the DropDownList.

Change your code as below

ASP.NET Syntax (Toggle Plain Text)
Protected Sub fillDropList(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load        
If Not IsPostBack Then
   DropList1.DataSource = Membership.GetAllUsers()        
   DropList1.DataBind()    
End If
End Sub
Protected Sub fillDropList(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load        
If Not IsPostBack Then
   DropList1.DataSource = Membership.GetAllUsers()        
   DropList1.DataBind()    
End If
End Sub

Last edited by Ramesh S; Oct 28th, 2009 at 2:13 am.

Ramesh S

Reputation Points: 165

Solved Threads: 113

Posting Pro

Offline

580 posts
since Jun 2009

Permalink

Oct 28th, 2009

Re: DropDownList only returns the 1st value regardless of selection

Have you specified

ASP.NET Syntax (Toggle Plain Text)
DropDownList1.DataTextField = "";
        DropDownList1.DataValueField="";
DropDownList1.DataTextField = "";
        DropDownList1.DataValueField="";

carobee

Reputation Points: 10

Solved Threads: 12

Posting Whiz in Training

Offline

209 posts
since Dec 2007

Permalink

Oct 28th, 2009

Error inserting record. Incorrect syntax near the keyword 'WHERE'.

Ive tested the values for both gridView1 and dropList1 and they are exactly what I want them to be. Too bad I cant figure why the above error keeps popping up. Im no .net expert so im hoping this is just some kind of syntax or inconsistent dataType. Please help

ASP.NET Syntax (Toggle Plain Text)
Imports System.Security
Imports System.Data.SqlClient
Imports System.Web.Configuration
Imports System.Data
 
 
Partial Class admin
    Inherits System.Web.UI.Page
    Public connectPath As String = ConfigurationSettings.AppSettings("Maya")
 
 
    Protected Sub fillDropList(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not Page.IsPostBack Then
            DropList1.DataSource = Membership.GetAllUsers()
            DropList1.DataBind()
        End If
    End Sub
 
    Protected Sub DropList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropList1.SelectedIndexChanged
        Dim theUser2 As Integer = gridView1.SelectedDataKey.Value
        Dim con As New SqlConnection
        con.ConnectionString = connectPath
 
        'the customerID of the selected gridview row
 
 
        Dim setRep As New SqlCommand
        setRep.Connection = con
        setRep.CommandText = "INSERT INTO dbo.customers(rep)VALUES(@dropList1)WHERE rep='" & theUser2.ToString() & "'"
        setRep.Parameters.AddWithValue("@dropList1", DropList1.SelectedItem.ToString())
 
        Dim added As Integer = 0
        Try
            con.Open()
 
            added = setRep.ExecuteNonQuery()
 
            results.Text = added.ToString() & "record has been added!"
 
 
 
        Catch Err As Exception
            results.Text = "Error inserting record. "
            results.Text &= Err.Message
        Finally
            con.Close()
        End Try
 
 
    End Sub
 
 
End Class
 
Imports System.Security
Imports System.Data.SqlClient
Imports System.Web.Configuration
Imports System.Data


Partial Class admin
    Inherits System.Web.UI.Page
    Public connectPath As String = ConfigurationSettings.AppSettings("Maya")


    Protected Sub fillDropList(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not Page.IsPostBack Then
            DropList1.DataSource = Membership.GetAllUsers()
            DropList1.DataBind()
        End If
    End Sub

    Protected Sub DropList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropList1.SelectedIndexChanged
        Dim theUser2 As Integer = gridView1.SelectedDataKey.Value
        Dim con As New SqlConnection
        con.ConnectionString = connectPath

        'the customerID of the selected gridview row


        Dim setRep As New SqlCommand
        setRep.Connection = con
        setRep.CommandText = "INSERT INTO dbo.customers(rep)VALUES(@dropList1)WHERE rep='" & theUser2.ToString() & "'"
        setRep.Parameters.AddWithValue("@dropList1", DropList1.SelectedItem.ToString())

        Dim added As Integer = 0
        Try
            con.Open()

            added = setRep.ExecuteNonQuery()

            results.Text = added.ToString() & "record has been added!"



        Catch Err As Exception
            results.Text = "Error inserting record. "
            results.Text &= Err.Message
        Finally
            con.Close()
        End Try


    End Sub


End Class

ricksvoid

Reputation Points: 9

Solved Threads: 0

Light Poster

Offline

39 posts
since May 2008

Permalink

Oct 28th, 2009

Re: DropDownList only returns the 1st value regardless of selection

Solved!!!
Thank You. All is well now.

ricksvoid

Reputation Points: 9

Solved Threads: 0

Light Poster

Offline

39 posts
since May 2008

Permalink

Oct 28th, 2009

Re: DropDownList only returns the 1st value regardless of selection

Bind the Dropdown when not ispostback . Otherwise Dropdown rebinds on every postback

parmesh.a

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

1 posts
since Oct 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Opera most used version (besides latest)

Next Thread in ASP.NET Forum Timeline: how to get the header name for the datatable in C#

DaniWeb Message

Cancel Changes

User Name
Password