Access数据库操作，连接数据库、执行SQL语句等

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;
	
}