/// <summary>

 /// 生成一个数据表

 /// </summary>

 /// <returns></returns>

 static DataTable GetTable()

 {

     try

     {

         DataTable dt = new DataTable("Characters");

         dt.Columns.Add("Column0");

         dt.Columns.Add("Column1");

         dt.Columns.Add("Column2");

         dt.Columns.Add("Column3");

         dt.Rows.Add("abc", "def", "ghi", "jkl");

         dt.Rows.Add("def", "ghi", "jkl", "mno");

         dt.Rows.Add("ghi", "jkl", "mno", "pqr");

         dt.Rows.Add("jkl", "mno", "pqr", "stu");

         Console.WriteLine("Set DataTable: " + dt.TableName);

         foreach (DataRow dr in dt.Rows)

         {

             foreach (object  obj in dr.ItemArray)

             {

                 Console.Write(obj.ToString() + " ");

             }

             Console.WriteLine();

         }

         Console.WriteLine("Mission complete!");

         return dt;

     }

     catch

     {

         return null;

     }

 }

 /// <summary>

 /// 将数据表写入到DBF文件中

 /// </summary>

 /// <param name="dt"></param>

 static void WriteToDbf(DataTable dt)

 {

     Console.WriteLine("Writing to: " + dt.TableName + ".dbf ...");

     //连接字符串

     string sConn =

         "Provider=Microsoft.Jet.OLEDB.4.0; " +

         "Data Source=" + System.IO.Directory.GetCurrentDirectory() + "; " +

         "Extended Properties=dBASE IV;";

     OleDbConnection conn = new OleDbConnection(sConn);

     conn.Open();

     try

     {

         //如果存在同名文件则先删除

         if (File.Exists(dt.TableName + ".dbf"))

         {

             Console.WriteLine("Delete file: " + dt.TableName + ".dbf ...");

             File.Delete(dt.TableName + ".dbf");

         }

         OleDbCommand cmd;

         //建立新表

         StringBuilder sbCreate = new StringBuilder();

         sbCreate.Append("CREATE TABLE " + dt.TableName + ".dbf (");

         for (int i = ; i < dt.Columns.Count; i++)

         {

             sbCreate.Append(dt.Columns[i].ColumnName);

             sbCreate.Append(" char(25)");

             if (i != dt.Columns.Count - )

             {

                 sbCreate.Append(", ");

             }

             else

             {

                 sbCreate.Append(')');

             }

         }

         Console.WriteLine("\nCreating Table ...");

         Console.WriteLine(sbCreate.ToString());

         cmd = new OleDbCommand(sbCreate.ToString(), conn);

         cmd.ExecuteNonQuery();

         //插入各行

         StringBuilder sbInsert = new StringBuilder();

         foreach (DataRow dr in dt.Rows)

         {

             sbInsert.Clear();

             sbInsert.Append("INSERT INTO " + dt.TableName + ".dbf (");

             for (int i = ; i < dt.Columns.Count; i++)

             {

                 sbInsert.Append(dt.Columns[i].ColumnName);

                 if (i != dt.Columns.Count - )

                 {

                     sbInsert.Append(", ");

                 }

             }

             sbInsert.Append(") VALUES (");

             for (int i = ; i < dt.Columns.Count; i++)

             {

                 sbInsert.Append("'" + dr[i].ToString() + "'");

                 if (i != dt.Columns.Count - )

                 {

                     sbInsert.Append(", ");

                 }

             }

             sbInsert.Append(')');

             Console.WriteLine("\nInserting lines ...");

             Console.WriteLine(sbInsert.ToString());

             cmd = new OleDbCommand(sbInsert.ToString(), conn);

             cmd.ExecuteNonQuery();

         }

     }

     catch (Exception ex)

     {

         Console.WriteLine(ex.Message);

     }

     conn.Close();

 }

 static void Main(string[] args)

 {

     DataTable dt = GetTable(); //生成一个数据表

     WriteToDbf(dt); //将数据表输出到DBF表中

     Console.ReadLine();

7 }