Insert statement (please read again)

Discussion in 'ASP .Net' started by Seema, Jun 1, 2009.

  1. Seema

    Seema Guest

    have two tables. Roles and Users. In Roles I have three columns iID(PK),
    Role(varchar), Description(varchar).

    In User table I have columns ID(PK,FK), Username(varchar),
    Password(varchar), Role(int).
    First I fill data in Roles table then now I am trying to insert data in User
    table it is giving me following error.

    Msg 547, Level 16, State 0, Line 1
    The INSERT statement conflicted with the FOREIGN KEY constraint
    "FK_User_Role". The conflict occurred in database "DataFeed", table
    "dbo.Role", column 'Id'.
    The statement has been terminated.
     
    Seema, Jun 1, 2009
    #1
    1. Advertisements

  2. Again, it seems you tried to insert a record in the User table with
    Role which is not presented in the Roles table
     
    Alexey Smirnov, Jun 1, 2009
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.