Tuesday, March 5, 2024

How to make a list of Viewstate in ASP.NET

 List<CourtApplicationDTO> FilteredAppealList { set { ViewState["FilteredAppealList"] = value; } get { return (List<CourtApplicationDTO>)(ViewState["FilteredAppealList"]); } }

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/knowledge-base/grid-customize-content-when-exporting-radgrid-to-pdf


https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/overview


https://www.telerik.com/forums/export-to-pdf-and-save-programmatically


https://www.telerik.com/blogs/how-to-export-grid-to-pdf-file-and-show-the-result-using-the-window?-gl=1*bugbjp*-ga*Mjg3MjEwMjA2LjE3MDc3Mjc0NTU.*-ga-9JSNBCSF54*MTcwOTU0NjIzMi4xMC4xLjE3MDk1NTIyNzAuNjAuMC4w*-gcl-au*MTI1MjY4NjIzNC4xNzA3NzI3NDU1

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()));


            }


        }