How to change grid source in page load?

[Raul]

Hi All,

I have a grid in a page, loading data from sqldatasource, but I want to change this grid datasource in page load if I received a specific parameter, so how I can change grid source in page_load event in special case?

Please advise.

Regards

[Princy]

Hello Raul,

You can try out the following code to change the datasource of the RadGrid in the PageLoad event.
cs:

protected void Page_Load(object sender, EventArgs e)
    {
       if (condition == "satisfied")
        {
         //to clear datasource for the grid
          RadGrid1.DataSource = String.Empty;
         //to set another datasource
          RadGrid1.DataSourceID = "SqlDataSource2";
        }
    }

Thanks
Princy.