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.
Loading
Trifon DinevPosted Jun 25, 2009, 8:01 AM
I know how to read from and write in a text file, but later on I want to write this data into a MySQL table.
how can I read text file with data 1 symbol char(1) - eg:
Content of the text file:
0,1,0,0,1,0;
0,0,1,0,0,0;
etc
and write into a MySQL 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.
Subramanyam RompicherlaPosted Jun 24, 2009, 2:01 PM
i did't understand your full requirements, but below link will helps to you read and write a text file
http://bytes.com/topic/net/insights/673819-write-read-text-file-c