100分求一个常用的对数据库操作的类

Question

微软的Data Access Application Block
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp

Answer 1

http://spaces.msn.com/members/cobrastudio/偶在WEB设计中的一个IAdoNetBuilder接口的实际和实现。

Answer 2

http://dev.csdn.net/article/61/61208.shtm

Answer 3

http://dev.csdn.net/develop/article/61/61208.shtm

Answer 4

this's the chinese document of SqlHelper
http://www.hidotnet.com/documents/sqlhelper/

Answer 5

微软的Data Access Application Block
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp

Answer 6

对呀
 微软的SQLHelper就很好！！！

Answer 7

微软的SQLHelper这个怎么样啊???

Answer 8

微软的SQLHelper怎么用呀,怎么加载??????????????????????

Answer 9

Data Access Application Block，数据访问模块
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp

Answer 10

private void OpenOracleDataBase()
        {
            string strConn="ORACLE_CONNECTIONSTRING" value="Data Source=dlq;User Id=scott;Password=tiger;Max Pool Size = 512";
            OracleConn=new OracleConnection(strConn);
            OracleConn.Open();
        }
        private void CloseOracleDataBase()
        {
            OracleConn.Close();
        }
        private void DisplayEmp()
        {
            OpenOracleDataBase();
            string strSql="select empno as 员工编号,ename as 姓名,job as 工作 from emp";
            OracleCommand ocomm=new OracleCommand(strSql,OracleConn);
            DataGrid1.DataSource=ocomm.ExecuteReader();
            DataGrid1.DataBind();
            CloseOracleDataBase();
        }        private void OracleData(string strSql)
        {
            OpenOracleDataBase();
            OracleCommand OracleCmd=new OracleCommand("",OracleConn);
            OracleCmd.CommandText=strSql;
            OracleCmd.ExecuteNonQuery();
            CloseOracleDataBase();
        }        private void btnAdd_Click(object sender, System.EventArgs e)
        {
            string strInset="insert into emp values(7777,'张三','PG',7789,'23-1月 -82',3500,12,10)";
            OracleData(strInset);
        }        private void btnNew_Click(object sender, System.EventArgs e)
        {
            DisplayEmp();
        }        private void btnDelete_Click(object sender, System.EventArgs e)
        {
            string strDelete="delete emp where empno=7777";
            OracleData(strDelete);
        }        private void btnUpDate_Click(object sender, System.EventArgs e)
        {
            string strUpDate="update emp set ename='张三' where empno=7777";
            OracleData(strUpDate);
        }        private void btnQuery_Click(object sender, System.EventArgs e)
        {
            OracleDataReader odrTemp;
            OpenOracleDataBase();
            OracleCommand ocmdTemp=new OracleCommand("select ename from emp where empno="+Convert.ToInt32(txtID.Text.Trim())+"",OracleConn);
            odrTemp=ocmdTemp.ExecuteReader();
            while(odrTemp.Read())
            {
                txtName.Text=odrTemp.GetString(0);
            }
            CloseOracleDataBase();
        }

Answer 11

我也想要  [email protected]