這是我目前嘗試過的，但我得到了下面顯示的錯誤宣告。ITEMNAME、ITEMQUANTITY 和 ITEMPRICE 是從資料庫輸入到串列框中的內容。
AllItems.Items.Clear();
AllItems.Items.Add(String.Format(listboxformatting, "Item Name", "Item Quantity", "Item Price (￡)"));
sqlite_conn = new SQLiteConnection("Data Source=RetailSystem.db; Version = 3; New = True; Compress = True;");
try
{
SQLiteDataReader sqlite_datareadert;
sqlite_conn.Open();
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM TblItemStock";
sqlite_datareadert = sqlite_cmd.ExecuteReader();
while (sqlite_datareadert.Read())
{
string ITEMNAME = sqlite_datareadert.GetString(0);
int ITEMQUANTITY = sqlite_datareadert.GetInt32(1);
decimal ITEMPRICE = sqlite_datareadert.GetDecimal(2);
AllItems.Items.Add(String.Format(listboxformatting, ITEMNAME ITEMQUANTITY ITEMPRICE));
AllItems.Refresh();
}
sqlite_datareadert.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
錯誤代碼
顯示的內容
uj5u.com熱心網友回復：
如果您想在表單上放置一個 datagridview 并將其重命名_itemsDataGridView為此應該沒問題：
try
{
var da = new SQLiteDataAdapter("SELECT * FROM TblItemStock", "Data Source=RetailSystem.db;Version=3;New=True;Compress=True;")
var dt = new DataTable();
da.Fill(dt);
_itemsDataGridView.DataSource = dt;
_itemsDataGridView.Columns[0].HeaderText = "Item Name";
_itemsDataGridView.Columns[1].HeaderText = "Item Quantity";
_itemsDataGridView.Columns[2].HeaderText = "Item Price (￡)";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/456212.html