how to print visible columns in data grid view

Question

Hello friends I m facing one problem in data grid view using c# in windows Application.. i have one data grid view and there is lots of column .i hide some column but when i m printing its coming in print page or print dailog box.. how can hide in print preview dailog box and print.. is there any way to solve it then please tell me .. thanks in advance...

Naeem Khan · Answer

Thanks for your response Rajesh but its not working.. let me show you my code for print button.. private void printDocument1_PrintPage(object sender System.Drawing.Printing.PrintPageEventArgs e) { try { //Set the left margin int iLeftMargin = e.MarginBounds.Left; //Set the top margin int iTopMargin = e.MarginBounds.Top; //Whether more pages have to print or not bool bMorePagesToPrint = false; int iTmpWidth = 0; //For the first page to print set the cell width and header height if (bFirstPage) { foreach (DataGridViewColumn GridCol in gv_show_details.Columns) { iTmpWidth = (int)(Math.Floor((double)((double)GridCol.Width / (double)iTotalWidth * (double)iTotalWidth * ((double)e.MarginBounds.Width / (double)iTotalWidth)))); iHeaderHeight = (int)(e.Graphics.MeasureString(GridCol.HeaderText GridCol.InheritedStyle.Font iTmpWidth).Height) + 11; // Save width and height of headres arrColumnLefts.Add(iLeftMargin); arrColumnWidths.Add(iTmpWidth); iLeftMargin += iTmpWidth; } } //Loop till all the grid rows not get printed while (iRow = e.MarginBounds.Height + e.MarginBounds.Top) { bNewPage = true; bFirstPage = false; bMorePagesToPrint = true; break; } else { if (bNewPage) { page++; float x = 0; float y = 0; try { e.Graphics.DrawImage(resizeImage(System.Drawing.Image.FromFile(logo.jpg)) 10 30); } catch (Exception) { } e.Graphics.DrawString(StartUp.clientName + 
  + StartUp.client_address +  -  + StartUp.pin_no + 
 Academic Year :  + YearWise.ac_year + 
 Checklist Class wise Exam Details :  + cb_class.Text +  -  + cb_exams_name.Text new System.Drawing.Font(gv_show_details.Font FontStyle.Bold) Brushes.Black e.MarginBounds.Left e.MarginBounds.Top - e.Graphics.MeasureString(StartUp.clientName + 
  + StartUp.client_address +  -  + StartUp.pin_no + 
 Checklist Class wise Exam Details :  + cb_class.Text +  -  + cb_exams_name.Text new System.Drawing.Font(gv_show_details.Font FontStyle.Bold) e.MarginBounds.Width).Height - 13); String strDate = DateTime.Now.ToLongDateString() +   + DateTime.Now.ToShortTimeString() + 
Page No:  + page.ToString(); //Draw Date e.Graphics.DrawString(strDate new System.Drawing.Font(gv_show_details.Font FontStyle.Bold) Brushes.Black e.MarginBounds.Left + (e.MarginBounds.Width - e.Graphics.MeasureString(strDate new System.Drawing.Font(gv_show_details.Font FontStyle.Bold) e.MarginBounds.Width).Width) e.MarginBounds.Top - e.Graphics.MeasureString(StartUp.clientName + 
  + StartUp.client_address + StartUp.city + StartUp.pin_no + 
 Checklist Class wise Exam Details new System.Drawing.Font(new System.Drawing.Font(gv_show_details.Font FontStyle.Bold) FontStyle.Bold) e.MarginBounds.Width).Height - 13); iTopMargin = e.MarginBounds.Top; foreach (DataGridViewColumn GridCol in gv_show_details.Columns) { e.Graphics.DrawRectangle(Pens.Black new System.Drawing.Rectangle((int)arrColumnLefts[iCount] iTopMargin (int)arrColumnWidths[iCount] iHeaderHeight)); e.Graphics.DrawString(GridCol.HeaderText GridCol.InheritedStyle.Font new SolidBrush(GridCol.InheritedStyle.ForeColor) new RectangleF((int)arrColumnLefts[iCount] iTopMargin (int)arrColumnWidths[iCount] iHeaderHeight) strFormat); iCount++; } bNewPage = false; iTopMargin += iHeaderHeight; } iCount = 0; //Draw Columns Contents foreach (DataGridViewCell Cel in GridRow.Cells) { if (Cel.Value != null) { e.Graphics.DrawString(Cel.Value.ToString() Cel.InheritedStyle.Font new SolidBrush(Cel.InheritedStyle.ForeColor) new RectangleF((int)arrColumnLefts[iCount] (float)iTopMargin (int)arrColumnWidths[iCount] (float)iCellHeight) strFormat); } //Drawing Cells Borders e.Graphics.DrawRectangle(Pens.Black new System.Drawing.Rectangle((int)arrColumnLefts[iCount] iTopMargin (int)arrColumnWidths[iCount] iCellHeight)); iCount++; } } iRow++; iTopMargin += iCellHeight; } //If more lines exist print another page. if (bMorePagesToPrint) e.HasMorePages = true; else e.HasMorePages = false; } catch (Exception exc) { MessageBox.Show(exc.Message Error MessageBoxButtons.OK MessageBoxIcon.Error); } }

Manas Mohapatra · Answer

When printing event is firing use below code: GridView1.Columns[ Name ].Visible = false ; Here GridView1 id ID attribute of GriView and Name is column is present in GridView. http://www.codeproject.com/Articles/43727/Show-Hide-GridView-Columns-in-ASP-NET

Rajeesh Menoth · Answer

Hi Check this reference : http://stackoverflow.com/questions/1357271/how-can-i-prevent-the-print-progress-dialog-appearing-when-performing-a-print-pr