/// <summary>
///
/// </summary>
/// <param name="connection_string"></param>
/// <param name="command_text"></param>
/// <returns></returns>
public DataSet SelectDeltaSet(string connection_string, string command_text)
{
var _result = new DataSet();
var _dbc = new MsDatCommand(command_text);
_result = MsSqlHelper.SelectDataSet(connection_string, CommandType.Text, command_text, _dbc.Name);
return(_result);
}
public DataSet SelectDataSet(string connection_string, MsDatCommands db_commands)
{
var _result = new DataSet();
using (SqlConnection _sqlconn = new SqlConnection(connection_string))
{
_sqlconn.Open();
foreach (MsDatCommand _dbc in db_commands)
{
_result.Merge(MsSqlHelper.SelectDataSet(_sqlconn, CommandType.Text, _dbc.Text, _dbc.Name));
}
}
return(_result);
}
public DataSet SelectDataSet(string connection_string, string command_text, MsDatParameters db_params)
{
MsDatCommand _dbc = new MsDatCommand(command_text);
return(MsSqlHelper.SelectDataSet(connection_string, CommandType.Text, command_text, _dbc.Name, (SqlParameter[])db_params));
}
//-----------------------------------------------------------------------------------------------------------------------------
/// SelectDataSet
//-----------------------------------------------------------------------------------------------------------------------------
public DataSet SelectDataSet(string connection_string, string command_text)
{
MsDatCommand _dbc = new MsDatCommand(command_text);
return(MsSqlHelper.SelectDataSet(connection_string, CommandType.Text, command_text, _dbc.Name));
}
