Hi,
I'm making a program which accepts orders in a restaurant, and it is linked to a database. I'm using VB .NET.
I have a couple of things I can't find out how to do, so if someone could tell me simply how to do them it would be great.
The first thing is, is it possible to delete all the records from a database when the program initialises? How do I do it?
I would also like to know if it is possible to display items from the database in a listbox, or is it just simpler to use a datagrid.
In my program there is an order list which displays all orders in a datagrid. Once the order has been served, you are supposed to be able to press "Order Served"(Button), which then sets a "Served" Boolean value to true. This keeps the record in the database, however it removes the record from the datagrid.
The Data adapter is called daOrders, the data structure is called TableOrdersDS1.
Thanks!