[阅读: 671] 2007-02-14 18:47:35
[code=c#]
using System;
using System.Data;
using System.Data.SqlClient;
namespace Nox.Common.Data
{
///
/// Summary description for SqlDataProvider.
///
public class SqlDbConnection
{
private string m_ConnectionString;
public SqlDbConnection( string ConnectionString )
{
m_ConnectionString = ConnectionString;
}
public SqlParameter MakeInParam( string ParamName, SqlDbType DbType, int Size, object Value )
{
return SqlHelper.MakeParam( ParamName, DbType, Size, ParameterDirection.Input, Value );
}
public SqlParameter MakeInParam( string ParamName, object Value )
{
return SqlHelper.MakeInParam( ParamName, Value );
}
public DataTable ExecuteDataTable( string sql, params SqlParameter[] p )
{
return SqlHelper.ExecuteDataTable( m_ConnectionString, CommandType.Text, sql, p );
}
public IDataReader ExecuteReader( string sql, params SqlParameter[] p )
{
return SqlHelper.ExecuteReader( m_ConnectionString, CommandType.Text, sql, p );
}
public IDataReader ExecuteReader( CommandType commandType, string sql, params SqlParameter[] commandParameters )
{
return SqlHelper.ExecuteReader( m_ConnectionString, commandType, sql, commandParameters );
}
[Obsolete("此参数更名为 ExecuteDataset，未来版本中，此函数将被删除")]
public DataSet ExecuteDataSet( string sql, params SqlParameter[] p )
{
return ExecuteDataset( sql, p );
}
public DataSet ExecuteDataset( string sql, params SqlParameter[] p )
{
return SqlHelper.ExecuteDataset( m_ConnectionString, CommandType.Text, sql, p );
}
public object ExecuteScalar( string sql, params SqlParameter[] p )
{
return SqlHelper.ExecuteScalar( m_ConnectionString, CommandType.Text, sql, p );
}
public int ExecuteNonQuery( string sql, params SqlParameter[] p )
{
return SqlHelper.ExecuteNonQuery( m_ConnectionString, CommandType.Text, sql, p );
}
}
}
[/code]
Notemper2x 3.1 (￣ε(￣#)
没脾气2x 之 个人综合篇:
http://notemper2x.cndev.org/
我的 panoramio 相册:
http://panoramio.com/user/zhaixudong
我的 flickr相册:
http://www.flickr.com/photos/notemper2x/
QQ号20250出售，售价400,000元整（5位、皇冠80级、VIP7）a
| -ICP -IDC -ISP |