Por fegasu , Jueves 24 de noviembre de 2005 a las 12:41
Un ejemplo de como conectarse a una base de datos sqlite de c#
using System;
using System.IO;
using Finisar.SQLite;
namespace WindowsApplication3{
///
/// Summary description for Class1.
///
class Class1
{
///
/// The main entry point for the application.
///
///
static SQLiteCommand sqlite_cmd;
static SQLiteDataReader sqlite_datareader;
static void ConnectionLite()
{
Finisar.SQLite.SQLiteConnection cn = new SQLiteConnection("Data Source=base.db");
try
{
cn.Open();
sqlite_cmd = cn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM usuarios";
sqlite_datareader=sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
System.Console.WriteLine( sqlite_datareader["nombre"] );
System.Console.WriteLine( sqlite_datareader.GetString(0) );
}
//cn.CreateCommand()
}
catch(Exception ex)
{
System.Console.WriteLine(ex.Message.ToString());
}
cn.Close();
}
[STAThread]
static void Main(string[] args)
{
//
// TODO: Add code to start application here
//
ConnectionLite();
System.Console.ReadLine();
}
}
}