public void myxxx() { MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection("constring"); var bl = new MySql.Data.MySqlClient.MySqlBulkLoader(connection); bl.TableName = "mytable"; bl.FieldTerminator = ","; bl.LineTerminator = "\r\n"; bl.FileName = "myfileformytable.csv"; bl.NumberOfLinesToSkip = 1; var inserted = bl.Load(); System.Diagnostics.Debug.Print(inserted + " rows inserted."); }
private MySQLManager() { _conn = new MySql.Data.MySqlClient.MySqlConnection(ParseConnectionStringFromXML()); _bulkLoader = new MySql.Data.MySqlClient.MySqlBulkLoader(_conn); }