CREATE TABLE AutoShows
(
	AutoShowID			int		NOT NULL	IDENTITY( 1 , 1 ),
	AutoShowName			nvarchar( 100 )	NOT NULL,
	CityID				int		NOT NULL,
	Phone				char( 11 )	NOT NULL,
	Email				nvarchar( 25 )	NOT NULL,
	CONSTRAINT PK_AutoShows
		PRIMARY KEY (AutoShowID),
	CONSTRAINT FK_AutoShows_Cities
		FOREIGN KEY (CityID) REFERENCES Cities (CityID)
)

CREATE VIEW vwAutoShows
AS
SELECT
	AutoShows.AutoShowID,
	AutoShows.AutoShowName,
	Cities.CityName AS City,
	AutoShows.Phone,
	AutoShows.Email
FROM AutoShows
INNER JOIN Cities
	ON AutoShows.CityID = Cities.CityID

AutoLotDataSet.AutoShowsRow rowAutoShow = _dsAutoLot.AutoShows.FindByAutoShowID(autoShowID);
rowAutoShow["AutoShowName"] = txtAutoShowName.Text.Trim();
int rowsAffected = _adptrAutoShows.Update(_dsAutoLot.AutoShows);

AutoLotDataSet.AutoShowsRow rowAutoShow = _dsAutoLot.AutoShows.FindByAutoShowID(autoShowID);
rowAutoShow.Delete();
int rowsAffected = _adptrAutoShows.Update(_dsAutoLot.AutoShows);