Personally, I think that your database tables don't really do what you are trying to do. I notice that every BMW (or Jeep) will have the same Car ID, and I am sure this is not what you meant. I would structure my tables something like this:
CarMake<br />
<br />
CarMakeID int(AI)<br />
CarMake varchar<br />
<br />
Car<br />
<br />
CarID int(AI)<br />
CarMakeID int(Foreign key to CarMakeID)<br />
Price decimal<br />
Date datetime
Then i would create a class for each type CarMake and Car, something along these lines
class CarMake
{
int carID;
string carMake;
}
class Car
{
int carID;
int carMakeID;
decimal Price;
DateTime date;
public void InsertCar()
{
"INSERT INTO Cars(carMakeID, Price, Date) VALUES etc"
}
}
That way when you add a new vehicle you can just call the Insert method.
Hope this helps
Then when you add
Submit an article or tip