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") %>'>
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 %>
No comments:
Post a Comment