sql server ce 创建数据库的问题
private string strConn = "Data Source = \\test.sdf";private void button1_Click(object sender, EventArgs e)
{
SqlCeEngine dbEngine = new SqlCeEngine();
dbEngine.LocalConnectionString = strConn;
try
{
dbEngine.CreateDatabase();
}
catch( SqlCeException ex)
{
MessageBox.Show("unable to creat db at "+ dbEngine.LocalConnectionString +" . Reason "+ex.Errors[0].Message);
}
}
报错是:unable to creat db at data source=\test.sdf;.Reason SQL Server CE encountered problems in creating the SQL Server Ce database.[,,,Connection string,,]
有高手知道原因吗,不胜感激
--------------------编程问答-------------------- 好像连接串的\\应该去掉,指定手机里面的绝对路径也成. --------------------编程问答-------------------- \\去掉还是出现同样的错误,
改成绝对路径,如
private string strConn = "Data Source = D:\\test.sdf";
也是出现同样的错误,
不知道为什么 --------------------编程问答-------------------- 我也遇到同样的问题,不知道是哪里出错~~~~ --------------------编程问答-------------------- string strConn = @"data source=\My Documents\MyData.sdf";
if (System.IO.File.Exists(@"\My Documents\MyData.sdf"))
{
System.IO.File.Delete(@"\My Documents\MyData.sdf");
}
SqlCeEngine eng = new SqlCeEngine(strConn);
eng.CreateDatabase();
补充:移动开发 , Windows Phone