drop down list is not taking selected value

vishnu vardhan

12y11.3k.NET

Hello All,

I am working on some project there i have 2 drop down lists and one Textbox in Update panel1. here i am binding the Names of PG from database to dropdownlist1(DDPGNames) and binding the PG rooms to dropdownlist2(DDRoomNumber) based first dropdownlist (it's like Country and state thing) now if i select any Room number in 2nd Dropdownlist the room rent has to dispaly automatically in textbox. for this i am writing this code on DDRoomNumber SelectIndexChanged Event. but my problem is DDRoomNumber is not taking selected room Number (It is taking Only First Value) if i select any other room in dropdown list it's going first one only.

see here my code:

protected void DDRoomNumber_SelectedIndexChanged(object sender, EventArgs e)

{

txtRent.Enabled = true;

MySqlConnection Con = new MySqlConnection(MyConString);

MySqlCommand Cmd = Con.CreateCommand();

string S = "SELECT*FROM pg_room_list WHERE Room_Num ='" + DDRoomNumber.SelectedItem.Text + "' AND Room_PG_ID ='" + DDPGNames.SelectedValue + "';";

Cmd = new MySqlCommand(S, Con);

MySqlDataReader Dr;

Con.Open();

Dr = Cmd.ExecuteReader();

while (Dr.Read())

{

string SRoom_Rent = Dr.GetString("Room_Rent");

txtRent.Text = SRoom_Rent;

}

Con.Close();

}

Pls give me some solution.

Thanks

32 Replies

Know the answer? Post it — somebody with the same question will find it here.

vishnu vardhan12y ago
Ya Here my silly mistake

In Binding the RoomNumbers I wrote the code like this

DDRoomNumber.DataTextField = "Room_Num";
DDRoomNumber.DataValueField = "Room_PG_ID"; //Not Correct
DDRoomNumber.DataValueField = "Room_Num"; // Correct

Here my mistake is i am taking the DataValueField as Room_PG_ID this was wrong because i need to give the same value of Room_Num so i changed it into Room_Num. Now it's Working.

It's Just Commonsense previously i was not looking at this Bind_RoomNumbers. Just i was checking on SelectedIndexChenged Event only. Just before i sat down and observed all the code once so i got my silly mistake.

Thanks any way For your Replies and precious Time of you Guys.
Dorababu Meka12y ago
Oh ok cool what u mistake you have done, if you post the solution in future it can be referred to some one else if they have the same mistake
vishnu vardhan12y ago
Thanks for your reply sir, But i got it. it's a silly mistake.

Thanks Again
Dorababu Meka12y ago
Just came frm ofc I will check and let u knw
vishnu vardhan12y ago
Hello Dorababu,

Did You find anything sir?? pls i need it very badly. i don't know what i have done wrong in this because my code is correct only and the query also working but the dropdown list is not selecting selected value.

Thanks
vishnu vardhan12y ago
No it is foreignkey only the primary key is Room_ID is there in my table.

Ya i am facing problem on that DDRoomNumber_SelectIndexChanged event

When ever i will select any room number the value is going to first value only.

it's not taking selected value.

Thanks
Dorababu Meka12y ago
For which one you are facing problem? for this DDRoomNumber_SelectedIndexChanged. One thing I am confused as per your code is this statement

string S = "SELECT Room_Num,Room_PG_ID FROM pg_room_list WHERE Room_PG_ID='" + DDPGNames.SelectedValue + "';";

is Room_PG_ID foreignkey or primary key, if foreign key what is your primary key in this table
vishnu vardhan12y ago
now check sir

thanks
Dorababu Meka12y ago
Vishnu I can not see any file in that
vishnu vardhan12y ago
Sir Open that sln file. u can see the files in that

pls open it.

thanks
Dorababu Meka12y ago
Vishnu I couldn't see any files in the attachment except the solution file.
vishnu vardhan12y ago
i have attached code sir did u check it ??

Pls give me some solution

thanks
vishnu vardhan12y ago
Hello dorababu,

I have attached the code see and tell me any wrong is there

Thanks
Dorababu Meka12y ago
Can you attach the code what you have written in that page completely, just attach those files so that we can check and help you
vishnu vardhan12y ago
Hello Guys,
did anyone find anything ?? pls i need this. still i didn't get anything..

pls Can anyone give me the solution i am stuck on this from last one day...

thanks
vishnu vardhan12y ago
Ok,

Here my aspx code

Here my .aspx.cs code

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Bind_DDPGNames();
}
}

private void Bind_DDPGNames()
{
MySqlConnection Con = new MySqlConnection(MyConString);
MySqlCommand Cmd = Con.CreateCommand();
Con.Open();
string S = "SELECT PG_ID, PG_Name FROM pgs_list";
Cmd = new MySqlCommand(S, Con);
MySqlDataReader Dr;
Dr = Cmd.ExecuteReader();
DDPGNames.DataSource = Dr;
DDPGNames.Items.Clear();
DDPGNames.DataTextField = "PG_Name";
DDPGNames.DataValueField = "PG_ID";
DDPGNames.DataBind();
DDPGNames.Items.Insert(0, new ListItem("-SELECT-", "0"));
Con.Close();
}
private void Bind_DDRoomNumbers()
{
MySqlConnection Con = new MySqlConnection(MyConString);
MySqlCommand Cmd = Con.CreateCommand();
Con.Open();
string S = "SELECT Room_Num,Room_PG_ID FROM pg_room_list WHERE Room_PG_ID='"+DDPGNames.SelectedValue+"';";
Cmd = new MySqlCommand(S, Con);
MySqlDataReader Dr;
Dr = Cmd.ExecuteReader();
DDRoomNumber.DataSource = Dr;
DDRoomNumber.Items.Clear();
DDRoomNumber.DataTextField = "Room_Num";
DDRoomNumber.DataValueField = "Room_PG_ID";
DDRoomNumber.DataBind();
DDRoomNumber.Items.Insert(0, new ListItem("-SELECT-","0"));
Con.Close();
}

protected void DDPGNames_SelectedIndexChanged(object sender, EventArgs e)
{
DDRoomNumber.Enabled = true;
Bind_DDRoomNumbers();
}

protected void DDRoomNumber_SelectedIndexChanged(object sender, EventArgs e)
{
MySqlConnection Con = new MySqlConnection(MyConString);
MySqlCommand Cmd = Con.CreateCommand();
Con.Open();
string S = "SELECT*FROM pg_room_list WHERE Room_Num =" + DDRoomNumber.SelectedItem.Text + " AND Room_PG_ID =" + DDPGNames.SelectedValue + ";";
Cmd = new MySqlCommand(S, Con);
MySqlDataReader Dr;
Dr = Cmd.ExecuteReader();
while (Dr.Read())
{
string SRoom_Rent = Dr.GetString("Room_Rent");
txtRent.Text = SRoom_Rent;
lblDisplay.Text = DDRoomNumber.SelectedItem.Text;
}
Con.Close();
}

Thanks
Srikanth Reddy12y ago
can you send the full application if you dont mind....i will try
vishnu vardhan12y ago
Hello Srikanth Reddy, it's no use.

my problem is with second drop down list it's not taking the selected value. if i select any value then it's automatically going to the 1st value...

Thanks
Srikanth Reddy12y ago
bind values to the second dropdown list in page load......
vishnu vardhan12y ago
hello Lakshmanan sethu,

i don't know how to debug the programs in VS 2012 can u just tell me how to do it?

thanks
vishnu vardhan12y ago
ya the auto post back is also true but dropdown list is not taking selected value....
vishnu vardhan12y ago
ya sure see here my page_load code..

Check

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Bind_DDPGNames();
}
}

Thanks
vishnu vardhan12y ago
this only i did there but DDPGNames(Dropdownlist1) is selecting the selected value but the second DDRoomNumbers(DropDownlist2) is not taking selected value.
Jignesh Trivedi12y ago
hi,
It might be value of drop down may reset on page load....
because before this event of drop down called page load event is fired...
can you please share your page load code?
Srikanth Reddy12y ago
Hii

The Code of munesh sharma is right and put "auto post back" of dropdown list is "true"...........
Lakshmanan Sethu Sankaranarayan12y ago
Hi, Did you try debugging the values that always first choice is coming or its overwriting somewhere?
Munesh Sharma12y ago
you do like this

Click on drop down list in write this code
{
    string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=123;";
    SqlConnection con = new SqlConnection(str);
    string query = "select * from tablename where name = '"+dropdownlist.text+"' ";
    SqlCommand cmd = new SqlCommand( query,con);
    sqldatareader dbr;
    try
    {
        con.open();
        dbr = cmd.executereader();
        while(dbr.read())
        {
            string sID = (string) dbr["ID"].tostring;
            string sname = (string) dbr["name"] // name is string value
            string sage = (string) dbr["age"].tostring;
            textbox1.text = sid;
            textbox2.text = sname;
            textbox3.text = sage;


        }
        catch(execption es)
        {
           messagebox.show(es.message);
        }
    }
}
vishnu vardhan12y ago
hello Munesh Sharma still i didn't get my solution can u pls check once ?

see here i am using those drop down lists in Update Panel so is something i have to do ? like triggers?

pls can any one know the solution?

Thanks
vishnu vardhan12y ago
ya i know that but see here if select any room number then automatically the rent should displayed in textbox. as i posted in first post with that code i getting rent in textbox automatically for first number only. again if i select any room number again Dropdownlist2 (DDRoomNumber) not taking the room number.
Munesh Sharma12y ago
go on this link http://www.c-sharpcorner.com/UploadFile/Dorababu742/cascading-dropdown-list-in-Asp-Net-using-entity-framework/
vishnu vardhan12y ago
thanks for reply but i already tried that one it's not working..
Munesh Sharma12y ago
you just write

"+DDRoomNumber.Selectedvalue+"