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

Changing DatasourceID at runtime

5 Answers 349 Views

Grid

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

5 Answers, 1 is accepted

answered on 22 Jan 2009, 01:56 PM

Hi Bobby,

I tried changing the DataSourceID for the RadGrid in the code behind and it is working well. I tried this in the SelectIndexChanged event of a DropDownList. Here is the code I tried.

ASPX:

    
             <asp:DropDownList ID="DropDownList1" AutoPostBack="true" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"> 
        
                         <asp:ListItem Text="SqlDataSource1" ></asp:ListItem> 
        
                           <asp:ListItem Text="SqlDataSource2" ></asp:ListItem> 
        
                        </asp:DropDownList>

CS:

    
            protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) 
        
                { 
        
                    DropDownList ddl=(DropDownList)sender; 
        
                    RadGrid2.DataSourceID = ddl.SelectedItem.Text; 
        
                    RadGrid2.Rebind(); 
        
                }

If this does not help consider sending your aspx and code behind.

Shinu

answered on 22 Jan 2009, 02:51 PM

Thanks for the reply Shinu. I've just created a sample app and have the same problem. The postback is done, but the columns and data in the grid don't change. I have got the AutoGenerateColumns set to true

Code is below:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

        <telerik:RadScriptManager ID="RadScriptManager1" Runat="server">
        </telerik:RadScriptManager>
        <telerik:RadGrid ID="RadGrid2" runat="server" DataSourceID="SqlDataSource2"
            GridLines="None">
<HeaderContextMenu>
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
</HeaderContextMenu>

        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
            ConnectionString="<%$ ConnectionStrings:TitanicConnectionString %>"
            SelectCommand="SELECT [Name], [BearID] FROM [BEAR]">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:TitanicConnectionString %>"
            SelectCommand="SELECT [BearID], [Name], [Description], [DatePurchased], [Picture], [Checked] FROM [BEAR]">
        </asp:SqlDataSource>
        <br />

    </div>
    </form>
</body>
</html>

Partial Class _Default
Inherits System.Web.UI.Page

    Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
        Dim ddl As DropDownList = DirectCast(sender, DropDownList)
        RadGrid2.DataSourceID = ddl.SelectedItem.Text
        RadGrid2.Rebind()
    End Sub
End Class

answered on 23 Jan 2009, 06:25 AM

Hi Bobby,

I tried this on my end and it is working fine. Can you try setting the DataSourceID of the Grid to String.Empty in the SelectedIndexChanged event prior to changing.

CS:

    
             protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) 
        
                { 
        
                    DropDownList ddl=(DropDownList)sender; 
        
                    RadGrid2.DataSourceID = string.Empty; 
        
                    RadGrid2.DataSourceID = ddl.SelectedItem.Text; 
        
                    RadGrid2.Rebind(); 
        
                }

Thanks
Shinu