I am trying to display the items that are out of stock and re-ordered depending on the orders for that day. Then also display the bills for all the customers who ordered that day. They should display all customers name, address, items ordered with cost and total cost for the order. I have code to open the connection but after that I am at a total loss at how to call in those values (custID, itemID, quantity, name, street, city, amtPurchases, description, price) I also attached a picture of what it needs to look like. So far here is what I have and need help with:
Imports System.Data.OleDb Public Class frmMicroland Dim con As OleDbConnection Private Sub btnStockItems_Click(sender As System.Object, e As System.EventArgs) Handles btnStockItems.Click Dim ConnectionString As String ConnectionString = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = C:\Users\bin\Debug\MICROLAND.accdb;" Dim AccessConnection As New System.Data.OleDb.OleDbConnection(ConnectionString) AccessConnection.Open() Dim da As New System.Data.OleDb.OleDbDataAdapter("SELECT custID", AccessConnection) Console.WriteLine(AccessConnection) AccessConnection.Close() End Sub Private Sub btnTodaysOrders_Click(sender As System.Object, e As System.EventArgs) Handles btnTodaysOrders.Click End Sub End Class
I really want to learn vb so answers would be great but if you just want to give me helpful topics or sites or code with explanations that would be awesome! I have been working on this project for weeks and I am so confused.