dataaccess.cs

小型的一个简单的系统开发的实现了简---添加--删除--修改---（vs2005和SQl2005）用到了一些JS脚本

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;

namespace DataAccess
{
    
    public class CDataAccess
    {
        public OleDbConnection Ocoom;
        Excename ex = new Excename();
        public CDataAccess()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            // 
            Ocoom = Link();
        }
        
        public OleDbConnection Link()
        {
            string linkstr = ConfigurationManager.AppSettings["linkstr"];
            return new OleDbConnection(linkstr);

        }
      
        public bool ExecuteQuery(string str)
        {
            try
            {

               
                Ocoom.Open();
                OleDbCommand cmd = new OleDbCommand(str, Ocoom);
                cmd.ExecuteNonQuery();
                Ocoom.Close();
                return true;
            }
            catch (Exception e)
            {

                Excename oErr = new Excename();
                string strErr=oErr.GetErr(0);
                
                return false;
             
            }


        }
    
        public DataTable GetDataTable(string str)
        {
            ////OleDbConnection Ocoom = Link();
            OleDbDataAdapter Odar = new OleDbDataAdapter(str, Ocoom);
            DataSet ds = new DataSet();
            Odar.Fill(ds);

            DataTable dt = new DataTable();
            dt = ds.Tables[0];
            Ocoom.Close();
            return dt;

        }
        public int ExecuteQueryA(string str)
        {
            int i = 0;
            try
            {

                ////OleDbConnection Ocoom = new OleDbConnection("Provider=SQLOLEDB;Data Source=192.168.35.36;database=yy;Uid=sa; pwd=123456");
                ////OleDbConnection Ocoom = Link();
                Ocoom.Open();
                OleDbCommand cmd = new OleDbCommand(str, Ocoom);
                i = cmd.ExecuteNonQuery();
                Ocoom.Close();
                return i;
            }
            catch (Exception )
            {
                return i;
                ex.ExceptionData();
            }


        }

    }

}