in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » SELECT (RSS)

Browse by Tags

  • How to read related data from 2 tables into an aggregated collection?

    Hello, I have 2 methods. Both work fine for its own... What I want is to retrieve with SQLite the SchoolclassCodeID from every pupil with the current SchoolclassCode and its SchoolclassCodeID property. In the end I want to return a ObservableCollection where each SchoolclassCode object has 1 ObservableCollection...
    Posted to How To (Forum) by Eluim on 07-18-2010

  • Problem reading join tables

    Hi everyone, I have two tables that I want to join. This is my C# code: private static void readTable() { SQLiteConnection cn = null ; try { cn = new SQLiteConnection (Connessione); cn.Open(); SQLiteCommand cmd = cn.CreateCommand(); cmd.CommandText = "SELECT * FROM OB_Stops INNER JOIN OB_StopDetails...
    Posted to How To (Forum) by jam1982 on 08-21-2009

  • More Problems With String to Date Conversion For SELECT Query

    I am taking data from two dBase files and merging the individual records with a date record for insertion into a SQLite db. All the fields in the dBase files are string format. I build the database using a parameterized insert as shown below: Dim BaseInsertCommand As String = "INSERT INTO MEMBERS...
    Posted to How To (Forum) by rkulp on 03-12-2009
Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems