Update several hundred rows at once with mysql
Can someone tell me how to make my code more efficient, is use c# and mysql, and basically I just use an insert command to insert a row. a certain part of my program does several hundred rows in sequence, but it takes a long time to run all the insert commands.
Jignesh TrivediPosted Feb 23, 2012, 10:27 PM
Please refer ,
http://www.codeproject.com/Articles/71346/Connecting-to-MySQL-Database-using-C-and-NET
http://zetcode.com/db/mysqlcsharptutorial/
good articles.