public System.Data.DataSet GetSchema(string sql) { System.Data.DataSet ds = new System.Data.DataSet(); SQLiteDataAdapter dadapter = new SQLiteDataAdapter(); dadapter.SelectCommand = new SQLiteCommand(sql, _Conn); dadapter.SelectCommand.CommandTimeout = _CommandTimeOut; dadapter.FillSchema(ds, SchemaType.Mapped); return(ds); }
public System.Data.DataSet ExecuteReader(string sql) { System.Data.DataSet ds = new System.Data.DataSet(); SQLiteDataAdapter dadapter = new SQLiteDataAdapter(); dadapter.SelectCommand = new SQLiteCommand(sql, _Conn); dadapter.SelectCommand.CommandTimeout = _CommandTimeOut; dadapter.Fill(ds); foreach (System.Data.DataTable table in ds.Tables) { foreach (System.Data.DataColumn col in table.Columns) { if (col.ColumnName.StartsWith("[") && col.ColumnName.EndsWith("]")) { col.ColumnName = col.ColumnName.Substring(1, col.ColumnName.Length - 2); } } } return(ds); }