sql server compact是微软推出的免费嵌入式数据库,可以通过sql server 2005管理器,来连接管理它。 下面是一段简单的访问示例。
using System; using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; using System.IO; using System.Data; namespace ConsoleApplication8 { class Program { static void Main(string[] args) { string ceDataFilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "firstSqlServerCe.sdf"); const string CONN_STRING = "Data Source=firstSqlServerCe.sdf;encryption mode=platform default;Password=2654;"; if (!File.Exists(ceDataFilePath)) { using (SqlCeEngine engine = new SqlCeEngine(CONN_STRING)) { engine.CreateDatabase(); } using (SqlCeConnection conn = new SqlCeConnection(CONN_STRING)) { conn.Open(); using (SqlCeCommand comm = new SqlCeCommand("create table test(col1 INT,col2 NVARCHAR(100))", conn)) { comm.ExecuteNonQuery(); } using (SqlCeCommand comm = new SqlCeCommand("insert into test values(1,'hello 1')",conn)) { comm.ExecuteNonQuery(); } } } using (SqlCeConnection conn = new SqlCeConnection(CONN_STRING)) { using (SqlCeCommand comm = new SqlCeCommand("select * from test",conn)) { conn.Open(); using (IDataReader rdr = comm.ExecuteReader()) { while (rdr.Read()) { Console.WriteLine("{0}\t{1}",rdr["col1"],rdr["col2"]); } } } } Console.Read(); } } } |
|