2007-03-12 Marek Habersack <mhabersack@novell.com>

[mono.git] / web / sqlite

diff --git a/web/sqlite b/web/sqlite
index 5952bbfe789cca6a0d11787e672b2f005cbb2774..8c866571c4eca8f2c8d2f89e87849370ba1df891 100755 (executable)
--- a/web/sqlite
+++ b/web/sqlite
@@ -16,7 +16,7 @@
        library reads and writes directly to and from the database files on disk.</li>\r
 
        <li>SQL Lite can be downloaded 
-       from <a href"http://www.hwaci.com/sw/sqlite/download.html">here</a>.
+       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>
 
@@ -25,7 +25,7 @@
        <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>
+       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
@@ -82,7 +82,7 @@
     {
        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
@@ -97,8 +97,8 @@
        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);
        }