Search results for query: *

  1. P

    Question How to add Parent and Child record in Details View ??

    Hi I guess what is happening is: - The textboxes on the GUI are linked to the ContactsBindingSource and LocationsBindingSource. - The ContactsBindingSource has the DataSource as the Dataset, and the DataMebmber as the ContactsDataTable. - The LocationsBindingSource has the DataSource as...
  2. P

    Question How to add Parent and Child record in Details View ??

    Thanks I appreciate your advice. If I break immediately prior to the tablemanager.updateall the row count for the parent table has increased by one, as expected. The row count for the child table does not increase after 'AddNew' is called. It is just the same as in the underlying SQLServer...
  3. P

    Question How to add Parent and Child record in Details View ??

    Hi I greatly appreciate some help, I'm sure this should be simple! I'm trying to make a simple data entry form to create a new Contact (parent) and one new Location (child). The design is: - Tables are in SQLServer. Contacts table (parent) and Locations table (child) - Relation and Foreign...
  4. P

    Save form data in two tables

    My code ... This is the only code in the small test project - works with DGV, not with Details view. Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'DataSet1.Contacts' table. You can move, or...
  5. P

    Save form data in two tables

    Hi dsk96m Did you ever sort out this problem? I am experiencing the same behaviour. - Two tables in SQLServer. Parent/Child. Relation and Foreign Key Constraint in place. Update and Delete Rule = Cascade. - Trying to add new record to Parent table (Contacts) and related record to Child table...
Back
Top