1

How to get column names and its values in SQLite for windows runtime apps (Windows 8.1 apps).

In Android it can be done easily like the following code snippet: 

... Cursor cursor = database.rawQuery("select * from Student"); String[] columnNames = cursor.getColumnNames(); ...

I am using Sqlite-net library for my windows project. I'm following this article.

Improve this question
6
  • Possible duplicate of How to get a list of column names and Find SQLite Column Names in Empty Table. Commented Jul 21, 2016 at 17:39
  • Also relevant: PRAGMA table_info. Commented Jul 21, 2016 at 17:57
  • Show the function you're actually using to execute the query. Commented Jul 22, 2016 at 7:48
  • Hi CL, I'm using await conn.ExecuteAsync(query); from conn= new SQLiteAsyncConnection(dbPath); Commented Jul 22, 2016 at 9:39
  • How can this be duplicate ? He is asking to get both the column names and the values per column. Please answer the question. @everyone Commented Jul 22, 2016 at 10:07
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.