How to set the selected value of dropdownlist inside gridview after postback?

Question

0.00/5 (No votes)

See more:

I have dropdown list inside item template of Gridview.
Dropdown list items are added dynamically at Girdview RowDataBound.
I used the command field Edit to update the selected value of dropdown list into database.Update process is fine. My problem is when user select the
value and click update, the selected value inside the dropdown list is lost and changed to first item of the list. I want to set the selected value of the dropdown list unless user update. Please somebody help me in how to set the selected value of dropdown list.

Thank you in advance. Looking for the help. :)

Posted 28-Mar-12 0:03am

Teddy Su

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

woopsydoozy · Answer 1 · 2012-03-28T08:15:00

Solution 1

Maybe you need to rebind the grid in the edit postback--after you've updated the dataset with the change?

Posted 28-Mar-12 8:15am

woopsydoozy

Chandan Aryan · Answer 2 · 2012-03-28T08:18:00

VB

private void SetPreviousData()
    {
        int rowindex = 0;
        if (ViewState["CurrentTable"] != null)
        {
            DataTable dt = (DataTable)ViewState["CurrentTable"];
            if (dt.Rows.Count > 0)
            {
               
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DropDownList ddl = (DropDownList)grdRoomDetails.Rows[rowindex].Cells[1].FindControl("ddlRoomCategory");
                    DropDownList ddlRoom = (DropDownList)grdRoomDetails.Rows[rowindex].Cells[2].FindControl("ddlRoom");
                    
                    //Againg binding the previous rows grid COntrols and Retaining their values
                    CategoryBLL obj = new CategoryBLL();
                    DataTable dt1 = new DataTable(); 
                    dt1 = obj.Show_Category();
                    ddl.DataSource = dt1;
                    ddl.DataTextField = "CategoryName";
                    ddl.DataValueField = "CategoryID";
                    ddl.DataBind();
                    ddl.Items.Insert(0, "--Select--");
                    ddl.Items[0].Value = "0";
                    ddl.SelectedValue = dt.Rows[rowindex]["RoomCategory"].ToString();

                    ReservationBLL objres = new ReservationBLL();
                    objres.CategoryID = Convert.ToInt32(ddl.SelectedValue);
                    ddlRoom.DataSource = objres.Show_Room();
                    ddlRoom.DataValueField = "RoomID";
                    ddlRoom.DataTextField = "RoomNo";
                    ddlRoom.DataBind();
                    ddlRoom.Items.Insert(0, "--Select--");
                    ddlRoom.Items[0].Value = "0";
                    ddlRoom.SelectedValue = dt.Rows[rowindex]["Room"].ToString();

                    rowindex++;
                }
            }

shreekar · Answer 3 · 2012-03-28T11:16:00

Solution 3

In your Gridview RowdataBound event, after you have added the items dynamically, find the selected value for that dropdown and set the selectedindex to that value.

[EDIT: Provided order of things to be executed]

In Gridview RowdataBound event pseudo code:

VB

'code to extract the selected value from the database/dataset/wherever
selectedvalue = getSelectedValue(Primary key) ' change as appropriate

'your code to fill the completed drop down
do while eof
  add the item to dropdown
  if item.value = selectedvalue then  
      item.selected=true ' set selection
  end if
loop

Posted 28-Mar-12 11:16am

shreekar

Updated 30-Mar-12 9:11am

v2

Comments

Teddy Su 29-Mar-12 0:07am

Dim li As ListItem = CType(ddlist.SelectedItem, ListItem)
ddllist.SelectedIndex = list.Items.IndexOf(li)

I tried the above code. But the Selected Item of dropdown list is showing the first item of the dropdown list. It doesn't know the user selected value.
I dont know how to get the user selected value form row databound. At SelectedIndex Changed event of dropdown , I can get the user selected value .
Thanks for your solution.

shreekar 30-Mar-12 15:07pm

I have updated the answer to show the changes