[阅读: 721] 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]
| -ICP -IDC -ISP |