public static string sOleDbPath = Assembly.GetExecutingAssembly().Location + "\\..\\..\\奚学长的后宫.mdb";
1.获得数据库连接
/// <summary>
/// 获得数据库连接
/// </summary>
/// <param name="OleDbPath">数据库存储路径</param>
/// <returns></returns>
public static OleDbConnection GetDataBaseConnection(string OleDbPath)
{
string sOleDbConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + OleDbPath;
OleDbConnection OleDbConn = new OleDbConnection(sOleDbConn);
OleDbConn.Open();
return OleDbConn;
}
2.执行SQL并返回数据表
/// <summary>
/// 执行SQL并返回数据表
/// </summary>
/// <param name="OleDbConn">数据库连接</param>
/// <param name="Sql">SQL语句</param>
/// <returns></returns>
public static System.Data.DataTable ExecuteQuery(OleDbConnection OleDbConn, string Sql)
{
System.Data.DataTable dt = new System.Data.DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(Sql, OleDbConn);
da.Fill(dt);
OleDbConn.Close();
return dt;
}
3.执行SQL,返回是否执行成功
/// <summary>
/// 执行SQL,返回是否执行成功
/// </summary>
/// <param name="OleDbConn">数据库连接</param>
/// <param name="Sql">SQL语句</param>
/// <returns></returns>
public static bool ExecuteNoneQuery(OleDbConnection OleDbConn, string Sql)
{
bool bResult = true;
if (OleDbConn == null)
{
return false;
}
if (OleDbConn.State == ConnectionState.Closed)
{
OleDbConn.Open();
}
OleDbCommand oleDBcmd = new OleDbCommand(Sql, OleDbConn);
if (oleDBcmd.ExecuteNonQuery() > 0)
{
bResult = true;
}
else
{
bResult = false;
}
return bResult;
}
4.判断数据表是否存在
/// <summary>
/// 判断数据表是否存在
/// </summary>
/// <param name="OleDbConn"></param>
/// <param name="TableName"></param>
/// <returns></returns>
public static bool IsExistsTable(OleDbConnection OleDbConn, string TableName)
{
bool bResult = true;
int iResult = 0;
DataTable schemaTable =OleDbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] { null, null, null, "TABLE" });
if(schemaTable!=null)
{
foreach(DataRow dr in schemaTable.Rows)
{
string sCurTableName = dr["TABLE_NAME"] != null ? dr["TABLE_NAME"].ToString() : string.Empty;
if(TableName==sCurTableName)
{
iResult++;
break;
}
}
}
if (iResult == 0)
{
bResult = false;
}
else
{
bResult = true;
}
return bResult;
}