将数据从 SQLite 数据库绑定到条目 Xamarin 窗体

Question

我想获取SQLite数据库中PresAddress列的数据。我想获取">PresAddress"列数据并将该数据绑定到我的输入字段。PresAddress位于tblContacts中。我怎样才能得到它？

这是我的代码：

private void rcodePicker_SelectedIndexChanged(object sender, EventArgs e)
{
var pickedRetailerCode = rcodePicker.Items[rcodePicker.SelectedIndex];
var db = DependencyService.Get<ISQLiteDB>();
var conn = db.GetConnection();
var getUser = conn.QueryAsync<ContactsTable>("SELECT * FROM tblContacts WHERE ContactID=?", pickedRetailerCode);
var resultCount = getUser.Result.Count;
if (resultCount < 1)
{
//MessagingCenter.Send(this, "Http", Retailer);
}
else
{
var result = getUser.Result;
entStreet.Text = ;
}
}

Answer 1

使用这个：

for (int i = 0; i < resultCount; i++)
{
var result = getUser.Result[i];
entStreet.Text = result.PresAddress;
entBarangay.Text = result.PresBarangay;
entCity.Text = result.PresTown;
entProvince.Text = result.PresProvince;
entDistributor.Text = result.PresDistrict;
}