Re: [sqlite] SQLite for .NET Framework 4.0

You should ask your question here http://sqlite.phxsoftware.com/forums/ On Thu, Jul 8, 2010 at 9:24 AM, Daniel wrote: > I forgot to say I have Visual Studio 2010 with .NET Framework 4.0 for > programming in C#. > > In VS2008 it worked fine and after changing to Version 2010 it

Re: [sqlite] Help with SQLite and VB2010 Express

You really don't need to run the msi. You can download the binary package and added the dlls as references and start using the dataprovider. In the future, this sort of question should be asked in the System.Data.SQLite forum. On Mon, Jan 10, 2011 at 12:10 PM, Bob Keeland

Re: [sqlite] compiling C program to use the shared library

To use the dll you need to use the LoadLibrary windows function and define pointers to each of the sqlite functions. Here is a short example to get you started. For more on using DLLs try this MSDN link:

Re: [sqlite] PHP Code That Can Store and Retrieve Images

The easiest way to store an image would be to first convert the image to base64 and store the base64 text to the database. Converting data to base64 takes up about 33% more space than the original data. On Tue, Mar 11, 2008 at 6:22 PM, RB Smissaert < [EMAIL PROTECTED]> wrote: > Funny you ask

Re: [sqlite] PHP Code That Can Store and Retrieve Images

Here is a link to the PHP code to generate the base64 string and to convert the string back to an image. http://fundisom.com/phparadise/php/image_handling/base64_image_encode On Wed, Mar 12, 2008 at 8:56 AM, <[EMAIL PROTECTED]> wrote: > I am not actually dealing with images, but normal > text

Re: [sqlite] PHP Code That Can Store and Retrieve Images

Good point Kees. I forgot about the serialize(). I don't used it because I use my sqlite db with PHP, .NET and VB6. But if the project is going to PHP only serialize() is the way to go. On Wed, Mar 12, 2008 at 2:38 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote: > On Wed, 12 Mar 2008 09:10:44 -0400,

Re: [sqlite] Table Adapter Update Question

Try using this library http://sqlite.phxsoftware.com/ It a complete ADO.NET 2 implementation and it should support the update. On Wed, Jun 25, 2008 at 5:14 PM, Richard W. Kulp <[EMAIL PROTECTED]> wrote: > I am trying to convert a VB 2005 program from a SQLExpress database to > SQLite 3. I have

Re: [sqlite] New to SQlite

If you are using the ADO.NET 2.0 provider from http://sqlite.phxsoftware.com/, then it won't work with Visual Studio 2003. This is because Visual Studio 2003 uses .Net 1.1 not .Net 2.0. If you wish to use the phxsoftware data provider try downloading Visual Studio Express 2005 or 2008 from

Re: [sqlite] SQLite Import Tool

I wrote a simple c# command line program that will import data from MSSQL into a sqlite database. You specify a query (for MSSQL), a connection string, the location of the sqlite database file, and a table in the sqlite database and the app dumps the results of the query into the table. You could

Re: [sqlite] SQLite Import Tool

Here is a link to the application and source: http://www.proghack.net/?p=40 On Wed, Nov 12, 2008 at 3:20 PM, Baskaran Selvaraj < [EMAIL PROTECTED]> wrote: > > Thanks roosevelt. I will try to use the c# command. > > > Date: Wed, 12 Nov 2008 15:03:41 -0500> From: > [EMAIL PROTECTED]> To:

Re: [sqlite] Creating sqlite.dll and sqliteclient.dll for .net with sqlite version 3-3.6.7

Here is the link to the .Net data provider for sqlite... http://sqlite.phxsoftware.com/ On Mon, Jan 5, 2009 at 5:39 PM, Dao, Trien (STP) wrote: > I am new to sqlite development community. I need to create or obtain > sqlite.dll and sqliteclient.dll for sqlite version

Re: [sqlite] How to create a Datatable [first steps of newbie]

If you trying to extract data from a sqlite database to a DataTable here is how you do it using the .Net data provider: SQLiteConnection conn = new SQLiteConnection("Data Source=database.db"); conn.Open(); SQLiteDataAdapter apt = new SQLiteDataAdapter("select *

Re: [sqlite] How to create a Datatable [first steps of newbie]

essio Forconi <forco...@gmail.com> wrote: > Thanks... > > I get this error > > "Data Source cannot be empty. Use :memory: to open an in-memory database" > > but the connection is sattamante the same as that used in other parts of > the program > > Ro

Re: [sqlite] How to create a Datatable [first steps of newbie]

dtProclamatori = new DataTable(); > apt.Fill(dtProclamatori); > } > catch (SQLiteException ex) > { > MessageBox.Show(ex.Message); > } > finally > { > conn.Close(); > } > > > I know that there are groups for microsoft c # but that does not seem &g

Re: [sqlite] How to create a Datatable [first steps of newbie]

gt; work, I get that bug that I told you. > > Thanks for your availability. > > Roosevelt Anderson ha scritto: >> What does your connection string look like? >> >> On Fri, Jan 9, 2009 at 2:36 PM, Alessio Forconi <forco...@gmail.com> wrote: >> >>> Than

Re: [sqlite] SQLite (SQ3) Interfacing with SQL Server 2005 Standard Edition.

I made a simple command line app that exports a MSSQL query to a sqlite table. This might not be exactly what you need but it should be in the ballpark. The app and the source can be found here: http://www.proghack.net/?p=40 On Wed, Jun 17, 2009 at 5:25 AM, David Cawley

Re: [sqlite] Sqlite from ASP?

Try this... http://sqlite.phxsoftware.com/ On Sat, Jul 25, 2009 at 11:50 AM, Paul Claessen wrote: > Greetings, > > > > Does anyone have any (simple) examples on how to use sqlite from .ASP scripts > for me? Or C# code, for that matter? > > > > ~ Paul Claessen > > > >

Re: [sqlite] Question about using SQLite3 on Windows Mobile 6+

I'm guessing you are writing this in .NET. If so, you need to use the sqlite ADO.NET provider found here: http://sqlite.phxsoftware.com/ On Sun, Mar 7, 2010 at 7:33 PM, Anthony Papillion wrote: > Hello Everyone, > > I'm totally new to SQLite and am trying to use it in a new

Re: [sqlite] SQLite on Windows with Mono

If you are doing .Net development on both linux and windows I would recommend using the System.Data.SQLite ADO dataprovider found here over http://sqlite.phxsoftware.com/ over the default dataprovider found in Mono. This library will not only work on the Mono platform but will also work in Visual

Re: [sqlite] SQLite and .Net 4.0 configuration

These are questions about System.Data.SQlite data provider and should be asked at their forum found here http://sqlite.phxsoftware.com/forums/ On Thu, Apr 15, 2010 at 7:37 PM, Berryl wrote: > Hi Anyone & Everyone; > > Below is a message I posted on StackOverflow. I am guessing no

Re: [sqlite] C# amalgamation hand holding requested

You can't use the amalgamation directly in C# as the SQLite amalgamation is in C. To use the amalgamation you'd have to compile the code in a separate C/C++ project, create a wrapper class using P/Invoke and then call it from your application. You should use the .NET data provider found here

Re: [sqlite] C# amalgamation hand holding requested

The C# compiler does not compile C. C# and VB.NET get compiled down to bytecode. On Mon, Jan 23, 2012 at 12:56 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Jan 2012, at 4:39pm, Roosevelt Anderson wrote: > >> You can't use the amalgamation directly in C# as the S

Re: [sqlite] C# amalgamation hand holding requested

d not have to worry about the dll hell associated with HP > and Quicken and what not. > > Thanks.  I was getting confused. > > dvn > > > On Mon, Jan 23, 2012 at 2:03 PM, Simon Slavin <slav...@bigfraud.org> wrote: > >> >> On 23 Jan 2012, at 7:39pm, Rooseve

Re: [sqlite] C# amalgamation hand holding requested

perating Unit > > Northrop Grumman Information Systems > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Roosevelt Anderson [roosevelt.ander...@gmail.com] > Sent: Tuesday, January 24, 2012 10:22 AM > To: General Discussion of SQLit