博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

ACCESS通用类

Posted on 2010-06-14 10:54  gzlxm  阅读(419)  评论(0)    收藏  举报

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

 

 

/// <summary>
///AccessDBHelper 的摘要说明
/// </summary>
public class AccessDBHelper
{
    
private  string connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Jet Oledb:Database Password=mingmei114;Data Source=";
    
    
public AccessDBHelper()
    {
        
    }
    
public AccessDBHelper(string AsaFilePath)
    {
        connectionString 
+= AsaFilePath;
    }
    
private  OleDbConnection connection;

 

 

public  OleDbConnection Connection
    {
        
get 
        {
            
if (connection == null)
            {
                connection 
= new OleDbConnection(connectionString);
                connection.Open();
            }
            
else if (connection.State == System.Data.ConnectionState.Closed)
            {
                connection.Open();
            }
            
else if (connection.State == System.Data.ConnectionState.Broken)
            {
                connection.Close();
                connection.Open();
            }
            
return connection;
        }
    }

 

 

 

public  int ExecuteCommand(string safeSql)
    {
        OleDbCommand cmd 
= new OleDbCommand(safeSql,Connection);
        
int result = cmd.ExecuteNonQuery();
        
return result;
    }

 

 

public  int ExecuteCommand(string sql, params SqlParameter[] values)
    {
        OleDbCommand cmd 
= new OleDbCommand(sql, Connection);
        cmd.Parameters.AddRange(values);
        
return cmd.ExecuteNonQuery();
    }

 

 

public  int GetScalar(string safeSql)
    {
        OleDbCommand cmd 
= new OleDbCommand(safeSql, Connection);
        
int result = Convert.ToInt32(cmd.ExecuteScalar());
        
return result;
    }

 

 

public  int GetScalar(string sql, SqlParameter[] values)
    {
        OleDbCommand cmd 
= new OleDbCommand(sql, Connection);
        cmd.Parameters.AddRange(values);
        
int result = Convert.ToInt32(cmd.ExecuteScalar());
        
return result;
    }

 

 

public  OleDbDataReader GetReader(string safeSql)
    {
        OleDbCommand cmd 
= new OleDbCommand(safeSql, Connection);
        OleDbDataReader reader 
= cmd.ExecuteReader();
        
return reader;
    }

 

 

public  OleDbDataReader GetReader(string sql, SqlParameter[] values)
    {
        OleDbCommand cmd 
= new OleDbCommand(sql, Connection);
        cmd.Parameters.AddRange(values);
        OleDbDataReader reader 
= cmd.ExecuteReader();
        
return reader;
    }

 

 

public  DataTable GetDataSet(string safeSql)
    {
        DataSet ds 
= new DataSet();
        OleDbCommand cmd 
= new OleDbCommand(safeSql, Connection);
        OleDbDataAdapter da 
= new OleDbDataAdapter(cmd);
        da.Fill(ds);
        
return ds.Tables[0];
    }

 

 

public  DataTable GetDataSet(string sql, SqlParameter[] values)
    {
        DataSet ds 
= new DataSet();
        OleDbCommand cmd 
= new OleDbCommand(sql, Connection);
        cmd.Parameters.AddRange(values);
        OleDbDataAdapter da 
= new OleDbDataAdapter(cmd);
        da.Fill(ds);
        
return ds.Tables[0];
    }

 


}

 

用法:

protected string BindDrName(string srk) //收款人 销售员
    {
        
if (Session["shopid"== null)
            Response.Redirect(
"MemberLogin.aspx");
        
string myshopDB = Session["shopid"].ToString();

 

 

string asafilepath = System.Web.HttpContext.Current.Server.MapPath("~/App_Data/" + myshopDB + ".asa");
        AccessDBHelper acc 
= new AccessDBHelper(asafilepath);
        
string sql = "select * from dr where dr_hm='" + srk +"'";
        DataTable dt 
= acc.GetDataSet(sql);
        
string drname = "";
        
foreach (DataRow item in dt.Rows)
        {
            drname 
= item["dr_name"].ToString();
        }
        
return drname;
    }