c# - 如何从 Sql Column 读取到 Spinner？

Question

我想读取一个 sql 列并填充一个 Spinner。我正在使用这段代码:

 var spinner1 = FindViewById<Spinner>(Resource.Id.planets_spinner);
 var adapter = new ArrayAdapter<string>(this, Android.Resource.Layout.SimpleSpinnerItem);
 spinner1.Adapter = adapter;

 SqlConnection con = new SqlConnection(@"Data Source=192.168.1.101;Initial Catalog=RK1;user id=admin;password=1234");
 con.Open();

  SqlCommand sqlCmd = new SqlCommand("SELECT * FROM InventoryMainGroupItems where TaxOmada=0", con);

  SqlDataReader sqlReader = sqlCmd.ExecuteReader();
  while (sqlReader.Read())
  {
  adapter.Add("MainGroupItemName");

  }
  sqlReader.Close();

Answer 1

您需要使用 SpinnerAdapter并将其分配给您的 Spinner。

即使用 ArrayAdapter :

var adapter = new ArrayAdapter<string>(this, Android.Resource.Layout.SimpleSpinnerItem);
adapter.Add("First");
adapter.Add("Second");
var spinner1 = FindViewById<Spinner>(Resource.Id.planets_spinner);
spinner1.Adapter = adapter;

SQL.Net 示例:

string dbPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "myAppData.db3");
var db = new SQLiteConnection(dbPath);
db.CreateTable<Category>();

if (db.Table<Category>().Count() == 0)
{
    db.Insert(new Category()
    {
        Description = "First"
    });
    db.Insert(new Category()
    {
        Description = "Second"
    });
}

var categories = db.Table<Category>();
var adapter = new ArrayAdapter<string>(this, Android.Resource.Layout.SimpleSpinnerItem);
foreach (var category in categories)
{
    adapter.Add(category.Description);
}
var spinner1 = FindViewById<Spinner>(Resource.Id.planets_spinner);
spinner1.Adapter = adapter;