Problem finding Selected Text from a drop-down list inside a gridview

Question

5.00/5 (1 vote)

See more:

Hi All...

I am using Dorp-down list in edit item template of grid-view, while updating it is not retreiving the selected-item of the drop-down list instead its retreiving the first list item of drop-down list.

following is the code for .aspx page:-

XML

<asp:TemplateField HeaderText="Status">
                           <EditItemTemplate>
                            <center>   <asp:DropDownList ID="ddlStatus" runat="server">

                                   <asp:ListItem>Dispached</asp:ListItem>
                                   <asp:ListItem>Delivered</asp:ListItem>
                                   <asp:ListItem >Pending</asp:ListItem>
                               </asp:DropDownList></center>
                           </EditItemTemplate>
                           <ItemTemplate>
                                <asp:Label ID="Label6" runat="server" Text='<%# Eval("OStatus") %>'  ForeColor="Red"></asp:Label>
                                </ItemTemplate>
                       </asp:TemplateField>

following is the code of aspx.cs for gridview_rowupdating:-

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
   {
       string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
       DropDownList ddlstatus = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlStatus");
       string sd = ddlstatus.Text;
       SqlCommand cmdUpdate = new SqlCommand("Update Orders set OStatus = '" + status.SelectedItem.Text + "' where OID='" + id + "'", con);
       cmdUpdate.ExecuteNonQuery();
       con.Close();
       GridView1.EditIndex = -1;
       databind();
   }

Posted 2-Feb-12 20:23pm

ujjwal uniyal

Add a Solution

8 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)

Tech Code Freak · Answer 1 · 2012-02-02T21:00:00

Solution 1

Replace

C#

ddlstatus.Text

with

C#

ddlstatus.SelectedValue

or

C#

ddlstatus.SelectedItem.ToString()

Posted 2-Feb-12 21:00pm

Tech Code Freak

Comments

ujjwal uniyal 3-Feb-12 3:23am

Have tried all three of them but still it's not retrieving the value selected instead it's retrieving the first list item

Vasim889 · Answer 2 · 2012-02-02T22:53:00

Solution 2

C#

ddlstatus.selecteditem.text
or
ddlstatus.selectedtext

Posted 2-Feb-12 22:53pm

Vasim889

sunil gurjar · Answer 3 · 2012-02-02T23:42:00

try this

C#

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 {
  GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
  string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
  string ddluserType = ((DropDownList)row.FindControl("ddlStatus")).SelectedValue;
  SqlCommand cmdUpdate = new SqlCommand("Update Orders set OStatus = '" + ddluserType + "' where OID='" + id + "'", con);
  cmdUpdate.ExecuteNonQuery();
  con.Close();
  GridView1.EditIndex = -1;
  databind();
 }

khan mohd faizan · Answer 4 · 2012-02-02T23:47:00

Solution 4

C#

for(int i=0;<gridview1.rows.count;i++)>
{
GridViewRow gvr=GridView1.Rows[i];
string strControl = gvr.FindControl("ddlStatus") as DropDownList;
string Value=strControl.SelectedItem.Text.ToString();
}

Posted 2-Feb-12 23:47pm

khan mohd faizan

Updated 3-Feb-12 2:49am

v3

Comments

ujjwal uniyal 3-Feb-12 6:15am

it's still retrieving the first list item of the dropdownlist not the selected item of the dropdownlist.

Anuja Pawar Indore 3-Feb-12 8:49am

Added pre tag

chetan virkar · Answer 5 · 2012-02-02T23:53:00

C#

// here You get Dropdown and gridview cell in which dropdown is present



DropDownList ddlStatus = (DropDownList)grdViewSIPSummary.Rows[rowIndex].Cells[2].FindControl("ddlStatus");


//Get Selected text
ddlStatus.SelectedItem.Text.ToString();

Cells[2] is important.
means at which cell number your dropdown is!
starting with zero.

khan mohd faizan · Answer 6 · 2012-02-03T00:27:00

Solution 7

make DropDownlist property AutoPostBack="True"

Posted 3-Feb-12 0:27am

khan mohd faizan

Updated 3-Feb-12 2:50am

v2

khan mohd faizan · Answer 7 · 2012-02-03T00:28:00

Solution 8

make DropDownlist property AutoPostBack="True"

try it definatly it will work

Posted 3-Feb-12 0:28am

khan mohd faizan

khan mohd faizan · Answer 8 · 2012-02-02T23:56:00

Solution 6

its not necessary to mention cell number to find the control of the gridview

Posted 2-Feb-12 23:56pm

khan mohd faizan

Problem finding Selected Text from a drop-down list inside a gridview

8 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 7

Solution 8

Solution 6

Add your solution here

Preview 0