public void pokazwyniki()
{
SQLiteCursor kursor = db.pobierz();
if (kursor.Count > 0)
{
Toast.MakeText(this, "coś jest", ToastLength.Long).Show();
StringBuffer buff = new StringBuffer();
int i = 1;
while (kursor.MoveToNext())
{
buff.Append(i + " " + kursor.GetString(1) + " " + kursor.GetString(2) + "\n");
++i;
}
listWyniki.Add(buff.ToString());
PokazWiadomosc("Wynik", buff.ToString());
}
else
{
PokazWiadomosc("Brak", "NIe udało sie");
}
}
public Settings GetByName(SettingName settingname)
{
String[] projection =
{
FeedEntry.Id,
FeedEntry.COLUMN_NAME_NAME,
FeedEntry.COLUMN_NAME_VAL_1,
FeedEntry.COLUMN_NAME_VAL_2,
FeedEntry.COLUMN_NAME_VAL_3,
FeedEntry.COLUMN_NAME_VAL_4,
FeedEntry.COLUMN_NAME_VAL_5,
};
String selection = FeedEntry.COLUMN_NAME_NAME + " = ?";
String[] selectionArgs = { settingname.ToString() };
String sortOrder = FeedEntry.COLUMN_NAME_NAME + " DESC";
SQLiteCursor cursor = (SQLiteCursor)db.Query(
FeedEntry.TABLE_NAME, // The table to query
projection, // The columns to return
selection, // The columns for the WHERE clause
selectionArgs, // The values for the WHERE clause
null, // don't group the rows
null, // don't filter by row groups
sortOrder // The sort order
);
cursor.MoveToFirst();
Settings result = null;
if (cursor.Count > 0)
{
result = new Settings();
result.Id = cursor.GetLong(cursor.GetColumnIndexOrThrow(FeedEntry.Id));
result.Name = (SettingName)Enum.Parse(typeof(SettingName), cursor.GetString(cursor.GetColumnIndexOrThrow(FeedEntry.COLUMN_NAME_NAME)));
result.Val_1 = cursor.GetString(cursor.GetColumnIndexOrThrow(FeedEntry.COLUMN_NAME_VAL_1));
result.Val_2 = cursor.GetString(cursor.GetColumnIndexOrThrow(FeedEntry.COLUMN_NAME_VAL_2));
result.Val_3 = cursor.GetString(cursor.GetColumnIndexOrThrow(FeedEntry.COLUMN_NAME_VAL_3));
result.Val_4 = cursor.GetString(cursor.GetColumnIndexOrThrow(FeedEntry.COLUMN_NAME_VAL_4));
result.Val_5 = cursor.GetString(cursor.GetColumnIndexOrThrow(FeedEntry.COLUMN_NAME_VAL_5));
cursor.Close();
}
return(result);
}