insert command...

Hot Topic

Divide a form
Updating Listbox Items
[C#]DataGridView howto sum cells
Getting control over bindnavigator buttons
Wizard Forms
How To Use The Tab Key In ListView
How to apply ColumnStyle and Alternating Row style
Clickonce: Publish
e.cancel=true
Updating image of single listview item?

Windows Forms

Binary dat and Encoding
Tale of Woe - Convert KeyCode to Char - Please Help
how can i trap the forms on closing event from a menu item
Can't run ClickOnce
Publish Application Files
Monitor the Change of ActiveControl
how to make a property for enum ?
Visual Studio Error or Code Error: Form Inheritence.
seeking help to find specific index in combo box in VB.net
VSNET 2005 FINAL release can't open a form

insert command...

Hi,

I have these two access related tables. The first contains three fields:

ID        AutoNumber
Name   Text
Age      Number

And the second:

ID        Number
Order   Text


The ID's are related. When I use the designer to generate all the commands for me, being these related tables, it can only create the select command. So, I tried using the commandbuilder, but it also doesn't work for related tables. So my only and final solution is to write the remaining commands. I'm only interestes in the insert one... so... how can I do it

Thanks

Answer this question

insert command...

  • Kerem Baser

    I'm confused as to how this schema works. You have a "customer" table with ID, Name, and Age fields. You have an "order" table with an ID which is related to the Customer table (so it contains a copy of the customer ID) and order information, but no primary key value itself  Therefore, you really can't perform updates against data that relates these tables together. You need a key value in the Order table in order to make that possible.
  • insert command...
Answer this question