[Solved] Grid View

[Angella]

Hi all,
I need two grid view in my page.I have to show both details on different link button click, now I could show only one grid and its showing in the Page load itself. Please help me with ideas.
Thanks.

[Shinu]

Hi Angella,

Here is the sample code I tried to bind RadGrid on different LinkButton Click. Please take a look into the following code.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="true"  Visible="false"
        onneeddatasource="RadGrid1_NeedDataSource"></telerik:RadGrid>
    <asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click" Text="Orders"></asp:LinkButton>
    <asp:LinkButton ID="LinkButton2" runat="server"
    onclick="LinkButton2_Click" Text="Employee"></asp:LinkButton>

C#:

string Bind = string.Empty;
public static string connection = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString3"].ConnectionString;
SqlConnection conn = new SqlConnection(connection);
public SqlCommand SqlCommand = new SqlCommand();
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
    if (Bind == "Orders")
    {
        string selectQuery1 = "select top 10 OrderID,CustomerID from Orders";
        SqlDataAdapter adapter1 = new SqlDataAdapter(selectQuery1, conn);
        DataTable dt1 = new DataTable();
        conn.Open();
        adapter1.Fill(dt1);
        conn.Close();
        RadGrid1.DataSource = dt1;
    }

    if (Bind == "Employee")
    {

        string selectQuery2 = "select top 10 EmployeeID,LastName from Employees";
        SqlDataAdapter adapter2 = new SqlDataAdapter(selectQuery2, conn);
        DataTable dt2 = new DataTable();
        conn.Open();
        adapter2.Fill(dt2);
        conn.Close();
        RadGrid1.DataSource = dt2;
    }
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
    Bind = "Orders";
    RadGrid1.Visible = true;
    RadGrid1.Rebind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
    Bind = "Employee";
    RadGrid1.Visible = true;
    RadGrid1.Rebind();
}

Please elaborate your scenario if it doesn't help.
Thanks,
Shinu. 

[Angella]

Thanks Shinu.