C# 创建DBF文件

最新推荐文章于 2024-08-03 05:05:37 发布

maji_lulu

最新推荐文章于 2024-08-03 05:05:37 发布

阅读量2.1k

点赞数

分类专栏： C# 基础文章标签： c# cmd insert properties exception string

C# 基础专栏收录该内容

6 篇文章 0 订阅

订阅专栏

string str_oleConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/;Extended Properties=dBASE IV;";
System.Data.OleDb.OleDbConnection ole_conn = new System.Data.OleDb.OleDbConnection(str_oleConn);

try
{
ole_conn.Open();
System.Data.OleDb.OleDbCommand cmd1 = new System.Data.OleDb.OleDbCommand
("Create Table xxx (Field1 int, Field2 char(10))",
ole_conn);
System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand
("Insert Into xxx values (1,'Hello3')", ole_conn);
System.Data.OleDb.OleDbCommand cmd3 = new System.Data.OleDb.OleDbCommand
("Insert Into xxx values (2,'Hello4')", ole_conn);
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
ole_conn.Close();
}