Print Blank Page while Print Preview shows the page correct

john.grimanis Grimanis

Hi,
I am trying to print data from the printer button in the top left of Print Preview window from c#, but it gives blank page.

Below is the code

// Result of the Event 'PrintPage'
private void prnDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
leftMargin = (int)e.MarginBounds.Left;
rightMargin = (int)e.MarginBounds.Right;
topMargin = (int)e.MarginBounds.Top;
bottomMargin = (int)e.MarginBounds.Bottom;
InvoiceWidth = (int)e.MarginBounds.Width;
InvoiceHeight = (int)e.MarginBounds.Height;
if (!ReadInvoice)
{
ReadInvoiceData();
SetInvoiceData(e.Graphics, e); // Draw Invoice Data
}
ReadInvoice = true;
}

private void DisplayInvoice()
{
prnPreview.Size = new System.Drawing.Size(700, 800);
try
{
prnPreview.Document = prnDocument;
prnPreview.ShowDialog();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
private void btnPreview_Click(object sender, System.EventArgs e)
{
ReadInvoice = false;
DisplayInvoice(); // Print Preview
}
public frmOrder()
{
InitializeComponent();
this.prnDialog = new System.Windows.Forms.PrintDialog();
this.prnPreview = new System.Windows.Forms.PrintPreviewDialog();
this.prnDocument = new System.Drawing.Printing.PrintDocument();
// The Event of 'PrintPage'
prnDocument.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(prnDocument_PrintPage);
}

private void SetInvoiceData(Graphics g, System.Drawing.Printing.PrintPageEventArgs e)
{// Set Invoice Table:
string FieldValue = "";
int CurrentRecord = 0;
int RecordsPerPage = 5; // twenty items in a page
decimal Amount = 0;
bool StopReading = false;
// Set Table Head:
int xProductID = leftMargin;
CurrentY = CurrentY + InvoiceFontHeight-10;
g.DrawString("Τιμολόγιο", InvoiceFontBold, BlackBrush, xProductID, CurrentY);
int xProductName = xProductID+ (int)g.MeasureString("Invoice", InvoiceFont).Width + 40;
g.DrawString("Ημέρες", InvoiceFontBold, BlackBrush, xProductName, CurrentY);
int xUnitPrice = xProductName + (int)g.MeasureString("Days", InvoiceFont).Width + 10;
g.DrawString("Σύνολο", InvoiceFontBold, BlackBrush, xUnitPrice, CurrentY);
int xQuantity = xUnitPrice + (int)g.MeasureString("Total", InvoiceFont).Width + 30;
g.DrawString("Αιτιολογία", InvoiceFontBold, BlackBrush, xQuantity, CurrentY);
AmountPosition= xQuantity + (int)g.MeasureString("Σύνολο", InvoiceFont).Width + 170;
// Set Invoice Table:
CurrentY = CurrentY + InvoiceFontHeight + 8;
while (CurrentRecord < RecordsPerPage)
{
FieldValue = rdr["InvoiceNo"].ToString();
g.DrawString(FieldValue, InvoiceFont, BlackBrush, xProductID, CurrentY);
FieldValue = rdr["Days Rented"].ToString();
g.DrawString(FieldValue, InvoiceFont, BlackBrush, xProductName, CurrentY);
FieldValue = String.Format("{0:0.00}", rdr["Period amount"]);
g.DrawString(FieldValue, InvoiceFont, BlackBrush, xUnitPrice, CurrentY);
FieldValue = rdr["Reason"].ToString();
g.DrawString(FieldValue, InvoiceFont, BlackBrush, xQuantity, CurrentY);
CurrentY = CurrentY + InvoiceFontHeight;
if (!rdr.Read())
{
StopReading = true;
break;
}
CurrentRecord++;
}
if (CurrentRecord < RecordsPerPage)
{ e.HasMorePages = false; }
else
{ e.HasMorePages = true;}
if (StopReading)
{ rdr .Close();
con.Close();
SetInvoiceTotal(g);
}
g.Dispose();
}

Thank you,

John

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kumar Bhimsen8y ago
/****** Object: StoredProcedure [dbo].[Fee_StudentFeeApprovalInsertUpdate] Script Date: 7/19/2018 11:08:12 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--/*
ALTER Proc [dbo].[Fee_StudentFeeApprovalInsertUpdate]
(
@xmlDoc nvarchar(max)
)
as
--*/
/* Fee_StudentFeeApprovalInsertUpdate
declare @xmlDoc nvarchar(max) = '

0
7862
49

47

1
0
1

1

0
0
167
true

0
0
13
true

0
0
31
true

'
*/
Begin
Declare @Idoc int
EXEC sp_xml_preparedocument @Idoc OUTPUT, @xmlDoc
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
BEGIN TRAN
BEGIN TRY

--Fee_StudentApproved_Details
if((select ISNULL(PK_StudentApprovalId,0) FROM OPENXML (@Idoc,'/NewDataSet/StudentFeeApprovalDetails',2)WITH(PK_StudentApprovalId bigint,FK_StudentId bigint) where FK_StudentId IS NOT NULL)=0)
BEGIN
insert into Fee_StudentApproved_Details(FK_StudentId, FK_ProgrammeId, FK_SubjectBranchId, FK_AcademicSessionId, FK_ProgrammeCycleId, FatherIncome, IsActive, PayMode, IsApproved,CreatedDate, Userid)
Select FK_StudentId, X.FK_ProgrammeId, case when FK_SubjectBranchId=0 then null else FK_SubjectBranchId end ,
FK_AcademicSessionId,PCM.PK_ProgrammeCycleId FK_ProgrammeCycleId, FatherIncome, X.IsActive, PayMode, IsApproved,getdate() as CreatedDate, Userid
FROM OPENXML (@Idoc,'/NewDataSet/StudentFeeApprovalDetails',2)WITH(PK_StudentApprovalId bigint,FK_StudentId bigint,FK_ProgrammeId int,FK_SubjectBranchId int,FK_AcademicSessionId int,FK_ProgrammeCycleId int,FatherIncome varchar(50), IsActive int,PayMode int,IsApproved int,CreatedDate datetime,Userid int) X
inner join PCM_ProgrammeCycle_Mst PCM on PCM.FK_ProgrammeId=X.FK_ProgrammeId and PCM.DisplayOrder=1 and FK_SemesterId=1
where ISNULL(FK_StudentId,0)>0
and ISNULL(PK_StudentApprovalId,0)=0
Declare @FK_StudentApprovalId bigint=@@identity

insert into Fee_StudentApprovedSubject_Details(FK_StudentApprovalId,FK_SubjectBranchId,Isactive)
select @FK_StudentApprovalId,FK_SubjectBranchId,Isactive FROM OPENXML (@Idoc,'/NewDataSet/StudentFeeApprovalDetails/Fee_StudentApprovedSubject_Details',2)WITH(PK_StudentApprovalSubId bigint,FK_StudentApprovalId bigint,FK_SubjectBranchId int,Isactive bit)
update SRM_Student_Mst
set
FK_ProgrammeId=X.FK_ProgrammeId,
FatherIncome=X.FatherIncome,
FK_AdmittedProgrammeCycleId=PCM.PK_ProgrammeCycleId,
FK_CurrentProgrammeCycleId=PCM.PK_ProgrammeCycleId
FROM OPENXML (@Idoc,'/NewDataSet/StudentFeeApprovalDetails',2)WITH(PK_StudentApprovalId bigint,FK_StudentId bigint,FK_ProgrammeId int,FK_SubjectBranchId int,FK_AcademicSessionId int,FK_ProgrammeCycleId int,IsActive int,PayMode int,IsApproved int,CreatedDate datetime,Userid int,FatherIncome varchar(50)) X
inner join PCM_ProgrammeCycle_Mst PCM on PCM.FK_ProgrammeId=X.FK_ProgrammeId and PCM.DisplayOrder=1 and FK_SemesterId=1
where X.FK_StudentId=SRM_Student_Mst.PK_StudentId
and ISNULL(FK_StudentId,0)>0
END
else
BEGIN
update Fee_StudentApproved_Details
set
FK_ProgrammeId=X.FK_ProgrammeId,
FK_SubjectBranchId= case when X.FK_SubjectBranchId=0 then null else X.FK_SubjectBranchId end ,
FK_AcademicSessionId=X.FK_AcademicSessionId,
FK_ProgrammeCycleId=PCM.PK_ProgrammeCycleId,
IsActive=X.IsActive,
FatherIncome=x.FatherIncome,
PayMode=X.PayMode,
IsApproved=X.IsApproved,
CreatedDate=Getdate(),
Userid=X.Userid
FROM OPENXML (@Idoc,'/NewDataSet/StudentFeeApprovalDetails',2)WITH(PK_StudentApprovalId bigint,FK_StudentId bigint,FK_ProgrammeId int,FK_SubjectBranchId int,FK_AcademicSessionId int,FK_ProgrammeCycleId int,FatherIncome varchar(50),IsActive int,PayMode int,IsApproved int,CreatedDate datetime,Userid int) X
inner join PCM_ProgrammeCycle_Mst PCM on PCM.FK_ProgrammeId=X.FK_ProgrammeId and PCM.DisplayOrder=1 and FK_SemesterId=1
where
X.PK_StudentApprovalId=Fee_StudentApproved_Details.PK_StudentApprovalId
and X.FK_StudentId IS NOT NULL
Declare @FK_StudentApprovalIdex bigint
select @FK_StudentApprovalIdex=PK_StudentApprovalId FROM OPENXML (@Idoc,'/NewDataSet/StudentFeeApprovalDetails',2)WITH(PK_StudentApprovalId bigint,FK_StudentId bigint)where FK_StudentId IS NOT NULL
Delete from Fee_StudentApprovedSubject_Details where FK_StudentApprovalId=@FK_StudentApprovalIdex
insert into Fee_StudentApprovedSubject_Details (FK_StudentApprovalId,FK_SubjectBranchId,Isactive)
select @FK_StudentApprovalIdex,FK_SubjectBranchId,Isactive FROM OPENXML (@Idoc,'/NewDataSet/StudentFeeApprovalDetails/Fee_StudentApprovedSubject_Details',2)WITH(PK_StudentApprovalSubId bigint,FK_StudentApprovalId bigint,FK_SubjectBranchId int,Isactive bit)
update SRM_Student_Mst
set
FK_ProgrammeId=X.FK_ProgrammeId,
FatherIncome=X.FatherIncome,
FK_AdmittedProgrammeCycleId=PCM.PK_ProgrammeCycleId,
FK_CurrentProgrammeCycleId=PCM.PK_ProgrammeCycleId
FROM OPENXML (@Idoc,'/NewDataSet/StudentFeeApprovalDetails',2)WITH(PK_StudentApprovalId bigint,FK_StudentId bigint,FK_ProgrammeId int,FK_SubjectBranchId int,FK_AcademicSessionId int,FK_ProgrammeCycleId int,IsActive int,PayMode int,IsApproved int,CreatedDate datetime,Userid int,FatherIncome varchar(50)) X
inner join PCM_ProgrammeCycle_Mst PCM on PCM.FK_ProgrammeId=X.FK_ProgrammeId and PCM.DisplayOrder=1 and FK_SemesterId=1
where X.FK_StudentId=SRM_Student_Mst.PK_StudentId
and ISNULL(FK_StudentId,0)>0
END

COMMIT TRAN
END TRY

BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK
-- Raise an error with the details of the exception
DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
SELECT @ErrMsg = ERROR_MESSAGE(),
@ErrSeverity = ERROR_SEVERITY()
RAISERROR(@ErrMsg, @ErrSeverity, 1)
END CATCH

EXEC sp_xml_removedocument @Idoc
END
Kumar Bhimsen10y ago
Just use like following:
setTimeout(function(){ // Your printing task}, 2000);
Hope, it will work