how to set datasource to dropdownlist in gridview at page load in asp.net

Question

4.00/5 (1 vote)

See more:

i am have a grid with 2 column Sno and Deptname
and in the deptname column i am having dropdownlist.
how to give datasource to that dropdownlist in Page_Load

i tried like this but it gives error

source code:

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
           <Columns>
               <asp:TemplateField HeaderText="Sno">
                   <ItemTemplate>
                       <asp:Label ID="Label2" runat="server" Text='<%# Bind("Sno") %>'></asp:Label>
                   </ItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="DeptName" >
                   <HeaderTemplate >
                   <asp:DropDownList ID="dd"  runat="server" AutoPostBack="true"
                           DataTextField="DeptName" AppendDataBoundItems="true"
                           onselectedindexchanged="dd_SelectedIndexChanged" >
                   <asp:ListItem>Select</asp:ListItem>
                   </asp:DropDownList>

                   </HeaderTemplate>
                   <ItemTemplate >
                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("DeptName") %>'></asp:Label>
                   </ItemTemplate>
               </asp:TemplateField>
           </Columns>
       </asp:GridView>

cs code:

C#

protected void Page_Load(object sender, EventArgs e)
   {
            con = new SqlConnection(@"Data Source=PC026328\SQLEXPRESS;Initial Catalog=gan;Integrated Security=True");
          SqlDataAdapter da = new SqlDataAdapter("select deptname from department", con);
          DataSet ds = new DataSet();
          da.Fill(ds);
//error line
<dropdownlist ddl="(DropDownList)gridView1.HeaderRow.FindControl("dd");">
ddl.DataSource = ds.Tables[0];
 }</dropdownlist>

help me..!

Posted 11-Nov-11 3:17am

ganesan2510

Updated 11-Nov-11 3:37am

Not Active

v3

Add a Solution

6 solutions

Add a Solution

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

GG123 · Answer 1 · 2011-11-11T05:10:00

I usually do inline binding for such nested ddls inside GridView/ListView.

XML

<asp:GridView ID="gv1" runat="server" GridLines="None">
<Columns>
.....
<asp:TemplateField>
<li>
    <asp:DropDownList ID="ddl1" runat="server" SelectedValue='<%#Bind("mg1") %>' DataTextField="p_option" DataValueField="p_right_id" DataSourceID="SqlDataSource1">
    </asp:DropDownList>
</li>
</asp:TemplateField>
....
....
</GridView>


<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
        SelectCommand="My_SP" SelectCommandType="StoredProcedure">
    </asp:SqlDataSource>

shashikanth 2011 · Answer 2 · 2011-11-11T03:37:00

Solution 1

How can you give the data to DropDown list as its not yet created,
The DropDownList inside the GridView will be created after the Event RowCreated fires,as RowCreated Event fires after the Page_Load event,you cant do this in Page_Load(),
You have to do this in

C#

public void GridView1_OnRowDataBound(object sender, GridViewRowEventArgs e)
{}

Posted 11-Nov-11 3:37am

shashikanth 2011

Updated 13-Nov-11 2:47am

v4

Comments

Member 10850583 28-Aug-14 17:24pm

What if I am calling a function on page load which needs to reference something inside but it's not created until after rowcreated function? What do I do than?

ganesan2510 · Answer 3 · 2011-11-13T20:06:00

at last i got the answer and thanks for ur consideration.. :)

C#

protected void MPCproject_RowDataBound(object sender, GridViewRowEventArgs e)
         {
             try
             {

                 if (e.Row.RowType == DataControlRowType.Header)
                 {
                     DropDownList ddl = (DropDownList)e.Row.FindControl("ddlSorting");
                     SqlDataAdapter da = new SqlDataAdapter("select deptname from department", con);
                     DataSet ds = new DataSet();
                     da.Fill(ds);
                     ddl.DataSource = ds.Tables[0];
                     ddl.DataTextField = "Projectype";
                     ddl.DataValueField = "Projectype";
                     ddl.DataBind();
                 }
             }
             catch (Exception ex)
             {
                             }

         }

koolprasad2003 · Answer 4 · 2011-11-13T20:17:00

You need fill dropdownlist with data source. use RowDataBound event

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
         {
                 if (e.Row.RowType == DataControlRowType.Header)
                 {
                     DropDownList dropDownLst = (DropDownList)e.Row.FindControl("dd");
                     SqlDataAdapter da = new SqlDataAdapter("select deptname from department", con);
                     DataSet objDS = new DataSet();
                     da.Fill(objDS);
                     dropDownLst.DataSource = objDS .Tables[0];
                     dropDownLst.DataTextField = "deptname";
                     dropDownLst.DataValueField = "deptname";
                     dropDownLst.DataBind();
                 };
        }

Remove DataTextField, AppendDataBoundItems, onSelectedIndexChanged from ASPX page

moneymakermaster · Answer 5 · 2011-11-13T02:37:00

Solution 3

you can do this in code behind only after rowcreated, so you cannot do this in page load.

Posted 13-Nov-11 2:37am

moneymakermaster

Comments

ganesan2510 13-Nov-11 12:56pm

how to call dropdownlist in code behind after row created?
please explain little more..

uk_sid · Answer 6 · 2012-09-11T01:32:00

Solution 6

how to set datasource to dropdownlist in gridview at page load from another table in asp.net c#

Posted 11-Sep-12 1:32am

uk_sid

how to set datasource to dropdownlist in gridview at page load in asp.net

6 solutions

Solution 2

Solution 1

Solution 4

Solution 5

Solution 3

Solution 6

Add your solution here

Preview 0

how to set datasource to dropdownlist in gridview at page load in asp.net

6 solutions

Solution 2

Solution 1

Solution 4

Solution 5

Solution 3

Solution 6

Add your solution here

Preview 0

Existing Members

...or Join us