Prevent grid load on page load

[Angie]

How do I keep the RadGrid from loading (ie firing "need data source") when I access the page.  I want the grid to load only when the user clicks a specific button.  Thanks.

[Shinu]

Hi Angie,

Set the Visiblity of the RadGrid to false in the aspx and try populating the Grid in the click event of a Button as shown below.

ASPX:

<telerik:radgrid id="RadGrid1" runat="server"  Visible="false" onneeddatasource="RadGrid1_NeedDataSource"></telerik:radgrid>

CS:

 protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
    {
        BindGrid();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        BindGrid();
        RadGrid1.Rebind();
    }

  private void BindGrid()
    {
        conn.Open();
        SqlDataAdapter adp = new SqlDataAdapter("select * from Projects", conn);
        DataTable dt = new DataTable();
        adp.Fill(dt);
        RadGrid1.DataSource = dt;
        conn.Close();
        RadGrid1.Visible = true;
    }

Thanks
Shinu

[Angie]

Thank you Shinu!