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

Best Regards,
Anup
&lt;Today is the first day of your rest of life.. Make most of it&gt;

__________________
--Everything you can imagine is real.--

1) First, you could delegate a event handler to the datagrid ItemCreated event:
dgData.ItemCreated+=new System.Web.UI.WebControls.DataGridItemEventHandler (this.DataGrid_ItemCreated);

2) Then, write a method that will be responsible for creating the dropdownlist you want. Finally, check if the e.Item is an "Item" or "AlternatingItem" and add the control in the cell you desire:
private void DataGrid_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
    if((e.Item.ItemType==System.Web.UI.WebControls.Lis tItemType.Item)||(e.Item.ItemType==System.Web.UI.W ebControls.ListItemType.AlternatingItem))
    {
        System.Web.UI.WebControls.DropDownList ddl=new System.Web.UI.WebControls.DropDownList();
...
...
        e.Item.Cells[2].Controls.Add(ddl);
    }
}

Important: e.Item is equivalent a line of the datagrid.

Regards.