dataaccess.cs

来自「基于C#语言的一个教务网数据库系统开发案例的源代码 ,很实用哦」· CS 代码 · 共 87 行

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
/// <summary>
/// DataAccess 的摘要说明
/// </summary>
namespace sms
{
    public class DataAccess
    {
        private OleDbConnection ConnString;
        public DataAccess()
        {
        }
        public OleDbConnection GetConn()
        {
            string strOleConn = System.Configuration.ConfigurationManager.AppSettings["conn"];
            ConnString = new OleDbConnection(strOleConn);
            return ConnString;
        }
        public OleDbDataReader GetDatareader(string strSql)
        {
            ConnString = GetConn();
            ConnString.Open();
            try
            {
                OleDbCommand OleCmd = new OleDbCommand(strSql, ConnString);
                OleDbDataReader OleDr = OleCmd.ExecuteReader();
                return OleDr;
            }
            finally
            {
                ConnString.Close();
            }
        }
        public DataTable CreateDatatable(string strSql)
        {
            ConnString = GetConn();
            ConnString.Open();
            try
            {
                DataSet ds = new DataSet();
                OleDbDataAdapter OleDa = new OleDbDataAdapter(strSql, ConnString);
                OleDa.Fill(ds);
                DataTable dt = new DataTable();
                dt = ds.Tables[0];
                return dt;
            }
            finally
            {
                ConnString.Close();
            }
        }
        public bool ExecSql(string strSql)
        {
            ConnString = GetConn();
            OleDbCommand OleCmd = new OleDbCommand(strSql, ConnString);
            ConnString.Open();
            try
            {
                if (OleCmd.ExecuteNonQuery() > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch
            {
                return false;
            }
            finally
            {
                ConnString.Close();
            }
        }
    }
}