public DataSet ExecuteDataSet(string query, CommandType commandtype, ConnectionState connectionstate, bool parametroSalida) { SqlDataAdapter adapter = (SqlDataAdapter)objFactory.CreateDataAdapter(); objCommand.CommandText = query; objCommand.CommandType = commandtype; adapter.SelectCommand = objCommand; DataSet ds = new DataSet(); try { adapter.Fill(ds); } catch (Exception ex) { this.ClearParameter(); HandleExceptions(ex); } finally { if (!parametroSalida) { objCommand.Parameters.Clear(); } //else if (connectionstate == ConnectionState.CloseOnExit) { if (objConnection.State == System.Data.ConnectionState.Open) { objConnection.Close(); } } } return(ds); }