 |
|
 |
|
How to print datagrid in .NET? (VB.NET, C#, C++ for .NET Windows Forms)
|
 The following article provides a programmatic approach to printing data within a .NET Windows Forms Datagrid.
|
 Basics
|
To print data within the Datagrid object that is settled down onto your .NET Windows Form, a custom code using the DataGridPrint class is used.
|
The service class is intended to help you to create a print output based on your datagrid content. The class has been included into DataGridColumns .NET assembly since it is built for .NET WinForms datagrid control and very helpful for your .NET datagrid design. It will help you to implement an application with a print preview and a print support.
|
|
|
The DataGridPrint class is used by the Print dialog and Print Preview dialog on your .NET form to draw the DataGrid object content that should be printed.
|
 Syntax
DataGridPrint(PrintDocument1, DataGrid1, bBlackWhite)
PrintDocument1 - System.Drawing.Printing.PrintDocument reusable object that sends output to a printer
DataGrid1 - System.Windows.Forms.DataGrid object that content you are going to print
bBlackWhite - boolean parameter that defines if you like to use "Black and White" printing mode or you would like to send to printer the real coloring that your datagrid control has currently on your form.
 How the .NET DataGrid Printing Works?
Printing datagrid content is provided directly by the application logic in the .NET Framework. You add a PrintDocument object to the project and handle the PrintPage event which is called every time a new page is to be printed. An object of the DataGridPrint class that renders the printed page using GDI+ graphics functions in the PrintPage event handler is used for a .NET PrintDocument object.
A print job is initiated by the PrintDocument's Print method. This starts the print job and raises one or more events. When the print job begins, a BeginPrint event occurs, followed by the PrintPage event for each page, followed by the EndPage event when the job is done. If the print job contains multiple pages, one PrintPage event will be raised for each page in the job making the PrintPage event to execute multiple times. The PrintPage event is the main event involved in printing documents. To send content to the printer you must handle this event and provide code to render the content in the PrintPage event handler.

In the above example when the Print button is clicked the custom frmPrint print dialog form will be open. The frmPrint form contains several dialog checkboxes and buttons. By using this custom Print setting form you can manage your datagrid printing output. You may define if the datagrids header title will be printed or not by assigning DataGridPrint class objects PrintTitle variable. Another Title property helps you to define the caption text on your datagrid print output. By using the Print setting form you can perform the following actions:
1. Call Print dialog and send datagrid print output directly to a printer device. The Print dialog box lets you select options for a particular print job. For example, you can specify the printer to use, the range of pages to print, and the number of copies.
2. Call Print Preview dialog. From this dialog, you can preview on the screen how each printed page of your .NET datagrid will appear, and select page layout, orientation, and the range of pages to print.
3. Call Page Setup dialog. The Page Setup dialog box lets you set the following attributes of the printed .NET datagrid page:
-The paper type (envelope, legal, letter, and so on)
-The paper source (manual feed, tractor feed, sheet feeder, and so on)
-The page orientation (portrait or landscape)
-The width of the page margins
 Example
The following example creates a DataGridPrint object and prints the Datagrid.
|
 Summary
|
That is about it for this sample. We have added the .NET datagrid printing support to an application using DataGridPrint class, a process that involved vastly less effort than would have been required to code the printing mechanism by hand. If you would like to try out this sample application you will need the sample code for this article, the trial version of DataGridPrint and the DataGridColumns library. The download links for all of these are listed at the top of this article. The demo project contains a form with a DataGrid on it and prints or previews its columns. It uses the DataGridPrint class object in code that demonstrated above.
Further information about DataGridPrint and other controls by RustemSoft can be found at http://www.rustemsoft.com
|
|
We are glad to represent our software products designed for MS Windows. The trial versions are available for free, so you can fully evaluate it before spending your money. RustemSoft develops software of several categories:
|
 Using XML Converter allows you to create XML document that
will content the same data as your original MS Excel spreadsheet, MS Access database, Word document or csv/text file. XML Converter supports major databases such as ODBC, Oracle, MySQL and MS SQL Server.
The resulting XML document will be built in strong compliance with XSL specifications.
XML Converter allows you to create an XML database. This software gives you ability to generate
an output as a set of XML tables. By using comprehensive interface you can adjust XML tags for final XML.
Also this proved to be excellent because you can change the XSL style for XML output to what you wanted.
|
 Graphical XML editing and validation tool XMLFox Advance is XML/XSD editor for creating valid well-formed XML documents and/or XSD Schema. XMLFox Advance XML/XSD editor is the Windows based graphical tool for authoring, updating, exploring, well-formedness checking or validating XML documents. XMLFox Advance is an intuitive xml and xml schema(XSD) editor, allows the xml developer to create schemas and show a visual representation of what the xml document will look like for that schema.
 XMLFox Advance Editor is a delimiter-aware XML data editor with markup-aware cut-and-paste operations, undo, rectangular selection, clear diagnostics and other innovative attractive tools to handle common XML/XSD editing tasks. Visual XML document editor, suited as a lightweight editor for document framework deployments. It features full XSD validation, but doesn't require a XSD (XML Schema Definition). XMLFox Advance includes XML View, XML Tree, XML Grid, and XML Script modes for editing.
 XMLFox Advance is the tool for beginners to XSD schema (XML Schema Definition) as well as for professionals. It has visual Schema Tree representation that dynamically updates its XSD text. Those that need help in understanding schemas will find the Schema Tree inestimable, and developers maintaining other schemas will save hours of learning time with this XML editor. It is extremely configurable and fast enough. In XMLFox Advance you can output data to several other data format files. The Editor allows you export XML tables or whole XML to the following data files: TXT; convert into CSV (Comma Separated Value) file, convert into HTML page, create MS Access database, and create Excel file.
|
 We are presenting a software package for customizing your .NET (Visual Studio 2005 and later) Windows Forms DataGridView Columns. The DataGridViewColumns .NET assembly is DataGridView Columns software package specifically designed for .NET developers. The assembly allows you to use all strengths of the MS Windows .NET Forms DataGridView control without waiving the user interface elements your customers need. DataGridViewColumns dynamic link library contains the following DataGridView Columns: Combo (extended combobox), Memo column, DateTimePicker column. Also the assembly includes the formatting intelligent DateTimeColumn, NumericColumn, TextFractionsColumn, MaskedTextBox column controls that can mask the date, time, numbers as well as the text fractions. It gives you ability to manage the IP Address, SS#, Phone numbers, etc., and checks the validation, and automatically set the delimiter location. These Column classes are chock full of functionality that you wont find in the standard Microsoft .NET DataGridView Columns, that make it easy to build professional and forcing user interfaces.
|
 We are presenting a software package for customizing your .NET Windows Forms DataGrid Columns. The DataGridColumns .NET assembly is a DataGrid Columns Styles software package specifically designed for .NET developers. The assembly allows you to use all strengths of the MS Windows .NET Forms DataGrid control without waiving the user interface elements your customers need. DataGridColumns dynamic link library contains the following DataGrid Column Styles: combobox, XPButton column Style, Memo column Style, Button column Style, DateTimePicker column Style. Also the assembly includes the formatting intelligent DateTimeColumn, NumericColumn, TextFractionsColumn style controls that can mask the date, time, numbers as well as the text fractions. It gives you ability to manage the IP Address, SS#, Phone numbers, etc., and checks the validation, and automatically set the delimiter location.
|
 Sonswish Oracle database browser is the Windows based graphical tool for database navigation, data updating, exploring, table relationships checking or validating Oracle database. Sonswish is an intuitive Oracle browser, allows the Oracle developer to create Oracle database objects (such as tables, views, procedures and so on) and show a visual representation of table relationships for that Oracle database.
 Sonswish browser is a universal Oracle database browser with data updating operations, record filtering, printing, data format validation and other innovative attractive tools to handle common Oracle database browsing tasks. Sonswish allows to browse both structures and contents of databases managed by Oracle DBMS. Despite the fact that Sonswish cannot be positioned as a database's control application, our product has a number of most important features of database control application.
 Sonswish allows to insert, delete, and update data records into database tables, remove whole tables. Furthermore, Sonswish provides interface to execute SQL statements of any complexity and for any purpose. Sonswish presents database as a hierarchical tree structure representation of all objects that belong to your Oracle database. A user can browse table structure, table indexes, primary keys, foreign keys, constraints and other table's objects. The software allows you export Oracle database tables/views to the following data files: txt, csv, html, mdb, Excel.
|
 Everyone was a beginner once. The faster we feed new people with good information, the faster they will become good members of the ".NET World". Here you can find some useful VB and C# examples. These sets of samples contain several high quality examples. These code samples show you how to work with comboboxes on Windows Forms and more
|
|