asp.net c# mysql操作 之 从文件加载表内容

isgood

　　static void testBulkLoader()
{
　　string connStr = "server=localhost;user=root;database=test;port=3306;password=123456;";
MySqlConnection conn = new MySqlConnection(connStr);
　　MySqlBulkLoader bl = new MySqlBulkLoader(conn);
/*
* career_data.txt内容
Name Age Profession
　　 Tony 47 Technical Writer
Ana 43 Nurse
Fred 21 IT Specialist
Simon 45 Hairy Biker
*/
bl.TableName = "Career";
bl.FieldTerminator = "\t";
bl.LineTerminator = "\n";
bl.FileName = "c:/career_data.txt";
bl.NumberOfLinesToSkip = 3; //忽略第三行即：Tony 47 Technical Writer不显示
　　try
{
Debug.WriteLine("Connecting to MySQL...");
conn.Open();
　　 // Upload data from file
int count = bl.Load();
Debug.WriteLine(count + " lines uploaded.");
　　string sql = "SELECT Name, Age, Profession FROM Career";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
　　while (rdr.Read())
{
Debug.WriteLine(rdr[0] + " -- " + rdr[1] + " -- " + rdr[2]);//col1 col2 col3
}
　　rdr.Close();
　　conn.Close();
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
Debug.WriteLine("Done.");
}
　　
　　输出：
　　Ana 43 Nurse
-- --
Fred 21 IT Speciali -- --
Simon 45 Hairy Bike -- --
Done.