using System;
using System.Text;
using System.Data.SQLite;
using System.Data;
using System.Windows.Forms;
 
namespace MioP
{
        class ConnessioneDatabaseStato
        {

        public static string DbPath = "C:\\Documents and Settings\\Luca\\Documenti\\Visual Studio 2005 
\\Projects\\MioP\\MioP\\database\\Stato.db;";
        public static string DBSOURCE = "Data Source=" + DbPath + "Version = 3;";

         public ConnessioneDatabaseStato() { }




  public void inserisciStato(string stato)
 {
        SQLiteConnection connessione;
       StringBuilder sql = new StringBuilder("INSERT INTO Stati VALUES( '" + stato + "')");

      using (connessione = new SQLiteConnection())
     {
         try
        { 
             connessione.ConnectionString = ConnessioneDatabaseStato.DBSOURCE;
             connessione.Open();
             using (SQLiteCommand command = new SQLiteCommand(connessione))
            {
                 command.CommandText = sql.ToString();
                 command.ExecuteNonQuery();
            }
        }
          catch (Exception e) { MessageBox.Show(e.ToString()); }
    }
  }
}
}