连接 SQL Server CE 数据库
string sPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase.ToString());
SqlCeConnection conn = new SqlCeConnection("Data Source=" + sPath + "\\TestDB.sdf;Password ='123456'");
SqlCeDataAdapter da = new SqlCeDataAdapter("select * from testTb",conn);
DataTable dt = new DataTable();
conn.Open();
da.Fill(dt);
conn.Close();
if (dt != null && dt.Rows.Count > 0)
{
MessageBox.Show(dt.Rows[0][1].ToString());
}
SqlCeConnection conn = new SqlCeConnection("Data Source=" + sPath + "\\TestDB.sdf;Password ='123456'");
SqlCeDataAdapter da = new SqlCeDataAdapter("select * from testTb",conn);
DataTable dt = new DataTable();
conn.Open();
da.Fill(dt);
conn.Close();
if (dt != null && dt.Rows.Count > 0)
{
MessageBox.Show(dt.Rows[0][1].ToString());
}
sPath是得到数据的绝对地址，将数据库sdf文件和可执行exe程序放在同一目录下即可
如果是远程数据库则
SqlConnection con = new SqlConnection("server=192.168.1.179;database=TestDB;uid=sa;pwd=123;");
上面的服务器地址必须写真实的网络IP地址，不能为localhost或127.0.0.1