This is a migrated thread and some comments may be shown as answers.

[Solved] Display items in radgrid based on dropdown selected item

4 Answers 211 Views

Grid

This is a migrated thread and some comments may be shown as answers.

4 Answers, 1 is accepted

answered on 12 Feb 2010, 05:41 AM

Hi Shyam,

I guess you have DropDownList placed in EditItemTemplate of GridTemplateColumn like this.
aspx:

    
                <telerik:GridTemplateColumn> 
        
                    <ItemTemplate> 
        
                    </ItemTemplate> 
        
                    <EditItemTemplate> 
        
                        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true"  
        
                            onselectedindexchanged="DropDownList1_SelectedIndexChanged"> 
        
                            <asp:ListItem Text="1"></asp:ListItem> 
        
                            <asp:ListItem Text="2"></asp:ListItem> 
        
                        </asp:DropDownList> 
        
                    </EditItemTemplate> 
        
                </telerik:GridTemplateColumn>

You can attach 'SelectedIndexChanged' event to dropdownlist and execute the query, and set the DataSource of grid to populate it.
cs:

    
                protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) 
        
                { 
        
                    DropDownList dropdown = (DropDownList)sender; 
        
                    dropdown.SelectedValue.ToString(); 
        
                    string str = dropdown.SelectedValue.ToString(); //for geting the selected item  
        
                    string sql = "SELECT * from Categories WHERE CategoryName='" + str+"'";  
        
                    SqlDataAdapter adapter = new SqlDataAdapter(sql, ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);  
        
                    DataTable dt = new DataTable();  
        
                    adapter.Fill(dt);  
        
                    RadGrid1.DataSource = dt;  
        
                    RadGrid1.Rebind(); 
        
                }

Regards,
Shinu.