read text file and write in a database
Hi,
Can you give me a sample in asp.net c#, to see how can I read text file with data 1 symbol char(1) - eg: 0,1,0,0,1,0; 0,0,1,0,0,0;
etc and write into a database.
create table equipment(
id int not null auto_increment,
alarm char(1) not null,
warning char(1) not null,
normal char(1) not null,
open_door char(1) not null,
fire char(1) not null,
power_on char(1) not null);
This is for 5 tables. But to be able to read the data at the same time, so I need to avoid read/write conflicts.
Thanks and regards,
Trifon.