Click here to Skip to main content
15,744,010 members
Please Sign up or sign in to vote.
1.80/5 (2 votes)
See more:
I am Doing a project in Asp.net , The The image file ( any Formats) e.g.Tender Form is Converted to OCR That OCR Converted File Store in to SQL Server Database in Different Fields Formats like date Company Name, Address, Reference No , Item ,QTY ,UOM,total etc.
Posted
Comments
Richard MacCutchan 9-Oct-13 7:03am    
And your question is?
[no name] 9-Oct-13 8:47am    
What you want to ask??

1 solution

OCR stands for Optical Character Recognition,
This Technology will help you to extract 'TEXT' data from image file and store it to Text File(*.txt) or Rich Text Format(*.rtf).

U Can read Text File or Rich Text Format file using

C#
string [] allLines = File.Read("DestinationFilePath");


Once you got text data from file, here lets consider you have read Tender Form. Now just Write Sql Insert query.
C#
SqlCommand cmd=new SqlCommand ("insert into tablename values('alllines[0]')",Connection)
cmd.ExecuteNonQuery();


NOTE: Please not that OCR cant read Formated Text or Underlined Text or Table Content. So, keep simple text as much as you can.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900