Use C # to generate and save the DBF format

When developing a project, the user requires that the data be stored in the dbf database. Therefore, we will simplify the code after the end, and hope to help you. The class code is as follows:

1. Using system;
2. Using system. collections;
3. Using system. Data;
4. Using system. Data. oledb;
6. Namespace yq
7. {
8. /// <Summary>
9. /// Summary of saveasyq7.
10. /// </Summary>
11. Public class saveasdbf
12. {
13. Public saveasdbf ()
14. {
15. //
16. // Todo: add the constructor logic here
17. //
18. }
19. Private string _ errinfo = "";
20. Public String errinfo
21. {
22. Get {return _ errinfo ;}
23. }
24. // Filename is actually a directory
25. Public bool create (string filename)
26. {
27. Bool r = false;
28. String outconnstring = string. Format ("provider = Microsoft. Jet. oledb.4.0; Data Source = {0}; extended properties = dbase iv;", filename );
29. Oledbconnection outconn = new oledbconnection (outconnstring );
30. Oledbcommand Dc = outconn. createcommand ();
32. Try
33. {
34. Outconn. open ();
36. DC. commandtype = commandtype. text;
37. DC. commandtext = "create table Table1 (automatic number int, name char (5), salary double )";
38. DC. executenonquery ();
40. R = true;
41. }
42. Catch (exception C)
43. {
44. _ Errinfo = C. message;
45. }
46. Finally
47. {
48. DC. Dispose ();
50. If (outconn. State = system. Data. connectionstate. open)
51. Outconn. Close ();
52. Outconn. Dispose ();
53. }
54. Return R;
55. }
56. // Filename is actually a directory
57. // The recordinfo class contains three attributes: Automatic ID, name, and salary.
58. Public bool save (string filename, recordinfo REC)
59. {
60. Bool r = false;
61. String outconnstring = string. Format ("provider = Microsoft. Jet. oledb.4.0; Data Source = {0}; extended properties =/" dbase iv/";", filename );
62. Oledbconnection outconn = new oledbconnection (outconnstring );
63. Oledbcommand Dc = outconn. createcommand ();
65. String TMP = "insert into Table1 (automatic number, name, salary) values ({0}, '{1}', {2 })";
66. _ Errinfo = "";
67. Try
68. {
69. Outconn. open ();
71. DC. commandtext = string. Format (TMP, Rec. Automatic ID, Rec. Name, Rec. Salary );
73. DC. executenonquery ();
74. }
75. Catch (exception ERR)
76. {
77. _ Errinfo = err. message;
78. }
79. Finally
80. {
81. If (outconn! = NULL)
82. Outconn. Close ();
84. DC. Dispose ();
85. Outconn. Dispose ();
86. }
87. Return R;
88. }
89. }
90. }

The usage is as follows:

1. Folderbrowserdialog FBD = new folderbrowserdialog ();
2. FBD. Description = "select the folder for saving the dbase iv file ";
3. FBD. selectedpath = system. environment. currentdirectory;
4. FBD. shownewfolderbutton = true;
5. If (FBD. showdialog () = dialogresult. OK)
6. {
7. If (SY. Create (FBD. selectedpath ))
8. {
9. // Recdata is data. There is no detailed value process here, which is just a demonstration.
10. Sy. Save (FBD. selectedpath, recdata );
11. }
12. }

This example does not include a complete error handling mechanism, but serves as an example. You can do it as needed.