Dropdown list in gridview

Question

1.00/5 (1 vote)

See more:

Hi,

I want to use dropdownlist inside gridview but I am unable to do this.
I am new in asp.net and I have bind gridview but there dropdownshowing blank and other column filled.

How can I do that?

My gridview binds like:

C#

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connectionstring"].ToString());
           SqlCommand cmd = new SqlCommand("select product_name,product_rate from product_detail", con);
           SqlDataAdapter da = new SqlDataAdapter(cmd);
           DataSet ds = new DataSet();
           da.Fill(ds, "product_detail");
           gridView1.DataSource = ds;
           gridView1.DataBind();

What is code use for dropdown list?
Above code filled product rate but I want select item from dropdownlist and then display rate for selected item.

aspx for gridview is

XML

<asp:GridView ID="gridView1" runat="server" AutoGenerateColumns="False" PageSize="10" AllowPaging="true">
                    <Columns>
                        <asp:TemplateField HeaderText="Product_Name">
                            <ItemTemplate>
                                <asp:DropDownList ID="DropDownList1" runat="server" DataValueField="product_id" DataTextField="product_name" Width="100px" OnSelectedIndexChanged="SelectedindexChanged">
                                </asp:DropDownList>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="Product_Rate">
                            <ItemTemplate>
                                <asp:Label ID="lblRate" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Product_Rate") %>'></asp:Label></ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>

Posted 12-Oct-10 20:15pm

call to .net

Updated 13-Oct-10 0:50am

Chris Maunder773.6K

v3

Add a Solution

Comments

Bikash Shrestha From Nepal 13-Oct-10 2:44am

the way you are trying to do is not worthy.Because, you are trying to populate products in a gridview then whats the need of using dropdownlist inside gridview.

gridview is itself meant for listing collection of records.i mean to say no dropwown is needed.

m@dhu 13-Oct-10 2:51am

Tried to update question but unable to do so.

Dalek Dave 13-Oct-10 4:36am

Edited for Grammar and Code Blocks.

5 solutions

Solution 1

XML

<asp:dropdownlist id="DropDownList1" runat="server" datavaluefield="product_id" datatextfield="product_name" width="100px" onselectedindexchanged="SelectedindexChanged" xmlns:asp="#unknown" />

you need to bind the DataSource of your dropdownlist.

C#

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connectionstring"].ToString());
                  SqlCommand cmd = new SqlCommand("select product_name,product_rate from product_detail", con);
                  SqlDataAdapter da = new SqlDataAdapter(cmd);
                  DataSet ds = new DataSet();
                  da.Fill(ds, "product_detail");
                  gridView1.DataSource = ds;
                  gridView1.DataBind();

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if(e.Row.RowType  == DataControlRowType.DataRow)
            {   
                  DropDownList DropDownList1 =  (DropDownList)e.Row.FindControl("DropDownList1");
                  SqlConnection con = new    SqlConnection(ConfigurationManager.AppSettings["connectionstring"].ToString());
                  SqlCommand cmd = new SqlCommand("select  product_name,product_rate from product_detail", con);
                  SqlDataAdapter da = new SqlDataAdapter(cmd);
                  DataSet ds = new DataSet();
                  da.Fill(ds, "product_detail");

                  //Bind the DataSource to Dropdown list
                  DropDownList1.DataSource = ds.Table[0];
                  DropDownList1.DataTextField="product_name";
                  DropDownList1.DataValueField ="product_id";
                  DropDownList1.DataBind();
            }
        }

If this helped you then please Vote and mark it as answer.

Posted 12-Oct-10 20:35pm

NMehta83

Updated 12-Oct-10 20:59pm

v2

Comments

call to .net 13-Oct-10 2:43am

where i have to bind dropdownlist above code i have written on page load.
when i have try to bind dropdownlist on pageload the intelligence not showing dropdownlist1

NMehta83 13-Oct-10 2:59am

I update the answer.

Solution 3

//You need DataBound event of the Grid View to bind Dropdown list
//First You have to put the DataSet in ViewState to be accessed in
//Row Bound Event

//So the Code will be like follows

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connectionstring"].ToString());
                  SqlCommand cmd = new SqlCommand("select product_name,product_rate from product_<code><code></code></code>detail", con);
                  SqlDataAdapter da = new SqlDataAdapter(cmd);
                  DataSet ds = new DataSet();
                  da.Fill(ds, "product_detail");
                  ViewState["ProductDetail"] = ds;
                  gridView1.DataSource = ds;
                  gridView1.DataBind();

//RowBound Event of Grid view
<pre>protected void gridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
            {
                try
                {

DropDownList drp = null;
GridViewRow grow = e.Row;
drp = (DropDownList) grow.findControl("DropDownList1");
if(drp!=null)
{
DataSet ds =(DataSet) ViewState["ProductDetail"];
 drp.DataSource = ds;
drp.DataBind();
}
                }
catch(Exception ex)
{}


}
}

Posted 12-Oct-10 20:55pm

MKAdeel

Updated 12-Oct-10 23:53pm

v2

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)

Bikash Shrestha From Nepal · Accepted Answer · 2010-10-12T21:24:00

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound">
            <Columns>
                <asp:TemplateField HeaderText="Products">
                <ItemTemplate>
                    <asp:DropDownList ID="DropDownList1" AppendDataBoundItems="true" DataTextField="Name" DataValueField="Price" AutoPostBack="true" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                    <asp:ListItem Text="--Select--" Value="">
                    </asp:ListItem>
                    </asp:DropDownList>
                </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Price">
                <ItemTemplate>
                    <asp:Label ID="lblPrice" runat="server" Text="Label"></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>

C#

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

   private void LoadGrid()
   {
       try
       {
           DataTable dt = new DataTable();
           DataColumn dc1 = new DataColumn("Product Name");
           DataColumn dc2 = new DataColumn("Price");

           dt.Columns.Add(dc1);
           dt.Columns.Add(dc2);

           DataRow dr = dt.NewRow();
           dt.Rows.Add(dr);

           GridView1.DataSource = dt;
           GridView1.DataBind();

       }
       catch (Exception)
       {
           throw;
       }

   }
   protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
   {
       if (e.Row.RowType == DataControlRowType.DataRow)
       {
           DataTable products = (DataTable)GetProducts();//GetProducts() is the Method to Get Products list
           DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList1");
           ddl.DataSource = products;
           ddl.DataBind();

           e.Row.Cells[1].Text = "";
       }



   }
   protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
   {
       DropDownList ddl = (DropDownList)GridView1.Rows[0].FindControl("DropDownList1");
       GridView1.Rows[0].Cells[1].Text = ddl.SelectedValue;
   }

m@dhu · Accepted Answer · 2010-10-12T20:45:00

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
       {
           //Handle the Gridview RowDatabound Event
           if(e.Row.RowType  == DataControlRowType.DataRow)
           { //Find the DropDownList inside the Rows
               DropDownList ddl=(DropDownList)e.Row.FindControl("DropDownList1");
               //Bind the Temporory Table we have Created
               ddl.DataSource=//datasource;
               //Set the Display value
               ddl.DataTextField="City";
               //Bind the values to DropDownList
               ddl.DataBind();

           }
       }

Bikash Shrestha From Nepal · Accepted Answer · 2010-10-15T09:50:00

hello Shivesh you can create getproducts methods as shown bwlow

C#

private DataTable getproducts()
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connectionstring"].ToString());
            SqlCommand cmd = new SqlCommand("select product_name,product_rate from product_detail", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "product_detail");
            return ds.Tables[0];
}

:-O :-O

Dropdown list in gridview

5 solutions

Solution 4

Solution 2

Solution 5

Solution 1

Solution 3

Add your solution here

Preview 0