After installing "Visual Studio Express 2012 for Windows Desktop", I
downloaded and ran "Setups for 32-bit Windows (.Net Framework 4.5)
bundle 1.0.84.0".
I left the default option checked "Generate native images for the
assemblies and install the images in the native image cache", and
didn't check the other option ("Install the assemblied into the global
assembly cache" + "Install the designer components for Visual Studio
2012") since the design-time component is no longer supported for
Express editions.
Next, I created a new Windows Forms project, and tried adding a
reference to SQLite, but it wasn't listed in Assemblies >
Framework/Extension. So I tried running SQLite's installer.exe:
"Cannot continue, the "confirm" option is not enabled"
So, I used Project > Add Reference, hit "Browse", and pointed to
"System.Data.SQLite.DLL". Seemed OK.
Next, I ran the the following code, which worked OK:
=============
Dim SQLconnect As New SQLite.SQLiteConnection()
SQLconnect.ConnectionString = "Data
Source=c:\users\joe\test.sqlite;"
SQLconnect.Open()
SQLconnect.Close()
=============
Finally, I tried this code:
=============
Dim SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
SQLconnect.ConnectionString = "Data
Source=c:\users\fred\test.sqlite;"
SQLconnect.Open()
SQLcommand = SQLconnect.CreateCommand
SQLcommand.CommandText = "INSERT INTO Item (type) VALUES
('something')"
SQLcommand.ExecuteNonQuery()
SQLcommand.Dispose()
SQLconnect.Close()
=============
but it fails on the second line with "Type SQLiteCommand is not
defined". Is there another component I need to install?
Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
