string dest = "mytest.sdf"; SqlCeConnection cnn = new SqlCeConnection("Data Source =" + dest); try { cnn.Open(); SqlCeCommand cmd = cnn.CreateCommand(); cmd.CommandText = "select name from test"; SqlCeDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { this.label1.Text = rdr["name"].ToString(); } rdr.Close(); cmd.Dispose(); cnn.Close(); MessageBox.Show("Ok"); } catch (SqlCeException err) { MessageBox.Show(err.ToString()); } finally { cnn.Dispose(); } 注:数据库在测试程序目录中,数据库对象SqlCeConnection,SqlCeCommand,SqlCeDataReader比较常用到的对象,在测试用发现Sql Server Compact Edition 3.5不支持top关键字,很是苦恼。
windows mobile常用数据库对象应用
最新推荐文章于 2024-09-18 15:54:57 发布