/// <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)); }