????1?????Add References????SQLite ADO .NET???????bin???μ?System.Data.SQLite.DLL??
????2?????????????????????????0???????????????IO??????????????
????System.Data.SQLite.SQLiteConnection.CreateFile(datasource);
????3???????????
????System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(connectionString);
????connectionString?а????????????Щ?????????????????????????????????????????????System.Data.SQLite.SQLiteConnectionStringBuilder??????????connectionString
????4??????????????????Access??MS SQL???????????

 

//???????????????
string datasource="h:/test.db";
System.Data.SQLite.SQLiteConnection.CreateFile(datasource);
//?????????
System.Data.SQLite.SQLiteConnection conn =
new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteConnectionStringBuilder connstr =
new System.Data.SQLite.SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;
connstr.Password = "admin";//????????SQLite ADO.NET????????????????
conn.ConnectionString = connstr.ToString();
conn.Open();
//??????
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
string sql = "CREATE TABLE test(username varchar(20)??password varchar(20))";
cmd.CommandText=sql;
cmd.Connection=conn;
cmd.ExecuteNonQuery();
//????????
sql = "INSERT INTO test VALUES(’dotnetthink’??'mypassword’)";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
//???????
sql = "SELECT * FROM test";
cmd.CommandText = sql;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
StringBuilder sb = new StringBuilder();
while (reader.Read())
...{
sb.Append("username:").Append(reader.GetString(0)).Append(" ")
.Append("password:").Append(reader.GetString(1));
}
MessageBox.Show(sb.ToString());