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

Question

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.

Vipan Sharma · Answer

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 L · Answer

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 L · Answer

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 Sharma · Answer

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 L · Answer

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 L · Answer

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 L · Answer

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 Sharma · Answer

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

Pavithra L · Answer

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 Sharma · Answer

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 . :)