/// <summary> /// getQueryAstTable : run a query and return a data table /// </summary> /// <param name="query"></param> /// <param name="table"></param> /// <returns></returns> public Boolean getQueryAsTable(String query, ref DataTable table) { try { lock (_syncCall) { UniXML ux = _sess.CreateUniXML(); String cmd = query; ux.GenerateXML(cmd); DataSet ds = ux.GetDataSet(); table = ds.Tables[0]; } } catch (Exception ex) { ShowError(ex.Message); return(false); } return(true); }
/// <summary> /// getPublishersAsTable : get a data table of publisher keys and names /// </summary> /// <remarks> /// See above. /// </remarks> /// <param name="publishers"></param> /// <returns></returns> public Boolean getPublishersAsTable(ref DataTable publishers) { try { lock (_syncCall) { UniXML ux = _sess.CreateUniXML(); String cmd = BookConst.SEL_PUBLISHERS_QUERY; ux.GenerateXML(cmd); DataSet ds = ux.GetDataSet(); publishers = ds.Tables[0]; } } catch (Exception ex) { ShowError(ex.Message); return(false); } return(true); }