【急】SQL Server数据导入Compact数据库

2012-07-27 01:44:46 135 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

使用Visual Studio 2017创建Microsoft SQL Server Compact 4.0数据库 Sql Server Compact Edition（简称SqlCE）是一个免费的嵌入式数据库，软件开发人员可以使用该数据库来构建ASP.NET网站和Windows桌面应用程序。SqlCE占用空间很小，并支持在应用程序文件夹中私有部署其二进制文件，在Visual Studio和WebMatrix中轻松进行应用程序开发以及将架构和数据无缝迁移到SQL Server。在创建数据库之前，我们首先检查电脑中是否安装了 SQL Server Compat 4.0 或3.5。可以在控制面板中的程序和功能中搜索... 阅读详情



 private static void CopyTable(SqlConnection sqlConn, SqlCeConnection ceConn, string queryString, string destTableName, bool delTalbe)

        {

            sqlConn.Open();

            ceConn.Open();

            SqlCommand sqlCmd = sqlConn.CreateCommand();

            sqlCmd.CommandText = queryString;



            SqlCeCommand ceCmd = ceConn.CreateCommand();

            ceCmd.CommandType = CommandType.TableDirect;

            ceCmd.CommandText = destTableName;



            SqlDataReader sqlReader = sqlCmd.ExecuteReader();



            SqlCeResultSet resultSet = ceCmd.ExecuteResultSet(

                ResultSetOptions.Sensitive |   //检测对数据源所做的更改

                ResultSetOptions.Scrollable |  //可以向前或向后滚动

                ResultSetOptions.Updatable); //允许更新数据



            if (delTalbe)

            {

                string sql = "delete " + destTableName;



                SqlCeCommand cmd = ceConn.CreateCommand();

                cmd.CommandText = sql;

                cmd.ExecuteNonQuery();

            }



            object[] values;



            SqlCeUpdatableRecord record;



            while (sqlReader.Read())

            {

                //从源数据库表中读取数据

                values = new object[sqlReader.FieldCount];

                sqlReader.GetValues(values);



                //把数据写入到Conpact数据库

                record = resultSet.CreateRecord();

                record.SetValues(values);

                resultSet.Insert(record);

            }



            sqlReader.Close();

            resultSet.Close();



            sqlConn.Close();

            ceConn.Close();



        }



CREATE TABLE [dbo].[test](

	[id] [int] NOT NULL,

	[order] [int] NULL,

 CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED )

resultSet.Insert(record);这句老是报错 Unspecified error [ test ]

"SQL Server Compact ADO.NET Data Provider"
" at System.Data.SqlServerCe.SqlCeDataReader.ProcessResults(Int32 hr)\r\n at System.Data.SqlServerCe.SqlCeResultSet.SetValues(SEPREPAREMODE mode, SqlCeUpdatableRecord record)\r\n at System.Data.SqlServerCe.SqlCeResultSet.InternalInsert(Boolean fMoveTo, Object sender, SqlCeUpdatableRecord record)\r\n at System.Data.SqlServerCe.SqlCeResultSet.Insert(SqlCeUpdatableRecord record)\r\n at SmartMobileDevice.DAL.DataSynTools.CopyTable(SqlConnection sqlConn, SqlCeConnection ceConn, String queryString, String destTableName, Boolean delTalbe)\r\n at SmartMobileDevice.DAL.DataSynTools.Syn()\r\n at SmartMobileDevice.Login.button1_Click(Object sender, EventArgs e)\r\n at System.Windows.Forms.Control.OnClick(EventArgs e)\r\n at System.Windows.Forms.Button.OnClick(EventArgs e)\r\n at System.Windows.Forms.ButtonBase.WnProc(WM wm, Int32 wParam, Int32 lParam)\r\n at System.Windows.Forms.Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)\r\n at Microsoft.AGL.Forms.EVL.EnterMainLoop(IntPtr hwnMain)\r\n at System.Windows.Forms.Application.Run(Form fm)\r\n at SmartMobileDevice.Program.Main()\r\n"

...全文