C#创建access数据库文件,创建表

添加Microsoft ADO Ext.2.8 for DDL and Security和Microsoft ADO Ext.6.0 for DDL and Security

using System.Data.OleDb;

public static bool CreateAccessDb(string filePath)
        {
            ADOX.Catalog catalog = new ADOX.Catalog();
            if(!System.IO.File.Exists(filePath))
            {
                try
                {
                    catalog.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath +
                        ";Jet OLEDB:Engine Type = 5");
                    //创建或修改都需要这句话
                    //转换为ADO连接,并关闭
                    (catalog.ActiveConnection as ADODB.Connection).Close();
                    catalog.ActiveConnection = null;
                    catalog = null;               
                }
                catch(System.Exception e)
                {
                    return false;
                }
            }
            return true;
        }
        //传入被操作的mdb文件路径,传入要执行的sql语句
        public static void ExecuteSQLSentence(string filePath,string sql_sentence)
        {
            string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath;
            OleDbConnection connect = new OleDbConnection(connectionString);
            try
            {
                connect.Open();
                try
                {
                    OleDbCommand cmdstr = new OleDbCommand();
                    cmdstr.Connection = connect;
                    cmdstr.CommandText = sql_sentence;
                    cmdstr.ExecuteNonQuery();
                   
                    connect.Close();
                }
                catch
                {
                    MessageBox.Show("sql语句出现错误");
                }
            }
            catch
            {
                MessageBox.Show("数据库连接失败!!");
            }
        }
  • 2
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值