ASP.NET DropDownList Issue

Question

[...]
public DataSet ReturnPromoMagazinesDs()
{

    MySql.Data.MySqlClient.MySqlConnection mysqlConnection = new MySql.Data.MySqlClient.MySqlConnection(this.connectionString);

    MySql.Data.MySqlClient.MySqlCommand mysqlCommand = new MySql.Data.MySqlClient.MySqlCommand("SELECT id, magazine_name FROM `magazines`", mysqlConnection);

    MySql.Data.MySqlClient.MySqlDataAdapter mysqlAdaptor = new MySql.Data.MySqlClient.MySqlDataAdapter(mysqlCommand);

    DataSet ds = new DataSet();

    mysqlAdaptor.Fill(ds, "magazines");

    return ds;
}

[...]
protected void Page_Load(object sender, EventArgs e)
{
        DataSet ds = new DataSet();
        ds = coreObject.ReturnPromoMagazinesDs();

        DropDownList1.DataSource = ds;
        DropDownList1.DataTextField = ds.Tables["magazines"].Columns["magazine_name"].ColumnName;
        DropDownList1.DataValueField = ds.Tables["magazines"].Columns["id"].ColumnName;
        DropDownList1.DataBind();

}

[...]
<asp:dropdownlist id="DropDownList1" runat="server"></asp:dropdownlist>

The above code works ok, untill I'm fetching the DropDownList1.SelectedValue which is always 1 (the fist value from the table). Values in the table aren't the blame for this, and if I manually add items to the DropDownList, everything works fine. What can cause this?

IanT8 · Accepted Answer · 2009-09-07 10:57:36Z

2

Does it work properly when you wrap all of the code in the Page_Load method in the following:

if (!IsPostBack) { /* Code as in the original post */ }

answered Sep 7, 2009 at 10:57

IanT8

2,2172 gold badges25 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mark Redman · Accepted Answer · 2009-09-07 11:10:25Z

0

Not sure if something is getting lost in transalation but you could simplify the following lines, even if its doesnt fix the issue.

DropDownList1.DataTextField = "magazine_name";

DropDownList1.DataValueField = "id";

edited Sep 7, 2009 at 11:10

answered Sep 7, 2009 at 10:59

Mark Redman

24.6k20 gold badges100 silver badges152 bronze badges

1 Comment

EsiX Over a year ago

Both ways result in the same thing. Even if I use dropdown.datetextfiel = "myfield" and dropdown.datatextvaluefield = "id" before or after droptdownlist.datasource = ds;

Collectives™ on Stack Overflow

ASP.NET DropDownList Issue

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related