I have a .sql file (Script) containing mysql command like insert.
How can i run this .sql file from asp.net??
For ex: state.sql
INSERT INTO `state1`
(`state_id`,`state_name`,`dstatus`)
VALUES
(1,'aa',0),
(2,'bb',1),
(3,'cc',0),
(4,'dd',0),
(5,'ee',1),
(6,'ff',0),
(7,NULL,0),
(8,'dd',NULL),
(9,NULL,NULL),
(10,'ff',NULL),
(11,NULL,NULL);
My file contains thousands of records...
Can any one help..