How to print two different datagridview in a single page ??

Pavithra L

11y1.2k.NET

Hai ,

In my project am I using c# windows application . Here I want to print two different datagridview in a single page. How can I do this in my project?

In toolstripmenu Item am using 10 options. Like

Options (It is a toolstripmenuitem header)

Job Details

Yarn Inwards

Production

Yarn Delivery

Fabric Delivey

etc.,

Like this , In this options I can select any items .either one or more items in toolstripmenuitem. and then click on the print option it will print the two items in a single page.

Here each iem having separate datagridview for collecting the values of database tables.

Kindly help this question , its really urgent so please reply me quickly.

Thanks in advance.

10 Replies

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

Vipan Sharma11y ago
Hello ,

Hope you solved your problem.

I'm using VS2013.

Due to national holiday, I'm not able to revert you . Reply me if you are not able to solve printing issue.

Have a nice day.

Vipan
Pavithra L11y ago
Hello,

Vipan sharma are you there ? will you please help my question ,and I need to solve it quickly today.

Please do something to get an output for printing in c# windows based application.

Thanks for your reply.
Pavithra L11y ago
Hai,

Your application is not open in my system , Am I using visual studio 2010 version . and are you using which version?

Thanks for your reply.
Vipan Sharma11y ago
Hello,

I have checked you code and also find the link you are following to print the document

http://www.codeproject.com/Articles/13678/The-DataGridViewPrinter-Class

As per your code. you call method one by one(SetupThePrinting(), SetupThePrinting()1,.. )to print multiple dataGridViews in single page . So every time new print command fire in if statement .Printing multiple grid view in single page you need to call one print command for all dataGridView . According to me you need to add dataGridView in a panel and print panel not single dataGridView .
For printing the panel and content of panel you can refer the attached code.
( You can add panel statically as well dynamically , according to your requirement. )

P.S. I have not done any print setting in sample code. Its just for reference.

Hope it will help you. Kindly let me know if you required any help.
All the best :)
Pavithra L11y ago
Hello,

Can you understand my coding. Is there any possibilities to view the exact result for my query. will you please reply quickly.

Thanks.
Pavithra L11y ago
Hello,

Am using this below code in form load.

if (JobDetailsToolStripMenuItem.Checked == true)
{
// dataGridView1.Visible = false; dataGridView2.Visible = false;
// Setting the style of the DataGridView control
dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Times New Roman", 9, FontStyle.Bold, GraphicsUnit.Point);
dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = SystemColors.ControlDark;
dataGridView1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.DefaultCellStyle.Font = new Font("Times New Roman", 8, FontStyle.Regular, GraphicsUnit.Point);
dataGridView1.DefaultCellStyle.BackColor = Color.Empty;
dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = SystemColors.ControlLight;
dataGridView1.CellBorderStyle = DataGridViewCellBorderStyle.Single;
dataGridView1.GridColor = SystemColors.ControlDarkDark;
// Changing the last column alignment to be in the Right alignment
dataGridView1.Columns[dataGridView1.Columns.Count - 1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
// Adjusting each column to be fit as the content of all its cells, including the header cell
dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
else if (YarnInwardsToolStripMenuItem.Checked == true)
{
// Setting the style of the DataGridView control
dataGridView3.ColumnHeadersDefaultCellStyle.Font = new Font("Times New Roman", 9, FontStyle.Bold, GraphicsUnit.Point);
dataGridView3.ColumnHeadersDefaultCellStyle.BackColor = SystemColors.ControlDark;
dataGridView3.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
dataGridView3.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView3.DefaultCellStyle.Font = new Font("Times New Roman", 8, FontStyle.Regular, GraphicsUnit.Point);
dataGridView3.DefaultCellStyle.BackColor = Color.Empty;
dataGridView3.AlternatingRowsDefaultCellStyle.BackColor = SystemColors.ControlLight;
dataGridView3.CellBorderStyle = DataGridViewCellBorderStyle.Single;
dataGridView3.GridColor = SystemColors.ControlDarkDark;
// Changing the last column alignment to be in the Right alignment
dataGridView3.Columns[dataGridView3.Columns.Count - 1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
// Adjusting each column to be fit as the content of all its cells, including the header cell
dataGridView3.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
else if (productionToolStripMenuItem.Checked == true)
{
// Setting the style of the DataGridView control
dataGridView4.ColumnHeadersDefaultCellStyle.Font = new Font("Times New Roman", 9, FontStyle.Bold, GraphicsUnit.Point);
dataGridView4.ColumnHeadersDefaultCellStyle.BackColor = SystemColors.ControlDark;
dataGridView4.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
dataGridView4.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView4.DefaultCellStyle.Font = new Font("Times New Roman", 8, FontStyle.Regular, GraphicsUnit.Point);
dataGridView4.DefaultCellStyle.BackColor = Color.Empty;
dataGridView4.AlternatingRowsDefaultCellStyle.BackColor = SystemColors.ControlLight;
dataGridView4.CellBorderStyle = DataGridViewCellBorderStyle.Single;
dataGridView4.GridColor = SystemColors.ControlDarkDark;
// Changing the last column alignment to be in the Right alignment
dataGridView4.Columns[dataGridView4.Columns.Count - 1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
// Adjusting each column to be fit as the content of all its cells, including the header cell
dataGridView4.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
Pavithra L11y ago
Hai

Below is the code for printing selected option.
private void printToolStripMenuItem1_Click(object sender, EventArgs e)
{
if (JobDetailsToolStripMenuItem.Checked == true)
{
if (SetupThePrinting()) MyPrintDocument.Print();
}
if(YarnInwardsToolStripMenuItem.Checked == true)
{
if (SetupThePrinting1()) MyPrintDocument.Print();
}
if (productionToolStripMenuItem.Checked == true)
{
if (SetupThePrinting2()) MyPrintDocument.Print();
}

else
{
MessageBox.Show("Please select your option If you want to print any details?");
}
}

private void MyPrintDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
if (JobDetailsToolStripMenuItem.CheckOnClick == true)
{
bool more = MyDataGridViewPrinter.DrawDataGridView(e.Graphics);
if (more == true)
e.HasMorePages = true;
}
if (YarnInwardsToolStripMenuItem.CheckOnClick == true)
{
bool more1 = MyDataGridViewPrinter.DrawDataGridView(e.Graphics);
if (more1 == true)
e.HasMorePages = true;
}
if (productionToolStripMenuItem.CheckOnClick == true)
{
bool more2 = MyDataGridViewPrinter.DrawDataGridView(e.Graphics);
if (more2 == true)
e.HasMorePages = true;
}

}
private bool SetupThePrinting()
{
PrintDialog MyPrintDialog = new PrintDialog();
MyPrintDialog.AllowCurrentPage = false;
MyPrintDialog.AllowPrintToFile = false;
MyPrintDialog.AllowSelection = false;
MyPrintDialog.AllowSomePages = false;
MyPrintDialog.PrintToFile = false;
MyPrintDialog.ShowHelp = false;
MyPrintDialog.ShowNetwork = false;
if (MyPrintDialog.ShowDialog() != DialogResult.OK)
return false;
MyPrintDocument.DocumentName = "Job Details";
MyPrintDocument.PrinterSettings = MyPrintDialog.PrinterSettings;
MyPrintDocument.DefaultPageSettings = MyPrintDialog.PrinterSettings.DefaultPageSettings;
MyPrintDocument.DefaultPageSettings.Margins = new Margins(40, 40, 40, 40);
if (JobDetailsToolStripMenuItem.CheckOnClick == true)
{
if (MessageBox.Show("Do you want the report to be centered on the page", "InvoiceManager - Center on Page", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
MyDataGridViewPrinter = new DataGridViewPrinter(dataGridView1, MyPrintDocument, true, true, "Job Details", new Font("Tahoma", 10, FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
else
MyDataGridViewPrinter = new DataGridViewPrinter(dataGridView1, MyPrintDocument, false, true, "Job Details", new Font("Tahoma", 10, FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
}
return true;
}
private bool SetupThePrinting1()
{
PrintDialog MyPrintDialog = new PrintDialog();
MyPrintDialog.AllowCurrentPage = false;
MyPrintDialog.AllowPrintToFile = false;
MyPrintDialog.AllowSelection = false;
MyPrintDialog.AllowSomePages = false;
MyPrintDialog.PrintToFile = false;
MyPrintDialog.ShowHelp = false;
MyPrintDialog.ShowNetwork = false;
if (MyPrintDialog.ShowDialog() != DialogResult.OK)
return false;
MyPrintDocument.DocumentName ="Yarn Inwards";
MyPrintDocument.PrinterSettings = MyPrintDialog.PrinterSettings;
MyPrintDocument.DefaultPageSettings = MyPrintDialog.PrinterSettings.DefaultPageSettings;
MyPrintDocument.DefaultPageSettings.Margins = new Margins(40, 40, 40, 40);
if (YarnInwardsToolStripMenuItem.CheckOnClick == true)
{
if (MessageBox.Show("Do you want the report to be centered on the page", "InvoiceManager - Center on Page", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
MyDataGridViewPrinter = new DataGridViewPrinter(dataGridView3, MyPrintDocument, true, true, "Yarn Inwards", new Font("Tahoma", 10, FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
else
MyDataGridViewPrinter = new DataGridViewPrinter(dataGridView3, MyPrintDocument, false, true, "Yarn Inwards", new Font("Tahoma", 10, FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
}
return true;
}
private bool SetupThePrinting2()
{
PrintDialog MyPrintDialog = new PrintDialog();
MyPrintDialog.AllowCurrentPage = false;
MyPrintDialog.AllowPrintToFile = false;
MyPrintDialog.AllowSelection = false;
MyPrintDialog.AllowSomePages = false;
MyPrintDialog.PrintToFile = false;
MyPrintDialog.ShowHelp = false;
MyPrintDialog.ShowNetwork = false;
if (MyPrintDialog.ShowDialog() != DialogResult.OK)
return false;
MyPrintDocument.DocumentName = "Production";
MyPrintDocument.PrinterSettings = MyPrintDialog.PrinterSettings;
MyPrintDocument.DefaultPageSettings = MyPrintDialog.PrinterSettings.DefaultPageSettings;
MyPrintDocument.DefaultPageSettings.Margins = new Margins(40, 40, 40, 40);
if (YarnInwardsToolStripMenuItem.CheckOnClick == true)
{
if (MessageBox.Show("Do you want the report to be centered on the page", "InvoiceManager - Center on Page", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
MyDataGridViewPrinter = new DataGridViewPrinter(dataGridView4, MyPrintDocument, true, true, "Production", new Font("Tahoma", 10, FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
else
MyDataGridViewPrinter = new DataGridViewPrinter(dataGridView4, MyPrintDocument, false, true, "Production", new Font("Tahoma", 10, FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
}
return true;
}

Please verify this and tell me any suggestion to solve my problem.

Thanks for your reply.
Vipan Sharma11y ago
Hello,

Thanks for information sharing.
Can you please share your printing code with me.

Thanks
Pavithra L11y ago
Hai ,
Am using tab control. Each tabpage having different datagridview for getting values of different tables. Here Job No field is common for all the table so using that one I can call all the details of different table in tabindexselectedchanged event. After filter the data I can choose option for print, there i can select single datatable or multiple datatable after that i can print this in a single form.

If you do not understand means kindly refer the screenshot I had attached this .

Thank you for your reply. Please tell me any suggestion for printing two different datagridview in same page , here using printdocument also same. How to do this in my project?
Vipan Sharma11y ago
Hi ,

Your requirement is not clear. Can you please explain the issue you are facing.

If two dataGridView in same page, I don't think any issue to print both in same page.

All the best . :)