你要使用sqlce首先要检查sqlserver服务是否启动。
用VS2008创建项目时选智能设备(VS2010不支持WinCE),目标平台选winCE
SqlCeConnection conn = new SqlCeConnection(@"Data Source =\AppDatabase1.sdf");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
SqlCeTransaction tx = conn.BeginTransaction();
cmd.Transaction=tx;
foreach (MessageInfo mi in f_mi)
{
cmd.CommandText = "insert into temp (s1, s2) values ('1', '0',)";
cmd.ExecuteNonQuery();
}
tx.Commit();
MessageBox.Show("成功!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}