using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;
using System.Configuration;
private void menuItem1_Click(object sender, EventArgs e)
{
//获取可执行程序所在目录和数据库文件
string sFilePath =
System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "//DB//db.sdf";
//连接sql server Mobile数据库的连接字符串
string _LocalConnectionString = "Data Source=" + sFilePath + ";Persist Security Info=False;password=;";
_Connection = new SqlCeConnection(_LocalConnectionString);
//绑定到DATAGRID1
DataTable t = ExeceuteDataTable("select * from MyTable");
dataGrid1.DataSource = t;
}
private SqlCeConnection _Connection = null;
private string _LocalConnectionString = "";
public int ExcuteNoneQuery(string strSQL)
{
_Connection.Open();
SqlCeCommand command = _Connection.CreateCommand();
command.CommandText = strSQL;
int iRows = 0;
try
{
iRows = command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
return iRows;
}
//返回一个DataTable:
public DataTable ExeceuteDataTable(string strSQL)
{
DataTable dt = new DataTable();
try
{
SqlCeDataAdapter da = new SqlCeDataAdapter(strSQL, _Connection);
da.Fill(dt);
}
catch (Exception ex)
{
throw ex;
}
return dt;
}