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.