Step 1 Input Data Source
In the below Connection String and Command Text boxes, input your data source and SQL command.
Step 2 Load data source and preview in dataGridView Area
Click “Load” button to load data source from Datatable and preview the data information in dataGridView area.
Step 3 Check and Modify Data Information
In the dataGridView Area, you can modify the information by double-clicking cell content. For example, we can change the cell (column gender, row 2) to female.
Step 4 Export Datatable to PDF
After make sure the all data information is correct, click “Run” button to export data to Excel. Check what we get:
The “Datatable to PDF” tool is designed and created through the help of a Free Data Export Component. If you dislike my program, you can create one by yourself. To create a Data Export tool can be very easy by using that Free Data Export Component. Follow the guides below you can make one in a few minutes.
Step1, Download the Free Data Export Component. This can help you save tons of time on programming. (The website requires register a member to download files)
Step2, Create a WindowsFormsApplication via Visual Studio. Use Free Data Export Component (Spire.DataExport for .NET).
Step3, Design windows components by yourself
Step4, You can use this free data export component to create Datatable to PDF, Datatable to Excel, Datatable to HTML, Datatable to Word, Datatable to CSV, etc.