private static List<User> getUsers(SQLiteConnection conn)
{
var users = new List<User>();
var command = new SQLiteCommand("select * from users", conn);
var reader = command.ExecuteReader();
while (reader.Read()) {
var u = new User() { Username = reader["name"].ToString(), Firstname = reader["firstname"].ToString(), Lastname = reader["lastname"].ToString() };
users.Add(u);
}
return users;
}
/// <summary>
/// 查询所有数据
/// </summary>
/// <returns>返回数据集</returns>
public static List<User> Query()
{
try
{
StringBuilder strSQL = new StringBuilder();
strSQL.AppendFormat("SELECT ID, name, email FROM user");
SQLiteDBHelper sqliteDB = new SQLiteDBHelper();
SQLiteDataReader reader = sqliteDB.ExecuteReader(strSQL.ToString());
List<User> results = new List<User>();
while (reader.Read())
{
User user = new User();
user.ID = Convert.ToInt32(reader["ID"]);
user.name = reader["name"].ToString();
user.email = reader["email"].ToString();
results.Add(user);
}
return results;
}
catch
{
return null;
}
}