Pls help me in this problem how can i insert fast in for loop using paramertizered query <pre lang="c#"> for(int i=0;i<=10000;i++) { string qry="insert into demo(id,text,name,age,address)values(@id,@text,@name,@age,@address)"; MySqlParameter idP=new MySqlParameter(@id",0); MySqlParameter textP=new MySqlParameter(@text,slipno/2012-13/); MySqlParameter nameP=new MySqlParameter(@name,Ram); MySqlParameter ageP=new MySqlParameter(@age,33); MySqlParameter addressP=new MySqlParameter(@address",house no#01,new street,New delhi,India); MySqlParameter[]p={idP,textP,nameP,ageP,addressP}; MysqlHelper.executenonquery(connecionstring,qry,p); }
BULK INSERT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)