Results 1 to 2 of 2

Thread: Parent Reference in Expression Column: I can not insert then?

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2005
    Posts
    3

    Question Parent Reference in Expression Column: I can not insert then?

    Hi

    I have a Master Detail Table in DataSet.
    And I define the expression of one columns in detail by referring parent columns.

    When I insert parent table, I saw the following exception

    System.Data.VersionNotFoundException
    Additional information: There is no Original data to access.

    A parent table may be referenced in an expression by prepending the column name with Parent

    You can find the sample program in the attachmens.
    I should mention that I use c# .net2003 and sqlserver 2000
    Attached Files Attached Files

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: Parent Reference in Expression Column: I can not insert then?

    How about you just post the relevant code. I for one do not generally download other people's projects and many people can't extract RAR files anyway. The easier you make it for us to help you, the more likely it is that we will.

    Have you prepended the column name with "Parent" in your Expression? Is the AcceptChangesDuringFill property of the DataAdapter set to True? Have you created a DataRelation between the two DataTables?
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width