C# 连接SQLCE
1.命名空间
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlServerCe;
using System.Web.Configuration;
public class MySQLHelper
{
private static SqlCeConnection con;
private static SqlCeCommand cmd;
private static SqlCeTransaction Trans;
/// <summary>
/// 创建连接DB
/// </summary>
/// <returns></returns>
private SqlCeConnection CreateConnection()
{
string strcon = null;
//constr 为在Web.config中写连接DB字符串
// <connectionStrings>
// <add name="constr" connectionString="Provider=SQLOLEDB;Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=123;" />
//</connectionStrings>
strcon = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString;
return new SqlCeConnection(strcon);
}
/// <summary>
/// 返回Datatable
/// </summary>
/// <param name="strSQL"></param>
/// <returns></returns>
private DataTable GetDataTable(string strSQL )
{
DataTable dt = new DataTable();
SqlCeDataAdapter da;
try
{
con = CreateConnection();
con.Open();
try
{
SqlCeCommand dm0 = new SqlCeCommand(strSQL,con);
da = new SqlCeDataAdapter(dm0);
da.Fill(dt);
}
catch(Exception ex)
{
throw ex;
}
}
catch(Exception ex)
{
throw ex;
}
return dt;
}
/// <summary>
/// 返回DataSet
/// </summary>
/// <param name=&