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

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.