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 Maunder775.8K

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

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

Dropdown list in gridview

5 solutions

Solution 4

Solution 2

Solution 5

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us