public static DataTable FSquery(string queryST, ref string retErr) { DataTable resultsDT = new DataTable("resultsDT"); try { // Instantiate the LogQuery object LogQuery oLogQuery = new LogQuery(); // Instantiate the File System Input Format object FileSystemInputFormat oFSInputFormat = new MSUtil.COMFileSystemInputContextClassClass(); // Execute the query LogRecordSet oRecordSet = oLogQuery.Execute(queryST, oFSInputFormat); int i = 0; for (; i < oRecordSet.getColumnCount(); i++) { string colnm; colnm = oRecordSet.getColumnName(i); resultsDT.Columns.Add(new DataColumn(colnm, typeof(string))); } for (; !oRecordSet.atEnd(); oRecordSet.moveNext()) { MSUtil.ILogRecord rowLP = null; rowLP = oRecordSet.getRecord(); DataRow dr = resultsDT.NewRow(); for (int ct = 0; ct < i; ct++) { dr[ct] = rowLP.getValue(ct); } resultsDT.Rows.Add(dr); } // Close the recordset oRecordSet.close(); } catch (Exception exc) { retErr = "Unexpected error: " + exc.Message; } return(resultsDT); }
public static DataTable FSquery(string queryST, ref string retErr) { DataTable resultsDT = new DataTable("resultsDT"); try { // Instantiate the LogQuery object LogQuery oLogQuery = new LogQuery(); // Instantiate the File System Input Format object FileSystemInputFormat oFSInputFormat = new MSUtil.COMFileSystemInputContextClassClass(); // Execute the query LogRecordSet oRecordSet = oLogQuery.Execute(queryST, oFSInputFormat); int i = 0; for (; i < oRecordSet.getColumnCount(); i++) { string colnm; colnm = oRecordSet.getColumnName(i); resultsDT.Columns.Add(new DataColumn(colnm, typeof(string))); } for (; !oRecordSet.atEnd(); oRecordSet.moveNext()) { MSUtil.ILogRecord rowLP = null; rowLP = oRecordSet.getRecord(); DataRow dr = resultsDT.NewRow(); for (int ct = 0; ct < i; ct++) { dr[ct] = rowLP.getValue(ct); } resultsDT.Rows.Add(dr); } // Close the recordset oRecordSet.close(); } catch (Exception exc) { retErr = "Unexpected error: " + exc.Message; } return resultsDT; }