Export to pdf ( Create pdf on fly ) using ASP.net and C#

Consider following code for creating pdf document on fly using ASP.net in C#.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace WebApplication1
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

 Continue reading 

How to enable Paging in GridView in ASP.net or Grid View Paging doesn’t work

Do Following steps.

–> Set EnablePaging and Sorting Callback = True from Propertise.
Set your data source as general way.

Now do another extra job for working paging
Write down the following code under PageIndexGhanging Event

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
      //Create your data set or table as u did 
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }

Filter data by date time in MS access, Select only date without selecting time from date time field in MS Access

Select * from TransactionInfo where CDate(Int([CreatedDate])) between #2010-05-04# and #2010-05-05#
—————–
it will return date like
—————–

23-May-2010

Select * from TransactionInfo where [CreatedDate] between #2010-05-04# and #2010-05-05#

—————–
it will return
—————–

Continue reading

Cursor in MS SQL

Using Cursor in MS SQL Server 2005 or 2008
Consider following code for creating cursor

declare db_cursor CURSOR for
SELECT ItemSLNO FROM P_Return_ItemSLNOTraking where Com_PReturnId_ItemId = @Com_ReceiveId_ItemId
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @ItemSLNO
WHILE @@FETCH_STATUS = 0
BEGIN
SET @SLNO = @SLNO+ ','+ @ItemSLNO
FETCH NEXT FROM db_cursor INTO @ItemSLNO
END
CLOSE db_cursor
DEALLOCATE db_cursor

Split in MS SQL SERVER

Here I shall describe about split in MS SQL.

There is no built in function for splitting your text, that’s why I am describing two customize function for performing split operation in MS SQL.


Split function 1: This function returns table that’s why we can say it table valued function.

--select * from fnSplit('1,22,333,444,,5555,666', ',')
CREATE FUNCTION dbo.fnSplit(
  @sInputList VARCHAR(8000) -- List of delimited items
, @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items
) RETURNS @List TABLE (item VARCHAR(8000))

 Continue reading 

The maximum report processing jobs limit configured by your system administrator has been reached

This is very common error (“maximum report processing jobs limit”) when crystal report printing job limit over

We can solve this problem using two way:
1. Need to write following code on CrystalReportViewer Unload event
a. Perform reportDocument Deispose
b.Perform reportDocument Clone
c.Perform reportDocument Close
d. Perform CrystalReportViewer Dispose

Code
============ Continue reading