简单的ASP.NET三层架构数据库后台 using System; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace xxxxx ... { public class xxxx ...{ private SqlConnection objSqlConn; private SqlCommand objSqlCmd; private SqlAdapter objSqlAdapter; private SqlTransaction sqlTrans; private bool c_connect; private strint s_connect; public xxx():this(Configuration.AppSettings["xxx"]) ...{ } public xxx(string str) ...{ if(s_connect==null) ...{ s_connect=str; c_connect=true; } this.DataBaseOpen(); } public bool DataBaseOpen() //连接数据库 ...{ if(c_connect) ...{ try ...{ if(objSqlConn==null) ...{ objSqlConn=new SqlConnection(s_connect); objSqlConn.Open(); } if(objSqlCmd==null) ...{ objSqlCmd=new SqlCommand(); } objSqlCmd.Connection=objSqlConn; } catch(SqlExection ex) ...{ return flase; throw ex; } } return true; } public bool Execute(string strSql) //执行数据库操作增删改查 ...{ bool flag; if(!DataBaseOpen()) ...{ throw new Application("没有和数据库建立连接"); } objSqlCmd.CommandType=CommandType.Text; objSqlCmd.CommandText=strSql; try ...{ int index=objSqlCmd.ExecuteNonQuery() if(index==1) ...{ flag=true; } else ...{ flag=false; } } catch(SqlExection ex) ...{ flag=false; throw ex; } return flag; } public void StartTransation() //开始事务 ...{ if (!DataBaseOpen()) ...{ throw(new ApplicationException("没有建立数据库连接。")); } sqlTrans=sqlCn.BeginTransaction(); sqlCmd.Transaction=sqlTrans; } public bool Commit() ...{ if(this.flagEx) ...{ try ...{ sqlTrans.Commit(); //提交事务 } catch(SqlException ex) ...{ sqlTrans.Rollback(); // 回滚事务 return false; } return true; } else ...{ sqlTrans.Rollback(); return false; } } public DataSet GetData(string strSql,string strTable) //数据集 ...{ DataSet ds=new DataSet(); objSqlAdapter=new SqlDataAdapter(strSql,objSqlConn); ds=objSqlAdapter.Fill(ds,strTable); return ds; } public void GetDisponse() //回收 ...{ objSqlCmd.Disponse(); objSqlAdapter.Disponse(); objSqlConn.Disponse(); objSqlCmd=null; objSqlAdapter=null; objSqlConn=null; } }} 还 要前台的一个配置文件App.config 用于写连接数据库字符串 App.config <? xml version = 1.0 encoding = UTF - 8 > < configuration > < appSettings > < add key = " xxx " value = " Data Source=主机;Initial Catalog=数据库名称;uid=x;pwd=x " > </ add > </ appSettings > </ configuration > key="xxx"于后台Configuration.AppSettings["xxx"] xxx要相同了.