Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles
(untagged)

Scan and Save Images to a Database in C# Using Dynamic .NET TWAIN

12 Sep 2013 1  
Scan and Save Images to a Database in C# Using Dynamic .NET TWAIN

This article is in the Product Showcase section for our sponsors at CodeProject. These articles are intended to provide you with information on products and services that we consider useful and of value to developers.

Introduction

In today’s "big data era", more and more organizations are using an enterprise content management (ECM) or record management system (RMS) to help maintain and manage the documents. Digitizing documents and storing them in a central database has become an important part of many organization’s document management workflow. For this purpose, we will illustrate creating an application to capture documents as images from scanners and webcams. We’ll also cover how to save them in SQL Server in C#.

We will be using Dynamic .NET TWAIN to expedite development and deployment of such an application. Dynamic .NET TWAIN is a document scanning SDK based on the .NET Framework 2.0/4.0. The SDK enables users to capture images from TWAIN scanners and UVC/WIA webcams. It also allows simple edits or processing. Finally, it enables saving of images to your local/server disk, FTP site or database from your WinForm application.

Using the Code

If you are interested in using a .NET imaging SDK to quickly implement image capturing in your application, you can download the 30-day free trial of Dynamic .NET TWAIN. After installation, in the installation directory, you will find "DynamicDotNetTWAIN.dll" under \Bin\v2.0 and \Bin\v4.0. You can choose the corresponding version to suit your specific .NET framework version.

  

Capture Images

With Dynamic .NET TWAIN, you can enable image capturing from TWAIN devices and USB/WIA webcams using just a few lines of code. Here’s a sample of this code:

Public frmCustomizeScan()
        {
            InitializeComponent();

            dynamicDotNetTwain.SupportedDeviceType = Dynamsoft.DotNet.TWAIN.Enums.EnumSupportedDeviceType.SDT_ALL; // enable capturing images from both scanners and webcams
            int lngNum;
            dynamicDotNetTwain.OpenSourceManager();
            for (lngNum = 0; lngNum < dynamicDotNetTwain.SourceCount; lngNum++)
            {     
               cmbSource.Items.Add(dynamicDotNetTwain.SourceNameItems(Convert.ToInt16(lngNum))); // display the available imaging devices
            }
            if (lngNum > 0)
                cmbSource.SelectedIndex = 0;          

        }

        private void cmdScan_Click(object sender, EventArgs e)
        {
            dynamicDotNetTwain.IfAppendImage = true;
		    AcquireImage(); // acquire images
        }


        private void AcquireImage()
        {
            dynamicDotNetTwain.SelectSourceByIndex(Convert.ToInt16(cmbSource.SelectedIndex));
            dynamicDotNetTwain.IfShowUI = chkIfShowUI.Checked;
            dynamicDotNetTwain.OpenSource();
            dynamicDotNetTwain.IfDisableSourceAfterAcquire = true;
            
            try { dynamicDotNetTwain.AcquireImage(); }
            catch (Exception exp)
            {
                MessageBox.Show(exp.Message);
            }

        }

Uploading

Dynamic .NET TWAIN provides HTTP Upload methods with which you can upload the scanned or captured images to a web server or database. This can be done in file formats including, PDF, TIF, JPG, PNG and BMP. Multi-page TIF and PDF are also supported.

When uploading the images, you can add extra parameters and store them with the image record in the database. Here’s sample code for that:

        private void BtnUpload_Click(object sender, EventArgs e)
        {
            string strActionPage = "Upload.aspx"; // for receiving the uploaded image data on the server side
            string strFileName = textBox1.Text;
            string strFileType = textBox2.Text;
            string strHTTPServer = "localhost"; // the name or the IP of your HTTP Server
            dynamicDotNetTwain.HTTPPort = 8066; //the port number of the HTTP Server
            dynamicDotNetTwain.HTTPUserName = "chloe"; //user name for logging into HTTP Server
            dynamicDotNetTwain.HTTPPassword = "c";
            dynamicDotNetTwain.SetHTTPFormField("FileType", strFileType); // pass extra text parameters when uploading image
            dynamicDotNetTwain.HTTPUploadAllThroughPostAsPDF(strHTTPServer,strActionPage, strFileName+".pdf"); // save the captured images as a multi-page PDF file
            if (dynamicDotNetTwain.ErrorCode !=ErrorCode.Succeed)
            {
                MessageBox.Show(dynamicDotNetTwain.HTTPPostResponseString);
            }
            else
            {
                MessageBox.Show("PDF saved successfully.");
            }
        }

Upload.aspx

The action page – Upload.aspx – referred to in the HTTPUploadAllThroughPostAsPDF method is for receiving the image data on the server side. So make sure to deploy the file in your web server. Here’s how to do that:

<%@ Page Language="c#" AutoEventWireup="false" Debug="True"%>
 
<%

 	try
	{
		int iFileLength;
		HttpFileCollection files = HttpContext.Current.Request.Files;
		HttpPostedFile uploadfile = files["RemoteFile"];
		String strImageName = uploadfile.FileName; 
		String strFileType = System.Web.HttpContext.Current.Request.Form["FileType"];
	    
		iFileLength = uploadfile.ContentLength;
		Byte[] inputBuffer = new Byte[iFileLength];
		System.IO.Stream inputStream;
		inputStream = uploadfile.InputStream;
		inputStream.Read(inputBuffer,0,iFileLength);	    
	    	
	   
	    String strConnString = "Data Source=192.168.8.211;Initial Catalog=WebTwain;User ID=sa;Pwd=sa";

    
		System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(strConnString);

		String SqlCmdText = "INSERT INTO tblImage (strImageName,imgImageData, strFileType) VALUES (@ImageName,@Image, @ImageType)";
		System.Data.SqlClient.SqlCommand sqlCmdObj = new System.Data.SqlClient.SqlCommand(SqlCmdText, sqlConnection);

		sqlCmdObj.Parameters.Add("@Image",System.Data.SqlDbType.Binary,iFileLength).Value = inputBuffer;
		sqlCmdObj.Parameters.Add("@ImageName",System.Data.SqlDbType.VarChar,255).Value = strImageName;
        sqlCmdObj.Parameters.Add("@ImageType", System.Data.SqlDbType.VarChar, 255).Value = strFileType;

		sqlConnection.Open();
		sqlCmdObj.ExecuteNonQuery();
		sqlConnection.Close();
	}
	catch(Exception e)
	{
       		Response.Write(e.Message);    
       		throw;         
        
	}
    
%>

Deploy & Run the Application

For your convenience, the complete source code can be downloaded from this article.

If you get a license error when running the sample code, you can download Dynamic .NET TWAIN from Dynamsoft’s website to get a valid trial license for free:  Dynamic .NET TWAIN 30-Day Free Trial Download

Make sure you deploy the web application, which includes Upload.aspx, in your web server (IIS, Apache, etc.) and update the values of strHTTPServer, HTTPPort, HTTPUserName and HTTPPassword in BtnUpload_Click() accordingly before running. You can find CreateTable.sql for the script to create the table for storing the PDF files.

Support

Is your organization currently undergoing a project to digitize documents? Have you deployed the SDK? If so, how has it helped? Let us know in the comments section or by contacting us. You can also contact us if you need any help to get this sample code up and running. To do so, reach us by email at support@dynamsoft.com. For pricing or licensing questions, call us at 1-877-605-5491 or email our sales team at sales@dynamsoft.com.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here