X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=web%2Fsqlite;h=8c866571c4eca8f2c8d2f89e87849370ba1df891;hb=db8116754634a1a90ee723acaea36bfaddf1c84e;hp=85b35c997aa708f627ba4615c9fcef169fd425c0;hpb=c40860f8f6073bf2e89beb08857b7e5b1cfb39bc;p=mono.git

diff --git a/web/sqlite b/web/sqlite
index 85b35c997aa..8c866571c4e 100755
--- a/web/sqlite
+++ b/web/sqlite
@@ -1,13 +1,38 @@
 * SQL Lite Data Provider
 
 <ul>
+	<li>ADO.NET Data Provider for 
+	the <a href"http://www.hwaci.com/sw/sqlite/">SQL Lite</a> which 
+	is an embeddable SQL database engine</li>
+
+	<li>From the SQL Lite web page: SQLite is a C library that 
+	implements an embeddable SQL database engine. Programs that link with 
+	the SQLite library can have SQL database access without 
+	running a separate RDBMS process. The distribution 
+	comes with a standalone command-line access program (sqlite) that 
+	can be used to administer an SQLite database and which serves 
+	as an example of how to use the SQLite library.  SQLite is not a client library 
+	used to connect to a big database server. SQLite is the server. The SQLite 
+	library reads and writes directly to and from the database files on disk.</li>
+
+	<li>SQL Lite can be downloaded 
+	from <a href="http://www.hwaci.com/sw/sqlite/download.html">here</a>.
+	binaries exist for Linux and Windows.  sqlite.dll on Windows 
+	and sqlite.so on Linux.  The source code is available too.</li>
+
 	<li>Exists in namespace and assembly Mono.Data.SqliteClient</li>
 	
-	<li>Created by Vladimir Vukicevic</li>
-	
-	<li><a href"http://www.hwaci.com/sw/sqlite/download.html">SQL Lite</a>
-	binaries exist for Linux and Windows.  sqlite.dll on Windows 
-	and sqlite.so on Linux.</li>
+	<li>Created by Vladimir Vukicevic so he could have a database of
+	thumbnail images for mPhoto.  mPhoto is GUI application 
+	for cataloging images.  mPhoto runs on Mono 
+	and uses <a href="http://www.go-mono.com/gtk-sharp.html">GTK#</a> for its GUI.</li>
+
+	<li>Bugs with Mono or the data provider should be reported 
+	in Mono's Bugzilla <a href="http://bugzilla.ximian.com/">here</a>.  If you
+	do not have Bugzilla user account, it is free 
+	and easy to 
+	create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
+		
 </ul>
 
 ** Current Status
@@ -32,14 +57,19 @@
 
 <ul>
 	<li>Have a working mcs and mono</li>
+	
 	<li>Make sure Mono.Data.SqliteClient.dll was built and is installed
 	in the same place as the mono class libraries.</li>
+	
 	<li>If you do not have <a href"http://www.hwaci.com/sw/sqlite/download.html">SQL Lite</a>,
 	download it.  There are binaries for Windows and Linux.</li>
+	
 	<li>There is a test named SqliteTest.cs found at mcs/class/Mono.Data.SqliteTest/Test</li>
+	
 	<li>Has a connection string format of "URI=file:some/path".  For example, 
 	the connection string "URI=file:SqliteTest.db" will use the database file 
 	named SqliteTest.db, if it does not exist, the file will be created.</li>
+	
 	<li>C# Example:
 <pre>
  using System;
@@ -52,7 +82,8 @@
     {
        string connectionString = "URI=file:SqliteTest.db";
        IDbConnection dbcon;
-       dbcon = new MySQLConnection(connectionString);
+       dbcon = new SqliteConnection(connectionString);
+       dbcon.Open();
        IDbCommand dbcmd = dbcon.CreateCommand();
        // requires a table to be created named employee
        // with columns firstname and lastname
@@ -63,11 +94,11 @@
        string sql = 
           "SELECT firstname, lastname " + 
           "FROM employee";
-       dbcmd.ConnectionString = sql;
+       dbcmd.CommandText = sql;
        IDataReader reader = dbcmd.ExecuteReader();
        while(reader.Read()) {
-            string FirstName = reader[0];
-            string LastName = reader[1];
+            string FirstName = (string) reader[0];
+            string LastName = (string) reader[1];
             Console.WriteLine("Name: " + 
                 FirstName + " " + LastName);
        }