谁有 .NET 2005 数据库操作封装类方面的资料啊?? 谁有 .NET 2005 数据库操作封装类方面的资料啊?? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 什么样的封装?如果你的项目足够大,看一下企业库http://www.microsoft.com/downloads/details.aspx?FamilyID=5A14E870-406B-4F2A-B723-97BA84AE80B5&displaylang=en或者无穷多的O/R映射http://weblogs.asp.net/yreynhout/archive/2003/10/07/30798.aspx 我们自己做的一个 简单的功能基本可以实现 不知道这样算不算!using System;using System.Data;using System.Data.SqlClient;using System.Data.Common;namespace Yisai.RealEstate.YSSystem.YSData{ public class General { private SqlConnection con; private string connectionString; public General() { //connectionString = con_str; connectionString = "user id=;password=;server=;initial catalog="; } public DataRow ExecuteSQLReturnSingleRow(SqlCommand command) { DataSet dataSet; SqlDataAdapter adapter; if (con == null) MakeConnection(); command.Connection = con; Console.WriteLine(command.CommandText); dataSet = new DataSet(); adapter = new SqlDataAdapter(command); adapter.Fill(dataSet); if (dataSet.Tables[0].Rows.Count != 0) return dataSet.Tables[0].Rows[0]; else return null; } public DataSet ExecuteSQLReturnDataSet(SqlCommand command) { DataSet dataSet; SqlDataAdapter adapter; if (con == null) MakeConnection(); command.Connection = con; dataSet = new DataSet(); adapter = new SqlDataAdapter(command); adapter.Fill(dataSet); return dataSet; } public void ExecuteSQLNoQuery(SqlCommand command) { SqlTransaction transaction = null; try { if (con == null) MakeConnection(); con.Open(); command.Connection = con; transaction = con.BeginTransaction(); command.Transaction = transaction; command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw e; } finally { if (con.State == ConnectionState.Open) con.Close(); } } private void MakeConnection() { con = new SqlConnection(connectionString); } }} 楼上的,你这样封装对.NET 2005 适用吗?2005和2003好像不一样呀 求实现平台冻结用户的某个权限的思路。 AspNetPager 分页产生垃圾代码 asp.net aspx页面 变量 静态页面html如何引用aspx页面(除了iframe) 关于AjaxControlToolkit的安装 我已经配置了IIS的虚拟目录,为什么访问不了.ASPX文件?但确实找到文件了,就是浏览器一片空白,没有反应。 缓存的问题 穷困潦倒,连烂手机都没别人偷走了,哎!!!!! 散分 两个初学问题,请进: 请教一个简单的问题 动态生成的RadioButtonList不显示 服务里world wide web publishing服务无法启动,急!
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;namespace Yisai.RealEstate.YSSystem.YSData
{
public class General
{
private SqlConnection con;
private string connectionString;
public General()
{
//connectionString = con_str;
connectionString = "user id=;password=;server=;initial catalog=";
}
public DataRow ExecuteSQLReturnSingleRow(SqlCommand command)
{
DataSet dataSet;
SqlDataAdapter adapter;
if (con == null)
MakeConnection();
command.Connection = con;
Console.WriteLine(command.CommandText);
dataSet = new DataSet();
adapter = new SqlDataAdapter(command);
adapter.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count != 0)
return dataSet.Tables[0].Rows[0];
else
return null;
}
public DataSet ExecuteSQLReturnDataSet(SqlCommand command)
{
DataSet dataSet;
SqlDataAdapter adapter;
if (con == null)
MakeConnection();
command.Connection = con;
dataSet = new DataSet();
adapter = new SqlDataAdapter(command);
adapter.Fill(dataSet);
return dataSet;
}
public void ExecuteSQLNoQuery(SqlCommand command)
{
SqlTransaction transaction = null;
try
{
if (con == null)
MakeConnection();
con.Open();
command.Connection = con;
transaction = con.BeginTransaction();
command.Transaction = transaction;
command.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw e;
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}
}
private void MakeConnection()
{
con = new SqlConnection(connectionString);
}
}
}