本帖最后由 hao8986 于 2012-02-10 09:43:39 编辑 开发环境:VS2005
开发语言:VB.NET
程序实现功能:SDF文件为mobile6.0程序创建的SQLCE3.0数据库文件,想通过winform程序来读取这个SQLCE数据库文件,读取时出现以下错误:
引用如下:
代码如下:
Imports System
Imports System.IO
Imports system.Data
Imports System.Data.SqlServerCe
Imports Microsoft.Office.Interop.Excel
Imports System.Runtime.InteropServices
Imports System.Windows.Forms
Public Class Form2
Dim loading As Boolean
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim cn As System.Data.SqlServerCe.SqlCeConnection
Dim cmd As New System.Data.SqlServerCe.SqlCeCommand
Dim da As System.Data.SqlServerCe.SqlCeDataAdapter
Dim employeeDT As System.Data.DataTable = New System.Data.DataTable("测站")
loading = True
Try
' 打开数据库连接
cn = New System.Data.SqlServerCe.SqlCeConnection("Data Source=" + AppPath + "")
' 配置、执行命令
cmd.CommandText = "SELECT DISTINCT * FROM 测站"
cmd.Connection = cn
' 加载 DataTable 对象
da = New System.Data.SqlServerCe.SqlCeDataAdapter(cmd)
da.Fill(employeeDT)
' 绑定字段
ComboBox1.DisplayMember = "测站"
ComboBox1.DataSource = employeeDT
' 例外处理
Catch sqlex As Data.SqlServerCe.SqlCeException
MsgBox(sqlex.Message.ToString)
Dim errCollection As Data.SqlServerCe.SqlCeErrorCollection = sqlex.Errors
For Each err As Data.SqlServerCe.SqlCeError In errCollection
MessageBox.Show(err.Message)
Next
Catch ex As Exception
MsgBox(ex.Message.ToString)
End Try
loading = False