如何建立与我的sdf文件的连接 [英] How to give connection to my sdf file

问题描述

我正在编写如下的连接字符串
cn =新建SqlCeConnection([String] .Format(数据源= \ Program Files \ Compuage \ compuage.sdf"))

但是我想将compuage.sdf文件放在应用程序的安装位置，而不是特定的路径.

谁能帮我

预先感谢

Hi,

I am writing a connection string as below
cn = New SqlCeConnection([String].Format("Data Source=\Program Files\Compuage\compuage.sdf"))

But i want my compuage.sdf file at the location where my application is installed, not at a particular path.

Can anyone help me

Thanks in advance

推荐答案

一个坏主意:您不应该在Program Files下存储任何数据，也不应该在应用程序位置下存储数据.安全策略可能使您无法立即写信给他们.
而是将其放在您的应用程序数据文件夹中:

Bad idea: you shouldn''t store any data under Program Files, and you shouldn''t store data under you app location either. Security policies may prevent you writing to them, if not now, then in future.
Instead, put it in your application data folder:

Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)

尝试一下.确保首先安装了sqlce服务器.




Dim conn As SqlCeConnection =没什么
Dim rdr As SqlCeDataReader = Nothing
Dim connStr As String =数据源= C:\ myfiles \ PPL.sdf;密码=''xxxxxxxxxx''"
conn =新的SqlCeConnection(connStr)
将Dim cmd作为新的SqlCeCommand("SELECT * FROM PPL，其中CODE ="&Trim(PPID)&""，conn)
conn.Open()
rdr = cmd.ExecuteResultSet(ResultSetOptions.Updatable)
试试
而rdr.Read()
一个= rdr.GetSqlInt64(47).ToString
如果不是rdr.IsDBNull(2)，则a = rdr.GetString(2)
结束时
异常捕获
messagebox.show(例如ToString和vbCrLf)
终于
rdr.Close()
rdr.Dispose()
conn.Close()
结束尝试

Try this. Ensure you have the sqlce server installed first.




Dim conn As SqlCeConnection = Nothing
Dim rdr As SqlCeDataReader = Nothing
Dim connStr As String = "Data Source = C:\myfiles\PPL.sdf; Password =''xxxxxxxxxx''"
conn = New SqlCeConnection(connStr)
Dim cmd As New SqlCeCommand("SELECT * FROM PPL Where CODE=''" & Trim(PPID) & "''", conn)
conn.Open()
rdr = cmd.ExecuteResultSet(ResultSetOptions.Updatable)
Try
While rdr.Read()
a = rdr.GetSqlInt64(47).ToString
If Not rdr.IsDBNull(2) Then a = rdr.GetString(2)
End While
Catch ex As Exception
messagebox.show( ex.ToString & vbCrLf)
Finally
rdr.Close()
rdr.Dispose()
conn.Close()
End Try

这篇关于如何建立与我的sdf文件的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！