in

System.Data.SQLite

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

Browse by Tags

  • Help: Database optimization

    I'm new to SQLite, but have been working with SQL Server and mySQL for several years so I'm not entirely blind on this. Trying to figure out how to cut down on the execution time of a query. Situation is I have a relatively simple table, with three fields: id (integer, primary key), hash (text...
    Posted to How To (Forum) by MRTrevorF on 05-13-2010

  • Questions from novice getting aquainted with sqlite

    Hi, I have decided to rewrite an Access db I wrote several years ago into C# using system.data.sqlite. Other than the Access db and its light VBA coding, my only experience is a C++ class I took a few years ago in college. So, I'm really a beginner, and will have to learn as I go. I came here to...
    Posted to General (Forum) by hamyer on 03-15-2010

  • Basic help - select query result...

    Hi, I'm a newbiz in sqlite (and in C#)... and I try to find an answer on google and this fourm before posting. Since some months (when I have time) I try to learn C#. I give myself a goal to learn the language : write a text gui game, I was thinking that a database would be too heavy to manipulate...
    Posted to How To (Forum) by nicodevil on 03-08-2010

  • How to retrieve the last autoincremented ID from a table when using a typed dataset?

    [Noob alert!] I constructed a typed dataset inside VS 2008. I am using the prefabricated datadapters to fill and update its tables. How can I retrieve the last autoincremented ID from a table? I understand that in SQL it is:Select last_insert_rowid(). But how do I call this SQL from C# ADO.Net? Thanks...
    Posted to How To (Forum) by aner on 01-25-2010

  • Visual C++2008 Express

    Does anyone have a good easy to follow tutorial on getting System.Data.SQLite working with Visual C++ 2008 Express (free edition)? I went through the setup.exe, and added the .lib as a reference to the project, but it doesn't seem to recognize the library. Thanks, Bill using System.Data.SQLite; void...
    Posted to How To (Forum) by billgates on 01-17-2010

  • Help Getting Started

    Hi, I am a newbie in regards to System.Data.SQLite and .NET, so bear with me. I can't seem to get System.Data.SQLite even installed correctly. The self-installer completed and everything seemed to be kosher, but nothing seems to be working. In VC# Express, I tried to create a little sample program...
    Posted to How To (Forum) by deftonix on 12-22-2009

  • Insert multiple values in one column that references another's table primary key?

    Hi I'm pretty green when it comes down to db relationships so please don't be mad at me if this is a dumb question, i swear i spent 2 days searching for some way to do this and i can't find anything useful, even on google. I have two very simple tables, each has a primary key and a column...
    Posted to How To (Forum) by r41n on 09-10-2009

  • How to write and read an image into a sqlite database in C#

    Hey All I'm a bit of a newbie to sql. I'm trying to learn how to read and write an image to a sqlite database. Does anyone have any pointers or example code of how to do this? I assume its done by storing the image as an array of blobs, but I have no idea how to do this. Any help would be greatly...
    Posted to How To (Forum) by kwi23 on 07-31-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 (9 items)
Powered by Community Server (Commercial Edition), by Telligent Systems