Is it possible to dynamically change the datasource of a grid

[David]

Hi everyone,

I want to know if it's possible to change the datasource of a grid. The reason is that I used a listbox and I want that, when someone click on a item in the listbox, the grid automatically show the data associated with the item. But each item contains differents data. Can someone helps me ?

Ps : If it can help you, I want to create something that similiar to a file explorer.

[Shinu]

Hello David,

You can set the RadGrid datasource dynamically. Here is the similar scenario that I tried.
Aspx:

<telerik:RadGrid ID="RadGrid1" AutoGenerateColumns="true" runat="server">
        </telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString3 %>"
            SelectCommand="SELECT * FROM [Employees]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString3 %>"
            SelectCommand="SELECT * FROM [Test]"></asp:SqlDataSource>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true"  onselectedindexchanged="DropDownList1_SelectedIndexChanged">
        <asp:ListItem Text="Datasource1" Value="1"></asp:ListItem>
        <asp:ListItem Text="Datasource2" Value="2"></asp:ListItem>
</asp:DropDownList>

C#:

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
   {
       if (DropDownList1.SelectedValue == "1")
       {
           RadGrid1.DataSourceID = "SqlDataSource1";
           RadGrid1.Rebind();
           Response.Write("Hai");
       }
       else
       {
           RadGrid1.DataSourceID = "SqlDataSource2";
           RadGrid1.Rebind();
       }
   }

Thanks,
Shinu.

[David]

Thank you,

It works very well. It just bother me, cause it exactly the same code that me, except that I didn't knew that I had to write radGrid1.Rebind();