{RESOLVED} Dropdownlist in C# (ASP.NET)

[Wen Lie]

:wave:
Hello...

I'm a bit confuse about the dropdownlist usage in C#.
I've created a dropdownlist object (name = DDlist) and a command button object (name = cmdButton).

And I've written below code in the .aspx.cs.

public partial class Test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string s_Conn = "server=myServer; user id=myID; password =myPwd; database=myDatabase";
string s_Query = "select login from pwdps order by login asc";
System.Data.SqlClient.SqlConnection myCn = new System.Data.SqlClient.SqlConnection(s_Conn);
System.Data.SqlClient.SqlCommand myCmd = new System.Data.SqlClient.SqlCommand(s_Query, myCn);

myCn.Open();
myCmd.CommandType = CommandType.Text;

System.Data.SqlClient.SqlDataReader myDR = myCmd.ExecuteReader();

DDlist.DataSource = myDR;
DDlist.DataValueField = "login";
DDlist.DataBind();
}

protected void cmdButton_Click(object sender, EventArgs e)
{
Response.Write("Hello " + DDlist.SelectedItem.Text);
}
}


Each time I choose an item from that dropdownlist, and press a command button, I wish the text of selected item can be written.
But, the result is not the same with what I've expected.

The code (at cmdButton_Click) always return the first item of the dropdownlist.

e.g :
the list of DDlist contain :
-Andi
-Budi
-Charles
-Natasha

even I choose Charles, the code will return "Hello Andi".

Do I miss some codes here ?

Thanks
** Willy **

[nemaroller]

Yes, you missed something - but its not entirely the first time someone has done it, and of course its the simplest of things.

You are rebinding the dropdownlist on every post-back - so of course it will always show the first item.

You want to wrap that code in a:

protected void Page_Load(object sender, EventArgs e)
{
if (! IsPostBack)
{
string s_Conn = "server=myServer; user id=myID; password =myPwd; database=myDatabase";
string s_Query = "select login from pwdps order by login asc";
System.Data.SqlClient.SqlConnection myCn = new System.Data.SqlClient.SqlConnection(s_Conn);
System.Data.SqlClient.SqlCommand myCmd = new System.Data.SqlClient.SqlCommand(s_Query, myCn);

myCn.Open();
myCmd.CommandType = CommandType.Text;

System.Data.SqlClient.SqlDataReader myDR = myCmd.ExecuteReader();

DDlist.DataSource = myDR;
DDlist.DataValueField = "login";
DDlist.DataBind();
}
}

[Wen Lie]

wooohoooo..
Thanks Nemaroller ...
it helps and works
^_^