How to write select query for SQLite Virtual Table using SQLiteDataAdapter

See more:

C#

Windows

application

SQLite

Hi Friends,

I have created windows application project using C sharp coding. In my project, i will be importing (.db) files using third party of SQLite . For reading the datas from (.db) file im using SQLiteConnection .

SQLiteConnection dataConnection = new SQLiteConnection();

            dataConnection.DataSource = FilePath;

            dataConnection.Open();

            System.Data.DataTable tableschema = new System.Data.DataTable();
 
            SQLiteDataAdapter daTables = new SQLiteDataAdapter("SELECT * FROM sqlite_master WHERE type='table';", dataConnection);
            daTables.Fill(tableschema);


            foreach (DataRow row in tableschema.Rows)
            {
                string strSheetTableName = row["tbl_name"].ToString();

                string Query = "SELECT * FROM [" + strSheetTableName + "] ;";

                System.Data.DataTable dt = new System.Data.DataTable();
                dt.TableName = strSheetTableName;
                SQLiteDataAdapter daDatas = new SQLiteDataAdapter(Query, dataConnection);
                daDatas.Fill(dt);

                ds.Tables.Add(dt);
            }

The above coding is working properly but i am facing the problem is , if i import (.db) file which contains the Table structure as "Virtual Table" its throughing the error as SQLite error , no such module: rtree. If i open the (.db) file in SQLite Manager means , one table is created in below coding format ,

CREATE VIRTUAL TABLE tablename USING rtree(ROWID, MinimumLatitude, MaximumLatitude, MinimumLongitude, MaximumLongitude)

So can any one suggest me to write a select query for the above virtual table . :)

Thanks in Advance . :)