sqlce 创建数据库过程

最新推荐文章于 2023-06-29 14:30:22 发布

电动汽车砖家刘博士

最新推荐文章于 2023-06-29 14:30:22 发布

阅读量646

点赞数

本文链接：https://blog.csdn.net/lyx123/article/details/47749703

版权

1.vs2005里面添加引用

2.添加using

3.创建数据库

public void CreatDB()
        {
            if (File.Exists("\\NandFlash\\CDZ3.sdf"))
                File.Delete("\\NandFlash\\CDZ3.sdf");
            try
            {
                //创建数据库
                SqlCeEngine engine = new SqlCeEngine("Data Source = \\NandFlash\\CDZ3.sdf;password=cdz;encrypt database=TRUE");
                engine.CreateDatabase();
                engine.Dispose();

                //连接远程数据库
                /*
                string rdaOleDbConnectString = "Provider=sqloledb.1;Data Source=192.168.1.17;
                         Initial Catalog=Northwind; User Id=sa;Password=sa";
                SqlCeRemoteDataAccess rda = null;
                rda = new SqlCeRemoteDataAccess();
                rda.InternetUrl = "http://192.168.1.17/sqlce/sscesa20.dll";
                rda.LocalConnectionString = @"Data Source=\My Documents\MobileService3.sdf;password=test";
                rda.Pull("Region", "Select * from Region", rdaOleDbConnectString);
                 */
                //MessageBox.Show("ok!");
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.ToString());
             }
        }