How to read this data from Notepad file and save it to sql server table .

Question

Hi Developers I have one text file that contains data in a below format 00123456^USA^23:00:01^999^Peter 00646365^England^10:00:04^785^Samuel 8r885777^Australia^12:01:32^123^Romansh I want to read this data from file and save it to sql server table . Thanks in Advance

Hiren Soni · Answer

string [] alllines = System.IO. File .ReadAllLines( filename.txt ); foreach ( string str in alllines) { string [] temp = str.Split( '^' ); string values= string .Empty; foreach ( string s in temp) { values= ' +s+ ' ; } string command = insert into tablea values( + values + ) ; //now try to use this command and execute in sqlcommand to store in table. }

Sam Hobbs · Answer

Click on the userid of the person that started this thread and look at the person's other posts.

geetika · Answer

Hamid I'm facing the similar issue. Could u plz update the resolution of the above or refer the thread where the exact solution is present? Thanks in advance

Sam Hobbs · Answer

For the benefit of others this question has been asked in two other threads also and at least one of them has a reply already.