List<CourtApplicationDTO> FilteredAppealList { set { ViewState["FilteredAppealList"] = value; } get { return (List<CourtApplicationDTO>)(ViewState["FilteredAppealList"]); } }
Tuesday, March 5, 2024
Telerik Grid Page size, page index and need datasource events
In telerik grid, we have to just give data source
protected void radGridAppeals_PageIndexChanged(object sender, GridPageChangedEventArgs e)
{
this.radGridAppeals.DataSource = FilteredAppealList;
}
protected void radGridAppeals_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
{
this.radGridAppeals.DataSource = FilteredAppealList;
}
Also we dont need to add e.new page size or e.newpageindex And we also need virtualitemcount may be
OR we can use NeedDataSource instead of the above functions
protected void radGridAppeals_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
this.radGridAppeals.DataSource = FilteredAppealList;
}
Telerik Grid Edit update delete Pageindex changed , pagesize changed Paging - How to call stored procedure in asp.net c# - Execute stored procdure in asp.net c#
cs file
public static T GetAllDraftPreliminaryEnquiryByOfficeIDUserIDWithPaging<T>(long officeId, long currentUserID, int pageIndex, int pageSize)
{
try
{
using (var connection = ConnectionManager.Create(ConnectionManager.ConnectTo.CBIConnection))
{
IDbCommand command = new SqlCommand("SSP_GetAllDraftPreliminaryEnquiryByOfficeIDUserIDWithPaging", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@officeId", SqlDbType.BigInt)
{
Value = officeId
});
command.Parameters.Add(new SqlParameter("@CurrentUserID", SqlDbType.BigInt)
{
Value = currentUserID
});
command.Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int)
{
Value = pageIndex
});
command.Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int)
{
Value = pageSize
});
connection.Open();
return DBHelper.Execute<T>(ref command);
}
}
catch (Exception ex)
{
//DataAccessExceptionHandler.HandleException(ref ex);
}
return default(T);
}
--------------------aspx file
<%@ Page Title="Draft Preliminary Enquiry" Language="C#" MasterPageFile="~/CBILayout.Master" AutoEventWireup="true" EnableEventValidation="false" CodeBehind="DraftPreliminaryEnquiryMigration.aspx.cs" Inherits="CBI.Portal.DraftPreliminaryEnquiryMigration" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
<style type="text/css">
.RadGrid_Default .rgSelectedRow a {
color: #428bca !important
}
.grid {
overflow: auto;
overflow-x: hidden;
}
.grid table tr td {
word-break: break-all !important;
text-align: left;
letter-spacing: 0;
color: #676767;
opacity: 1;
font-size: small;
padding: 5px !important;
vertical-align: top;
line-height: 15px;
}
.RadGrid_Default .rgHeader {
font: 12px Open Sans !important;
/*font-size: 14px !important;*/
color: #FFFFFF !important;
background: #8E8B8B 0% 0% no-repeat padding-box !important;
}
.checked {
color: red;
display: block;
}
Monday, March 4, 2024
Radgrid Telerik grid export to PDF
https://www.telerik.com/blogs/how-to-format-radgrid-pdfs
https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/pdf
https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/overview
https://www.telerik.com/forums/export-to-pdf-and-save-programmatically
Telerik Rad Grid Item command
aspx file
<telerik:RadGrid runat="server" ID="radGridOtherPet" ClientSettings-EnableRowHoverStyle="true" OnItemDataBound="radGridOtherPet_ItemDataBound" ShowHeader="true" EnableEmbeddedBaseStylesheet="True" OnItemCommand="radGrid_ItemCommand"
aspx.cs file
protected void radGrid_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
Response.Redirect(CourtApplication.Constants.EditUrl + "?ApplicationId=" + CryptologyFunctions.Encrypt(e.CommandArgument.ToString()));
}
if (e.CommandName == "Select")
{
Response.Redirect(CourtApplication.Constants.ViewProfileUrl + "?ApplicationId=" + CryptologyFunctions.Encrypt(e.CommandArgument.ToString()));
}
}