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