in

System.Data.SQLite

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

Browse by Tags

  • How to Add a new Property in a Entity?

    How to add a property to an entity that is not mapped to the DB. Ex: The entity Person has 2 properties extrapolated from the structure of the DB. The ID, which is the primary key, and Name. I must add a third property, which will be valued in a second time during program execution. If I add a scalar...
    Posted to How To (Forum) by abramo on 10-06-2011

  • Re: How to Insert Blob Image to SQLite in C#

    Hi there, After reading the forum ran into your question and decided to take it up as a small project and thus writing an article. I created a WinForm appi based on C# - .NET4.0 - System.Data.SQLite 1007000 (.net provider) with an embedded SQLite database. And I want to share the source code.. So here...
    Posted to How To (Forum) by Kribo on 05-15-2011

  • .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

  • Data Grid filling using SQLite

    I'm new to dataGrid filling by database . I've implemented to fill my datagrid with datas from a TABLE. But know I want to have a search text box, so I can search through my database and show only record that match string. Example my TABLE: CREATE TABLE [DAUSACH] ( [MaSach] INTEGER NOT NULL PRIMARY...
    Posted to How To (Forum) by nXqd on 06-23-2010

  • sqlite and Installshield 2009

    I'm having trouble to built a setup file in VS2008. Warning Message -6248 VS2008 can't find the file system.data.sqlite.dll and also not it's dependencies. When I run the setup on my computer everything works fine, but on other computer, the sqlite file is missing. Anyone has similar experiences...
    Posted to How To (Forum) by Tom on 10-06-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 (7 items)
Powered by Community Server (Commercial Edition), by Telligent Systems