if(File.Exists("Program Files//ceCRM//data.sdf"))
{
MyConn = new SqlCeConnection("Data Source = Program Files//ceCRM//data.sdf");
}
else
{
SqlCeEngine Engine = new SqlCeEngine("Data Source = Program Files//ceCRM//data.sdf");
Engine.CreateDatabase();
Engine.Dispose();
try
{
MyConn = new SqlCeConnection("Data Source = Program Files//ceCRM//data.sdf");
MyConn.Open();
SqlCeCommand MyComm = MyConn.CreateCommand();
MyComm.CommandText = "create table admin(id int identity(1,1),name varchar(20) primary key,password varchar(20))";
MyComm.ExecuteNonQuery();//这里出错误
MyComm.CommandText = "inset into admin values('ighack','123456ab')";
MyComm.ExecuteNonQuery();
}
catch
{
MyConn.Close();
}
未处理的“System.Data.SqlServerCe.SqlCeException”类型的异常出现在 System.Data.SqlServerCe.dll 中
{
MyConn = new SqlCeConnection("Data Source = Program Files//ceCRM//data.sdf");
}
else
{
SqlCeEngine Engine = new SqlCeEngine("Data Source = Program Files//ceCRM//data.sdf");
Engine.CreateDatabase();
Engine.Dispose();
try
{
MyConn = new SqlCeConnection("Data Source = Program Files//ceCRM//data.sdf");
MyConn.Open();
SqlCeCommand MyComm = MyConn.CreateCommand();
MyComm.CommandText = "create table admin(id int identity(1,1),name varchar(20) primary key,password varchar(20))";
MyComm.ExecuteNonQuery();//这里出错误
MyComm.CommandText = "inset into admin values('ighack','123456ab')";
MyComm.ExecuteNonQuery();
}
catch
{
MyConn.Close();
}
未处理的“System.Data.SqlServerCe.SqlCeException”类型的异常出现在 System.Data.SqlServerCe.dll 中
解决方案 »
- wince 数据库连接字符串怎么写
- debug Release 版本
- UltraGRID中间空行问题
- 用户登录模块问题!!从前台界面输入用户名和密码如何与后台定义的类做比较,并成功验证登录进入系统!!
- 在一个DATAGRID里套了一个REPEATE,哪个能帮我解决下全选的问题呀
- 一个转化问题(急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!)
- 文件保存与串行化的代码混淆问题
- 新人,散分1分钟结帖
- C# 通过dllimport 调用C++ dll
- 当一个窗体缩小的一定程度,怎样禁止用户再缩小它
- c#拷贝文件夹时,代码出现错误,
- 用C#读取xml文档的问题
File.Delete("Test.sdf");string connStr = "Data Source = Test.sdf; Password = <password>";
SqlCeEngine engine = new SqlCeEngine(connStr);
engine.CreateDatabase();
engine.Dispose();SqlCeConnection conn = null;try {
conn = new SqlCeConnection(connStr);
conn.Open(); SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "CREATE TABLE myTable (col1 int, col2 ntext)";
cmd.ExecuteNonQuery();
}
catch {}
finally {
conn.Close();
}
--------------
改动如下string path=@"c:\Program Files\ceCRM\data.sdf";
if(File.Exists(path))
{
File.Delete(path);//加这句,估计是已经存在了该文件,所以创建时出错
MyConn = new SqlCeConnection("Data Source="+path);
}
else
{
SqlCeEngine Engine = new SqlCeEngine("Data Source ="+path);
}
试试
文件是不存在的
drk928(一起看斜阳)
你说的方法没有用啊