in

System.Data.SQLite

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

Browse by Tags

  • .Net 4.0 & SQLite 1007000 sample

    I created a .net 4.0 WinForm appi with SQLite embedded and want to share the source code.. So here it is [ MyBlog ] [ Code Project ] So have fun and enjoy...
    Posted to How To (Forum) by Kribo on 05-02-2011

  • 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

  • Problems in insert and retriving dates

    I am new user of sqlite I have the following table CREATE TABLE Sighting ( SightingId integer PRIMARY KEY AUTOINCREMENT NOT NULL, SpeciesId integer, LocationId integer, SightingDate date, Note nvarchar(100) ); and the following insert INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note) VALUES...
    Posted to How To (Forum) by Prachi on 09-11-2009

  • 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

  • C#.net Beginner's Code

    I'm trying to have a generic function for SQL queries with the output being a datareader. I'm getting a database locked error when running my code though, so I put a dbconn.close before my return but then I get an error saying the connection is closed and so the data no longer is in the reader...
    Posted to How To (Forum) by gwar3k1 on 06-21-2009
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems