public void AddNewOrderFromCSV(string Path)
{
_bulkLoader.TableName = "orders";
_bulkLoader.FieldTerminator = ";";
_bulkLoader.LineTerminator = "\n";
_bulkLoader.FileName = Path;
try
{
if (_conn.State == System.Data.ConnectionState.Open)
{
_conn.Close();
}
_conn.Open();
// Upload data from file
int count = _bulkLoader.Load();
Console.WriteLine(count + " lines uploaded.");
_conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
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.");
}