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