Export Data. Set or Data. Winclone 4 Free Download. Table to Word Excel PDF and CSV Formats. On many occasion theres a need to export dataset or datatable to Word, Excel, PDF or CSV Text formats. In this article I am explaining how to achieve the same in ASP. Net. To export Grid. View to Word, Excel, PDF or CSV Text refer my article Export Grid. View To WordExcelPDFCSV in ASP. The Adobe Addin, also called PDFMaker, is the best choice to create highquality tagged PDF files. With the Adobe addin installed, you can export to PDF one of two. Edit PDF files with our featurerich PDF Editor software. Convert, sign, scan OCR, edit PDF files, and more. Download Foxit PDF Editor for a free trial now
Net For this tutorial I am using North. Wind Database which can be downloaded from here. Once that is downloaded you can attach the same to your SQL Server. Connection String. Below is my connection string to the database. Export Ocr Text From Pdf' title='Export Ocr Text From Pdf' />Stringconnection. StringData Source. SQLEXPRESS databaseNorthwind Integrated Securitytrue Namespaces. OCR may refer to Offices of Civil Rights, common subagency or subcomponent name of U. S. federal agencies State Office of Civil Rights, U. S. Department of State. On many occasion theres a need to export dataset or datatable to Word, Excel, PDF or CSV Text formats. In this article I am explaining how to achieve the same in. Convert Scanned PDF. Yes, it is possible to unlock text and data from scanned, image PDFs. Able2Extract is a PDF OCR converter that converts all types of scanned. Cusing System. Data using System. Data. Sql. Client using System. Text using System. IO using i. Text. Sharp. text using i. PDF-OCR_2.png' alt='Export Ocr Text From Pdf' title='Export Ocr Text From Pdf' />Text. Sharp. text. Text. Sharp. text. Text. Sharp. text. VB. Net. Imports System. Data. Imports System. Data. Sql. Client. Imports System. Text. Imports System. IOImports i. Text. Sharp. text. Imports i. Text. Sharp. Imports i. Text. Sharp. Imports i. Text. Sharp. Function to get the results in datatable. Next I am using my very own Get. Data function to get the desired data from the database which is given below. Cprivate. Data. Table Get. DataSql. Command cmd Data. Table dt new. Data. Free-Image-OCR.jpg' alt='Export Ocr Text From Pdf' title='Export Ocr Text From Pdf' />Table String str. Conn. String System. Configuration. Configuration. Manager. Connection. Stringscon. String. Connection. String Sql. Connection con new. Sql. Connectionstr. Conn. String Sql. Data. Adapter sda new. Sql. Data. Adapter cmd. Command. Type Command. Type. Text cmd. Connection con try con. Open sda. Select. Command cmd sda. Filldt return dt catch Exception ex throw ex finally con. Close sda. Dispose con. Dispose . VB. Net. Private. Function Get. DataBy. Val cmd As Sql. Command As Data. Table Dim dt As. New Data. Table Dim str. Conn. String As String System. Configuration . Configuration. Manager. Connection. Stringscon. String. Connection. String Dim con As. New Sql. Connectionstr. Conn. String Dim sda As. New Sql. Data. Adapter cmd. Command. Type Command. Type. Text cmd. Connection con Try con. Open sda. Select. Command cmd sda. Filldt Return dt Catch ex As Exception Throw ex Finally con. Close sda. Dispose con. Dispose End. Try. End. Function. As you can see above I am passing the query to the Get. Data function and it returns the results as datatable back. More details on the above function refer my article Parameterized Queries ADO. Net. Export to Word. Below is the code to export the datatable to Word Format. It first fills the datatable using the Get. Data function and then binds it to a dummy Grid. View and then the dummy Grid. View is rendered as Word document. Cprotectedvoid Export. To. Wordobject sender, Event. Args e Get the data from database into datatable string str. Query select Customer. ID, Contact. Name, City, Postal. Code from customers Sql. Command cmd new. Sql. Commandstr. Query Data. Table dt Get. Datacmd Create a dummy Grid. View Grid. View Grid. View. 1 new. Grid. View Grid. View. Allow. Paging false Grid. View. 1. Data. Source dt Grid. View. 1. Data. Bind Response. Clear Response. Buffer true Response. Add. Headercontent disposition, attachment filenameData. Table. doc Response. Charset Response. Content. Type applicationvnd. Ride Carnival Of Light Rar there. String. Writer sw new. String. Writer Html. Text. Writer hw new. Html. Text. Writersw Grid. View. 1. Render. Controlhw Response. Output. Writesw. To. String Response. Flush Response. End. VB. Net. Protected. Sub Export. To. WordBy. Val sender As. Object, By. Val e As System. Event. Args Handles btn. Export. Word. Click Get the data from database into datatable Dim str. Query As. String select Customer. ID, Contact. Name, City, Postal. Code from customers Dim cmd As. New Sql. Commandstr. Query Dim dt As Data. Table Get. Datacmd Create a dummy Grid. View Dim Grid. View. 1 As. New Grid. View Grid. View. Allow. Paging False Grid. View. 1. Data. Source dt Grid. View. 1. Data. Bind Response. Clear Response. Buffer True Response. Add. Headercontent disposition, attachment filenameData. Table. doc Response. Charset Response. Content. Type applicationvnd. Dim sw As. New String. Writer Dim hw As. New Html. Text. Writersw Grid. View. 1. Render. Controlhw Response. Output. Writesw. To. String Response. Flush Response. EndEnd. Sub. The figure below displays the generated Microsoft Word Document. Export to Excel. Below is the code to export the datatable to Excel Format. It first fills the datatable using the Get. Data function and then binds it to a dummy Grid. View and then the dummy Grid. View is rendered as Excel Workbook. Also you will notice I applied textmode style to all the rows so that it in rendered as text. Cprotectedvoid Export. To. Excelobject sender, Event. Args e Get the data from database into datatable string str. Query select Customer. ID, Contact. Name, City, Postal. Code from customers Sql. Command cmd new. Sql. Vba Auto Increment File Name Too Long For Destination'>Vba Auto Increment File Name Too Long For Destination. Commandstr. Query Data. Table dt Get. Datacmd Create a dummy Grid. View Grid. View Grid. View. 1 new. Grid. View Grid. View. Allow. Paging false Grid. View. 1. Data. Source dt Grid. View. 1. Data. Bind Response. Clear Response. Buffer true Response. Add. Headercontent disposition, attachment filenameData. Table. xls Response. Charset Response. Content. Type applicationvnd. String. Writer sw new. String. Writer Html. Text. Writer hw new. Html. Text. Writersw for int i 0 i lt Grid. View. 1. Rows. Count i Apply text style to each Row Grid. View. 1. Rowsi. Attributes. Addclass, textmode Grid. View. 1. Render. Controlhw style to format numbers to string string style lt style. Response. Writestyle Response. Output. Writesw. To. String Response. Flush Response. End VB. Net. Protected. Sub Export. To. ExcelBy. Val sender As. Object, By. Val e As System. Event. Args Handles btn. Export. Excel. Click Get the data from database into datatable Dim str. Query As. String select Customer. ID, Contact. Name, City, Postal. Code from customers Dim cmd As. New Sql. Commandstr. Query Dim dt As Data. Table Get. Datacmd Create a dummy Grid. View Dim Grid. View. 1 As. New Grid. View Grid. View. Allow. Paging False Grid. View. 1. Data. Source dt Grid. View. 1. Data. Bind Response. Clear Response. Buffer True Response. Add. Headercontent disposition, attachment filenameData. Table. xls Response. Charset Response. Content. Type applicationvnd. Dim sw As. New String. Writer Dim hw As. New Html. Text. Writersw For i As. Integer 0 To Grid. View. 1. Rows. Count 1 Apply text style to each Row Grid. View. 1. Rowsi. Attributes. Addclass, textmode Next Grid.