How to Populate Dropdownlist in Datagrid Dynamically?

[anup_daware]

Hi group,

 

I am using a Datagrid with Dropdown, and the values which I have to show in drop are derived from output of a query so I cant use DataSource directly to populate the Dropdown and cant even hardcoad the Listitems in dropdown.

These populated entries are also supposed to be used in an Insert Query.

 

This is how I have added the dropdown in Datagrid,

 

<asp:TemplateColumn HeaderText="MTD">

<ItemTemplate> <asp:DropDownList id="list" AutoPostBack="True" runat="server"

Width="150px">' DataTextField="X_VALUE">

</asp:DropDownList>

</ItemTemplate>

</asp:TemplateColumn>

 

 

Please suggest me how to do this dynamically or is there any other way to do this?

(I am using ASP.NET 1.1)

 

Thanks and Regards,

Anup

[bri189a]

In each item is the DropDownList going to contain the same values for each row of the DataGrid or are you running a seperate query for each row in the DataGrid.

 

If the second is true are you aware of the performance implications? If performance isn't a requirement I can help you from there, but I don't think this is the route your taking.

 

If the first is true then you CAN use a DataSource. If the Query returns a cursor (a SELECT statement) then just populate a DataSet/DataTable and use that as your DataSource.

 

I would need more specific information to help you further.

[anup_daware]

I have a datagrid with dropdown in my application.

I want to fill the data in dropdown by an ArrayList

for that I am using "e.Item.FindControl("DropdownId")"

but this function is returning NULL THUS I m getting exception

"Object Refrence not set to an Instance to Object",

 

Here is the code I wrote (ASP.NET 1.1)...

 

Hope I get some help from you,

 

 

 

///Cdoe Behind

 

 

private void dataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)

{

 

if(e.Item.ItemType == ListItemType.Footer)

{

 

 

 

System.Web.UI.WebControls.DropDownList drp = new DropDownList();

drp = (DropDownList)e.Item.FindControl("listAnup");

drp.DataSource=newArrayList;//This Statement throwing exception

drp.DataBind();

}

 

}

 

 

 

 

 

 

///aspx code

 

<asp:datagrid id=dataGrid1 style="Z-INDEX: 101; LEFT: 256px; POSITION: absolute; TOP: 8px" runat="server" ShowFooter="True" CaptionAlign="Top" Caption="Hello" BackColor="RosyBrown" AllowPaging="True" Height="256px" Width="70%" DataSource="<%# dataSet1 %>" PageSize="2" CellPadding="2" CellSpacing="2">

<FooterStyle ForeColor="#FFFF80" BorderColor="#E0E0E0" BackColor="Gray"></FooterStyle>

<SelectedItemStyle ForeColor="#804040" BorderColor="#FFE0C0" BackColor="Aqua"></SelectedItemStyle>

<EditItemStyle ForeColor="#FFE0C0" BackColor="#C0FFC0"></EditItemStyle>

<AlternatingItemStyle ForeColor="DarkOliveGreen" BackColor="#FFC080"></AlternatingItemStyle>

<ItemStyle ForeColor="#404040" BackColor="Khaki"></ItemStyle>

<HeaderStyle BackColor="RosyBrown"></HeaderStyle>

 

 

<Columns>

<asp:TemplateColumn HeaderText="Select">

<ItemTemplate>

<asp:Label id="labelSelectTyre" runat="server"></asp:Label>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="MTD">

<ItemTemplate>

<asp:DropDownList id="listAnup" AutoPostBack="True" runat="server" Width="150px"></asp:DropDownList>

</ItemTemplate>

</asp:TemplateColumn>

</Columns>

 

<PagerStyle VerticalAlign="Middle" ForeColor="#404000" BackColor="White" PageButtonCount="5"

Mode="NumericPages"></PagerStyle>

<PagerStyle NextPageText="Next" PrevPageText="Previous" HorizontalAlign="Center" Position="TopAndBottom"

BackColor="#D8D8DA" PageButtonCount="15" Mode="NumericPages"></PagerStyle>

 

<PagerStyle NextPageText="Next" PrevPageText="Previous"

HorizontalAlign="Center" Position="TopAndBottom" BackColor="#D8D8DA"

PageButtonCount="15" CssClass="dgridPaging"

Mode="NumericPages"></PagerStyle>

 

</asp:datagrid></form>

[anup_daware]

I have a datagrid with dropdown in my application.

I want to fill the data in dropdown by an ArrayList

for that I am using "e.Item.FindControl("DropdownId")"

but this function is returning NULL THUS I m getting exception

"Object Refrence not set to an Instance to Object",

 

Here is the code I wrote (ASP.NET 1.1)...

 

Hope I get some help from you,

 

 

 

///Cdoe Behind

 

 

private void dataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)

{

 

if(e.Item.ItemType == ListItemType.Footer)

{

 

 

 

System.Web.UI.WebControls.DropDownList drp = new DropDownList();

drp = (DropDownList)e.Item.FindControl("listAnup");

drp.DataSource=newArrayList;//This Statement throwing exception drp.DataBind();

}

 

}

 

 

 

 

 

 

///aspx code

 

<asp:datagrid id=dataGrid1 style="Z-INDEX: 101; LEFT: 256px; POSITION: absolute; TOP: 8px" runat="server" ShowFooter="True" CaptionAlign="Top" Caption="Hello" BackColor="RosyBrown" AllowPaging="True" Height="256px" Width="70%" DataSource="<%# dataSet1 %>" PageSize="2" CellPadding="2" CellSpacing="2">

<FooterStyle ForeColor="#FFFF80" BorderColor="#E0E0E0" BackColor="Gray"></FooterStyle>

<SelectedItemStyle ForeColor="#804040" BorderColor="#FFE0C0" BackColor="Aqua"></SelectedItemStyle>

<EditItemStyle ForeColor="#FFE0C0" BackColor="#C0FFC0"></EditItemStyle>

<AlternatingItemStyle ForeColor="DarkOliveGreen" BackColor="#FFC080"></AlternatingItemStyle>

<ItemStyle ForeColor="#404040" BackColor="Khaki"></ItemStyle>

<HeaderStyle BackColor="RosyBrown"></HeaderStyle>

 

 

<Columns>

<asp:TemplateColumn HeaderText="Select">

<ItemTemplate>

<asp:Label id="labelSelectTyre" runat="server"></asp:Label>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="MTD">

<ItemTemplate>

<asp:DropDownList id="listAnup" AutoPostBack="True" runat="server" Width="150px"></asp:DropDownList>

</ItemTemplate>

</asp:TemplateColumn>

</Columns>

 

<PagerStyle VerticalAlign="Middle" ForeColor="#404000" BackColor="White" PageButtonCount="5"

Mode="NumericPages"></PagerStyle>

<PagerStyle NextPageText="Next" PrevPageText="Previous" HorizontalAlign="Center" Position="TopAndBottom"

BackColor="#D8D8DA" PageButtonCount="15" Mode="NumericPages"></PagerStyle>

 

<PagerStyle NextPageText="Next" PrevPageText="Previous"

HorizontalAlign="Center" Position="TopAndBottom" BackColor="#D8D8DA"

PageButtonCount="15" CssClass="dgridPaging"

Mode="NumericPages"></PagerStyle>

 

</asp:datagrid></form>