Read character Delimited file and insert the records into SQL Server Database in ASP.Net

Vasanth

I am having a list of contents in the notepad.

I having the following content.

000012|vasanth|Sofware Engineer|Chennai|

0000215|Arun|ASE|Keral|

The field is static and the column name is ID,name,Designation,City.

I need to read the note pad charecter by charecter and i have to insert the records corresponding in the field which is seperated by "|".

I hope u can understand.

Please let me know if the thread is not clear.

Thanks.

Mudassar

0 1

Though this example is for windows. Same code can be used for ASP.Net

http://www.c-sharpcorner.com/uploadfile/scottlysle/working-with-delimited-text-files-in-C-Sharp/

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html