private void updateList() { listView.Items.Clear(); //get all the Movies from the database List <List <string> > list = dbc.getList("Movie"); foreach (List <string> l in list) { //fill in one row in the listView Movie m = new Movie(Int32.Parse(l[0]), l[1], decimal.Parse(l[2]), l[3], DateTime.Parse(l[4]), l[5], l[6], Int32.Parse(l[7]), Int32.Parse(l[8])); ListViewItem item = new ListViewItem(new[] { m.id.ToString(), m.name }); listView.Items.Add(item); } }
//get all the transaction records and pu them to the ListView private void updateList() { listView.Items.Clear(); //get all the transactions from the database List <List <string> > l = dbc.getList("Transaction"); foreach (List <string> record in l) { //fill in one row in the listView Transaction t = new Transaction(Int32.Parse(record[0]), Int32.Parse(record[1]), Int32.Parse(record[2]), Int32.Parse(record[3])); ListViewItem item = new ListViewItem(new[] { t.id.ToString(), t.cust.name, t.mov.name, t.qty.ToString(), t.total.ToString() }); listView.Items.Add(item); } }
private void updateList() { listView.Items.Clear(); //get all the customers from the database List <List <string> > list = dbc.getList("Customer"); foreach (List <string> l in list) { //fill in one row in the listView Customer c = new Customer(Int32.Parse(l[0]), l[1], l[2], l[3], l[4]); ListViewItem item = new ListViewItem(new[] { c.id.ToString(), c.name }); listView.Items.Add(item); } }