C#生成DBF文件

C# 生成DBF,无需注册Microsoft.Jet.OLEDB。

 1 namespace ConsoleApplication 2 { 3   class Program 4   { 5     static void Main(get='_blank'>string[] args) 6     { 7       Test(); 8       Console.ReadKey(); 9     }10 11     private static void Test()12     {13       string testPath = AppDomain.CurrentDomain.BaseDirectory;14       var odbf = new DbfFile(Encoding.GetEncoding(936));15       odbf.Open(Path.Combine(testPath, "test.dbf"), FileMode.Create);16 17       //创建列头18       odbf.Header.AddColumn(new DbfColumn("编号", DbfColumn.DbfColumnType.Character, 20, 0));19       odbf.Header.AddColumn(new DbfColumn("名称", DbfColumn.DbfColumnType.Character, 20, 0));20       odbf.Header.AddColumn(new DbfColumn("地址", DbfColumn.DbfColumnType.Character, 20, 0));21       odbf.Header.AddColumn(new DbfColumn("时间", DbfColumn.DbfColumnType.Date));22       odbf.Header.AddColumn(new DbfColumn("余额", DbfColumn.DbfColumnType.Number, 15, 3));23 24       var orec = new DbfRecord(odbf.Header) { AllowDecimalTruncate = true };25       List<User> list = User.GetList();26       foreach (var item in list)27       {28         orec[0] = item.UserCode;29         orec[1] = item.UserName;30         orec[2] = item.Address;31         orec[3] = item.date.ToString("yyyy-MM-dd HH:mm:ss");32         orec[4] = item.money.ToString();33         odbf.Write(orec, true);34       }35       odbf.Close();36     }37   }38 39   public class User40   {41     public string UserCode { get; set; }42     public string UserName { get; set; }43     public string Address { get; set; }44     public DateTime date { get; set; }45     public decimal money { get; set; }46 47     public static List<User> GetList()48     {49       List<User> list = new List<User>();50       list.Add(new User() { UserCode = "A1", UserName = "张三", Address = "上海杨浦", date = DateTime.Now, money = 1000.12m });51       list.Add(new User() { UserCode = "A2", UserName = "李四", Address = "湖北武汉", date = DateTime.Now, money = 31000.008m });52       list.Add(new User() { UserCode = "A3", UserName = "王子龙", Address = "陕西西安", date = DateTime.Now, money = 2000.12m });53       list.Add(new User() { UserCode = "A4", UserName = "李三", Address = "北京", date = DateTime.Now, money = 3000.12m });54       return list;55     }56   }57 58 }

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：C#生成DBF文件

关键词：C#