Hi all! I made a smalll SQL Database with records about My Parish.
Tables are Houe HouseID int not null PK, autoincerement Street varchar 70 null Number char 10 null (datatype is char cause I have a data for example 17a) Adress (street+' '+Number) HouseHolder varchar (100) null ... Feast FeastID int not null PK, autoincerement FeastName varchar (50), not null FeastDate char (50), not null FeastDetails FeastDetailsID int not null PK, autoincerement FeastID int not null FK FeastName varchar (50) null HouseID int not null FK HouseHolder varchar (100) null Then I made VB windows application in VS 2005, with data source on sql database Parish and with two tables in DataSet, Feast and FeastDetails. I put table Feast in Detail View on the top of main form, and subtable FeastDetails in GridView below. On the top of form I have DataBinding Navigator. Can anyone help me out with code for inserts, updates and deletes on the main form called MainForm. Rev Fr. Ivan
