Tuesday, June 17, 2014

Telerik Radgridview methods and functions summary:

Telerik Radgridview Operations: (Here grid name is radgrid)

1. Fetch Specific row details by clicking on link button in the row:

((sender as LinkButton).Parent.Parent as GridItem).Selected = true;
String ID = ((radgrid.SelectedItems[0].FindControl("lblID") as Label).Text).ToString();
 OR
HiddenField hdnId = radgrid.SelectedRow.FindControl("hdnId") as HiddenField;

2. Code to change pages in radgrid using page index changed event:

 protected void radgrid_PageIndexChanged(object sender, Telerik.Web.UI.GridPageChangedEventArgs e)
    {
        radgrid.DataSource = (DataSet)Session["data"];
        radgrid.DataBind();
    }

3. Code to change the grid page size to be displayed using page size changed event:

protected void radgrid_PageSizeChanged(object sender, Telerik.Web.UI.GridPageSizeChangedEventArgs e)
    {
        radgrid.DataSource = (DataSet)Session["data"];
        radgrid.DataBind();
    }

4. Code to enable filter option with the help of item command event:

protected void radgrid_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
    {
        if (e.CommandName == "Filter")
        {
            radgrid.DataSource = (DataSet)Session["data"];
            radgrid.DataBind();
        }
    }

5. Code to export radgridview data to excel file:

 protected void btnExcel_Click(object sender, EventArgs e)
    {
        radgrid.ExportSettings.ExportOnlyData = true;
        radgrid.ExportSettings.IgnorePaging = true;
        radgrid.DataSource = (DataSet)Session["data"];
        radgrid.DataBind();
        radgrid.ExportSettings.OpenInNewWindow = true;
        radgrid.ExportSettings.FileName = "FileName";
        if (radgrid.Items.Count > 0)
        {
            radgrid.MasterTableView.ExportToExcel();
        }
    }

6. Design code to add column in the radgridview:



 <%# Container.DataItemIndex +1 %>
 




7. Design code to Make a GridView Column Visible using fetched value:


 
        LinkButton_Click" Text="Print" Visible='<%# (bool.Parse(Eval("IsVisible").ToString())) %>' ToolTip='<%# Eval("Id") %>'>




No comments:

Post a Comment

Tuesday, June 17, 2014

Telerik Radgridview methods and functions summary:

Telerik Radgridview Operations: (Here grid name is radgrid)

1. Fetch Specific row details by clicking on link button in the row:

((sender as LinkButton).Parent.Parent as GridItem).Selected = true;
String ID = ((radgrid.SelectedItems[0].FindControl("lblID") as Label).Text).ToString();
 OR
HiddenField hdnId = radgrid.SelectedRow.FindControl("hdnId") as HiddenField;

2. Code to change pages in radgrid using page index changed event:

 protected void radgrid_PageIndexChanged(object sender, Telerik.Web.UI.GridPageChangedEventArgs e)
    {
        radgrid.DataSource = (DataSet)Session["data"];
        radgrid.DataBind();
    }

3. Code to change the grid page size to be displayed using page size changed event:

protected void radgrid_PageSizeChanged(object sender, Telerik.Web.UI.GridPageSizeChangedEventArgs e)
    {
        radgrid.DataSource = (DataSet)Session["data"];
        radgrid.DataBind();
    }

4. Code to enable filter option with the help of item command event:

protected void radgrid_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
    {
        if (e.CommandName == "Filter")
        {
            radgrid.DataSource = (DataSet)Session["data"];
            radgrid.DataBind();
        }
    }

5. Code to export radgridview data to excel file:

 protected void btnExcel_Click(object sender, EventArgs e)
    {
        radgrid.ExportSettings.ExportOnlyData = true;
        radgrid.ExportSettings.IgnorePaging = true;
        radgrid.DataSource = (DataSet)Session["data"];
        radgrid.DataBind();
        radgrid.ExportSettings.OpenInNewWindow = true;
        radgrid.ExportSettings.FileName = "FileName";
        if (radgrid.Items.Count > 0)
        {
            radgrid.MasterTableView.ExportToExcel();
        }
    }

6. Design code to add column in the radgridview:



 <%# Container.DataItemIndex +1 %>
 




7. Design code to Make a GridView Column Visible using fetched value:


 
        LinkButton_Click" Text="Print" Visible='<%# (bool.Parse(Eval("IsVisible").ToString())) %>' ToolTip='<%# Eval("Id") %>'>




No comments:

Post a Comment