using System.Data.OleDb
using System.Data
public static class DataTools
{
private static OleDbConnection oleConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=sz-lgp02;Initial Catalog=LGP;User ID=sa;Password=lgp123456");
public static string sourceName = "E:\\db\\####.accdb";
public static OleDbConnection oleConn1 = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + sourceName + ";");
public static int Insert(string sql)
{
int result = 0;
try
{
oleConn.Open();
OleDbCommand oleCommand = new OleDbCommand(sql, oleConn);
result = oleCommand.ExecuteNonQuery();
}
catch (Exception exception)
{
throw;
}
finally { oleConn.Close(); }
return result;
}
public static DataTable Select(string sql)
{
DataTable tb = new DataTable();
try
{
oleConn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, oleConn);
adapter.Fill(tb);
}
catch (Exception exception)
{
string message = exception.Message;
}
finally { oleConn.Close(); }
return tb;
}
public static int Delete(string sql)
{
int ifExecute = 0;
try
{
oleConn.Open();
OleDbCommand comm = new OleDbCommand(sql);
ifExecute = comm.ExecuteNonQuery();
}
finally
{
oleConn.Close();
}
return ifExecute;
}
public static int Update(string sql)
{
int ifExecute = 0;
try
{
oleConn.Open();
OleDbCommand comm = new OleDbCommand(sql, oleConn);
ifExecute = comm.ExecuteNonQuery();
}
finally
{
oleConn.Close();
}
return ifExecute;
}
public static object ExecuteSingle(string sql)
{
object obj = null;
try
{
oleConn.Open();
OleDbCommand comm = new OleDbCommand(sql, oleConn);
obj = comm.ExecuteScalar();
}
finally
{
oleConn.Close();
}
return obj;
}
}