private CStringer ExecuteReaderC(string connection, string query) { DataTable dt = new DataTable(); CStringer result = new CStringer(); try { SQLiteConnection cnn = new SQLiteConnection(connection); cnn.Open(); SQLiteCommand mycommand = new SQLiteCommand(query, cnn); SQLiteDataReader reader = mycommand.ExecuteReader(); dt.Load(reader); reader.Close(); cnn.Close(); foreach (DataColumn x in dt.Columns) foreach (DataRow row in dt.Rows) if ((row[x.ColumnName] != System.DBNull.Value)) result.Add((string)row[x.ColumnName].ToString()); } catch (SQLiteException e) { MessageBox.Show(e.Message); } return result; }
public CStringer ReadStringer() { CStringer result = new CStringer(); XmlReaderSettings xmlsettings = new XmlReaderSettings(); xmlsettings.ConformanceLevel = ConformanceLevel.Fragment; xmlsettings.IgnoreWhitespace = true; xmlsettings.IgnoreComments = true; XmlNode xNode; XmlDocument xmlDoc = new XmlDocument(); try { XmlReader reader = XmlReader.Create(xmlPath + xmlfilename, xmlsettings); xmlDoc.Load(reader); reader.Close(); } catch (XmlException xe) { LogException(xe.Message); } xNode = xmlDoc.SelectSingleNode("Config"); foreach (XmlNode x in xNode.ChildNodes) result.Add(x.InnerText); return result; }