public DataTable GetDataTable(string commandText, CommandType commandType, IDbDataParameter[] parameters = null) { using (var connection = database.CreateConnection()) { connection.Open(); using (var command = database.CreateCommand(commandText, commandType, connection)) { if (parameters != null) { foreach (var parameter in parameters) { command.Parameters.Add(parameter); } } var dataset = new DataSet(); var dataAdaper = database.CreateAdapter(command); dataAdaper.Fill(dataset); command.Parameters.Clear(); //parameters. return(dataset.Tables[0]); } } }
/// <summary> /// Select data from database /// </summary> /// <param name="commandText"></param> /// <returns></returns> public DataTable SelectData(string commandText) { try { using (var connection = _database.CreateConnection()) { connection.Open(); using (var command = _database.CreateCommand(commandText, CommandType.Text, connection)) { var dataset = new DataSet(); var dataAdaper = _database.CreateAdapter(command); dataAdaper.Fill(dataset); CloseConnection(connection); if (dataset.Tables.Count > 0) { return(dataset.Tables[0]); } else { return(new DataTable()); } } } } catch (SqlException e) { throw new SqlCommandException(e.Message, commandText); } }
public DataTable GetDataTable(string commandText, CommandType commandType, int commandTimeout, List <IDbDataParameter> parameters = null) { using (var connection = _database.CreateConnection()) { connection.Open(); using (var command = _database.CreateCommand(commandText, commandType, connection, commandTimeout)) { if (parameters != null) { foreach (var parameter in parameters) { command.Parameters.Add(parameter); } } var dataset = new DataSet(); var dataAdaper = _database.CreateAdapter(command); dataAdaper.Fill(dataset); return(dataset.Tables[0]); } } }