ASP.NET

ASP.NET RSS

DropDownList only returns the 1st value regardless of selection

Please support our ASP.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: May 2008

Posts: 34

Reputation: ricksvoid is an unknown quantity at this point

Solved Threads: 0

ricksvoid

Offline

Light Poster

DropDownList only returns the 1st value regardless of selection

Oct 27th, 2009

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!

 Help with Code Tags 
 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

•

Join Date: Jun 2009

Posts: 439

Reputation: Ramesh S will become famous soon enough

Solved Threads: 82

Ramesh S

Online

Posting Pro in Training

Oct 28th, 2009

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

 Help with Code Tags 
 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.

•

Join Date: Dec 2007

Posts: 205

Reputation: carobee is an unknown quantity at this point

Solved Threads: 11

carobee

Offline

Posting Whiz in Training

Oct 28th, 2009

Have you specified

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
DropDownList1.DataTextField = "";
        DropDownList1.DataValueField="";
DropDownList1.DataTextField = "";
        DropDownList1.DataValueField="";

•

Join Date: May 2008

Posts: 34

Reputation: ricksvoid is an unknown quantity at this point

Solved Threads: 0

ricksvoid

Offline

Light Poster

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

Oct 28th, 2009

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

 Help with Code Tags 
 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