在Metro应用中选择sqlite查询? [英] Select query of sqlite in metro app?

问题描述

我已经看到很多示例，这些示例描述了Metro应用中SQLite的用法.大多数示例都具有Orderby/Insert/Delete语句.我可以知道如何使用Select语句从预先填充的数据库中获取数据吗?

I have seen quite a number of examples describing the usage of SQLite in Metro app. Most of the examples have either Orderby/Insert/Delete statements. May I know how do I get the data from a pre-populated db using the Select statement?

第二，执行查询后，有人如何将数据存储到array或arrayList中?

Secondly, how does someone store the data into an array or arrayList after the execution of the query?

请帮助我

谢谢.

推荐答案

查看此示例是否是您要查找的内容:

See if this example is what you're looking for:

return db.runAsync('SELECT * FROM Table');

将示例扩展到C#:

SQLiteAsyncConnection conn = new SQLiteAsyncConnection("people");
var query = conn.Table<Person>().Select();
var result = await query.ToListAsync();

这篇关于在Metro应用中选择sqlite查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！