Excellent Links for DB Programming

This is a school database example that can be used as a template to create a working application. Click here.

Student...Graduate Student

Create a student class with two attributes and getters and setters.

Create a graduate student class with one other attribute.

Allow users to enter the info about one or the other...create the two objects depending on what the user chooses.

Here's the code from tonight's class (Baseball Players).

When creating classes....

MyBase.New() 'will access the parent classes constructor

Public Class BaseballPlayer
Inherits Player

'to create a BaseballPlayer from a Player class!

Here is the presentation...

Code from today

LemoninfoTableAdapter.Insert(txtID.Text, txtLargeSold.Text, _
txtSmallSold.Text, txtName.Text)
Dim newRow As LemonadeStandDataSet.LemoninfoRow
newRow = LemonadeStandDataSet.Lemoninfo.NewLemoninfoRow
newRow.ID = txtID.Text
newRow.LargeSold = txtLargeSold.Text
newRow.SmallSold = txtSmallSold.Text
newRow.SalespersonName = txtName.Text
LemonadeStandDataSet.Lemoninfo.Rows.Add(newRow)

This above code is the most important from today!

Here are the two projects.

Database project

Here it is.

To determine prime number

Function determinePrime(ByVal x As Integer) As Boolean
For a = 2 To x / 2
If x Mod a = 0 Then
Return False
End If
Next
Return True
End Function