/// <summary>
/// Disposes any resources that have been created.
/// </summary>
public void Dispose()
{
if (_dataAdapter != null)
{
_dataAdapter.Dispose();
}
if (_commandBuilder != null)
{
_commandBuilder.Dispose();
}
if (_selectCommand != null)
{
_selectCommand.Dispose();
}
if (_insertCommand != null)
{
_insertCommand.Dispose();
}
if (_updateCommand != null)
{
_updateCommand.Dispose();
}
if (_deleteCommand != null)
{
_deleteCommand.Dispose();
}
}
/// <summary>
/// ����DataSet--���ط�����
/// </summary>
/// <param name="sql">SQL�����ߴ洢����</param>
/// <param name="startindex">��ʼ��</param>
/// <param name="num">������</param>
/// <param name="dataname">�������</param>
/// <returns>DataSet</returns>
public DataSet ExecuteDataSet(string sql, int startindex, int num, string dataname)
{
DataSet MyDataSet = new DataSet();
IsStoredProcedure(sql);
MyDataAdapter = MyFactory.CreateDataAdapter();
MyDataAdapter.SelectCommand = MyCommand;
try
{
Open();
MyDataAdapter.Fill(MyDataSet, startindex, num, dataname);
MyDataAdapter.Dispose();
return MyDataSet;
}
finally
{
Dispose();
}
}
/// <summary>
/// 返回DataSet--重载方法三
/// </summary>
/// <param name="sql">SQL语句或者存储过程</param>
/// <param name="startindex">开始行</param>
/// <param name="num">总行数</param>
/// <param name="dataname">虚拟表名</param>
/// <returns>DataSet</returns>
public DataSet ExecuteDataSet(string sql, int startindex, int num, string dataname)
{
DataSet ds = new DataSet();
IsStoredProcedure(sql);
dbDataAdapter = dbProviderFactory.CreateDataAdapter();
dbDataAdapter.SelectCommand = dbCommand;
dbDataAdapter.Fill(ds, startindex, num, dataname);
dbDataAdapter.Dispose();
m_querycount++;
return ds;
}
