jeudi 13 août 2015

Sqlite-net getting column

In my windows 10 universal application I've a (badly designed) database .

In each table there are lots of columns (Column1,Column2,...) that each column have list of times under it.

enter image description here

I tried this:

public async Task<List<string>> GetColumn(int ColumnID) {
   return await _connection.QueryAsync<string>("SELECT Column"+ColumnID+" FROM A1");
}

but I doesn't work because of DataType problems... I'm really stucked...

I just wanna to get one column datas in a list.

Aucun commentaire:

Enregistrer un commentaire