public SQLiteDataReader ExecuteReader(string sqlStr)
{
SQLiteConnection conn = new SQLiteConnection(connStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlStr;
cmd.CommandType = CommandType.Text;
SQLiteDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return reader;
}
string Sql = string.Format(@"select ");
using (SQLiteDataReader reader = db.ExecuteReader(sql))
{
while (reader.Read())
{
aa= reader["fuck"].ToString();
}
}
是呀using释放锁