csharp操纵access数据库类

static string conn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\tb_taizhan.mdb";

public static int ExcuteNonQuery(string strSqlComm_)
{
//Clear null
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);
try
{
//Execute strSqlComm_
m_OleDbConnection.Open();
OleDbCommand m_OleDbCommand = new OleDbCommand(strSqlComm_, m_OleDbConnection);
return m_OleDbCommand.ExecuteNonQuery();
}
catch (Exception err_)
{
//Throw error
throw new Exception("执行SQL语句出错：\r\n" + strSqlComm_ + "\r\n" + err_.ToString());

return -1;
}
finally
{
m_OleDbConnection.Close();
}
}

public static object ExcuteScalar(string strSqlComm_)
{
//Clear null
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);
try
{
//Execute strSqlComm_
m_OleDbConnection.Open();
OleDbCommand m_OleDbCommand = new OleDbCommand(strSqlComm_, m_OleDbConnection);
return m_OleDbCommand.ExecuteScalar();
}
catch (Exception err_)
{
//Throw error
throw new Exception("执行SQL语句出错：\r\n" + strSqlComm_ + "\r\n" + err_.ToString());

return null;
}
finally
{
m_OleDbConnection.Close();
}
}


public static DataSet GetDataSet(string strSqlComm_)
{
DataSet ds=new DataSet();
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);

try
{

OleDbDataAdapter m_DataAdapter= new OleDbDataAdapter(strSqlComm_, m_OleDbConnection);
m_DataAdapter.Fill(ds);
return ds;
}
catch (Exception err_)
{
throw new Exception("执行SQL语句出错：\r\n" + strSqlComm_ + "\r\n" + err_.ToString());


}
}