62,050
社区成员
发帖
与我相关
我的任务
分享
private static string _AccessConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.AppDomain.CurrentDomain.BaseDirectory.ToString() + @"\Data\Data.mdb;Jet OLEDB:Database Password=ybllz!@#402719";
/// <summary>
/// 执行SQl语句,如果执行成功则返回为真
/// </summary>
/// <param name="Sql">一条可执行的SQL语句</param>
/// <returns>返回一个布尔值,执行成功返回 true,否则返回false</returns>
///
private Boolean ExecSql(string Sql)
{
OleDbConnection Myconn = new OleDbConnection();
OleDbCommand Mycmd = Myconn.CreateCommand();
Boolean RetVal = false;
try
{
Myconn.ConnectionString = _AccessConnStr;
Myconn.Open();
Mycmd.CommandText = Sql;
Mycmd.CommandType = System.Data.CommandType.Text;
Mycmd.ExecuteNonQuery();
Mycmd.Dispose();
Myconn.Close();
Myconn.Dispose();
RetVal = true;
}
catch (Exception)
{
Mycmd.Dispose();
if (Myconn.State == ConnectionState.Open) { Myconn.Close(); }
Myconn.Dispose();
}
return RetVal;
}
<add name="access1" connectionString="Provider=Microsoft.Jet.OleDb.4.0;Data Source="/>
<add name="access2" connectionString="~/App_Data/#Address.mdb"/>
/// <summary>
/// 连接数据库字符串
/// </summary>
private static string connectionString = ConfigurationManager.ConnectionStrings["access1"].ConnectionString.ToString() + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["access2"].ConnectionString.ToString());