sfdatagrid print preview and printing

Question

hi,I investigate your documentation of printing and  c# sample (I convert to vb.net),but I can't solve.can you share vb.net sample or codes thanks for your help

Sampathnarayanan Sankaralingam · Answer

Hi Serdar,You can print the content of sfdatagrid using the
PrintDailog support. Please find the below code snippet for reference.

Private Sub PrintButton_Click(ByVal sender As Object, ByVal e As
  System.EventArgs)
         Dim pdfDocumentView1 As New PdfDocumentView()
   
         'Create Memory Stream to save pdfdocument.
         Dim pdfstream As New MemoryStream()
   
         Dim pdfDoc As New PdfDocument()
         pdfDoc
  = sfDataGrid1.ExportToPdf()
   
         'Save the PDF file
         pdfDoc.Save(pdfstream)
   
         'Load the pdfstream to pdfDocumentView
         pdfDocumentView1.Load(pdfstream)
   
         Dim printdialog As New PrintDialog()
         Dim pageCount As Integer =
  pdfDocumentView1.PageCount
         printdialog.AllowPrintToFile
  = True
         printdialog.AllowSomePages
  = True
         printdialog.PrinterSettings.FromPage
  = 1
         printdialog.PrinterSettings.ToPage
  = pageCount
         printdialog.PrinterSettings.MaximumPage
  = pageCount
         printdialog.PrinterSettings.MinimumPage
  = 1
   
         If printdialog.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
                printdialog.Document
  = pdfDocumentView1.PrintDocument
                printdialog.Document.Print()
         End If
  End Sub

Sample Link : https://www.syncfusion.com/downloads/support/forum/172189/ze/PrintPreview_DataGrid_Vb1595597878Regard,Sampath Narayanan.S

Serdar · Answer

Hi

Sampath ,It's work, but my grid had a few unvisible column.how can i print only visible columnsthanks for your help

Vijayarasan Sivanandham · Answer

Hi Serdar,Your requirement to print only visible columns in SfDataGrid can be achieved by customize the PdfExportingOptions.By default, all the columns in SfDataGrid will be exported to PDF. If you want to exclude hidden columns while exporting to PDF, you can use ExcludeColumns field in PdfExportingOptions. Please refer the below code snippet, 




Private Sub PrintButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) 
                Dim pdfDocumentView1 As New PdfDocumentView() 
 
                'Create Memory Stream to save pdfdocument. 
                Dim pdfstream As New MemoryStream() 
 
                Dim pdfDoc As New PdfDocument() 
 
                Dim options As New PdfExportingOptions() 
 
                Dim hiddenColumns As List(Of String) = New List(Of String)() 
                'While Exporting Hidden column Stop by Add the MappingName Of hidden column In ExcludeColumns In PdfExportingOptions  
                For Each column In sfDataGrid1.Columns 
                                If Not column.Visible Then hiddenColumns.Add(column.MappingName) 
                Next 
                options.ExcludeColumns = hiddenColumns 
 
                pdfDoc = sfDataGrid1.ExportToPdf(options) 
                'Save the PDF file 
                pdfDoc.Save(pdfstream) 
 
                'Load the pdfstream to pdfDocumentView 
                pdfDocumentView1.Load(pdfstream) 
 
                Dim printdialog As New PrintDialog() 
                Dim pageCount As Integer = pdfDocumentView1.PageCount 
                printdialog.AllowPrintToFile = True 
                printdialog.AllowSomePages = True 
                printdialog.PrinterSettings.FromPage = 1 
                printdialog.PrinterSettings.ToPage = pageCount 
                printdialog.PrinterSettings.MaximumPage = pageCount 
                printdialog.PrinterSettings.MinimumPage = 1 
 
                If printdialog.ShowDialog() = System.Windows.Forms.DialogResult.OK Then 
                                printdialog.Document = pdfDocumentView1.PrintDocument 
                                printdialog.Document.Print() 
                End If 
End Sub 
Sample Link: https://www.syncfusion.com/downloads/support/forum/172189/ze/SfDataGridDemo753953412 For more information related to ExcludeColumns options in PdfExportingOptions, please refer the user guide documentation, 

UG Link: https://help.syncfusion.com/windowsforms/datagrid/exporttopdf?cs-save-lang=1&cs-lang=vb#exclude-columns-while-exportingPlease let us know if you have any concerns in this. 

Regards, 
Vijayarasan S

Serdar · Answer

hi

Vijayarasan ,It's workthanks for help

Vijayarasan Sivanandham · Answer

Hi Serdar,We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you😊.Regards,Vijayarasan S