Database program
Got a problem with a database application
I'm trying to display information from a database into a listbox and 5 textboxes these are as follows
ListBox Customer ID
TextBox1 First Name
TextBox2 Last Name
TextBox3 City
TextBox4 State
TextBox5 Zip Code
The listbox allows selection of a customerid which then displays the details of that customer id into the 5 read only textboxes
There is a also a datagrid which lists all the order details for the customer these fields are OrderID OrderPrice and CustomerID
This is what I have so far
Imports System.Data.OleDb
Public Class Form1
Inherits System.Windows.Forms.Form
Dim dr As OleDbDataReader
Dim cnShop As OleDbConnection
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cnShop = New OleDbConnection
cnShop.ConnectionString = _
"Data Source=C
The Doughnut Shop.mdb;Provider=Microsoft.Jet.OLEDB.4.0;"
End Sub
End Class
Any tips/guidance would be great
Got a problem with a database application
I'm trying to display information from a database into a listbox and 5 textboxes these are as follows
ListBox Customer ID
TextBox1 First Name
TextBox2 Last Name
TextBox3 City
TextBox4 State
TextBox5 Zip Code
The listbox allows selection of a customerid which then displays the details of that customer id into the 5 read only textboxes
There is a also a datagrid which lists all the order details for the customer these fields are OrderID OrderPrice and CustomerID
This is what I have so far
VB.NET:
Public Class Form1
Inherits System.Windows.Forms.Form
Dim dr As OleDbDataReader
Dim cnShop As OleDbConnection
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cnShop = New OleDbConnection
cnShop.ConnectionString = _
"Data Source=C
End Sub
End Class
Any tips/guidance would be great