Home ›
ASP.NET Forums » Data Access » Data Access and ObjectDataSource Control » problem with inserting primary key value into database

problem with inserting primary key value into database

Last post 02-21-2006 5:56 AM by gurjeetsaini. 2 replies.

Sort Posts:

  • problem with inserting primary key value into database

    02-20-2006, 3:36 PM
    • Member
      128 point Member
    • gurjeetsaini
    • Member since 02-20-2006, 3:32 PM
    • Posts 89

    Hiya  friends

    pls help me to get rid of this error.the pbm is that whenever i try to insert values into database i am unable to insert the primary key(does not allow nulls) value in database and i get this message(given below) .what is the soln.any help will be greatly appreciated.

    Server Error in '/aspbasic' Application.

    Cannot insert the value NULL into column 'EmployeeID', table 'e1.dbo.Employees'; column does not allow nulls. INSERT fails. The statement has been terminated.

    Gurjeet,England

  • Re: problem with inserting primary key value into database

    02-20-2006, 4:03 PM
    • All-Star
      30,698 point All-Star
    • StrongTypes
    • Member since 12-13-2005, 4:21 PM
    • California
    • Posts 6,007
    • ASPInsiders
      Moderator
      TrustedFriends-MVPs

    EmployeeID will need to be setup as the identity seed so it will auto increment.

    HTH,
    Ryan

    How to ask a question

  • Re: problem with inserting primary key value into database

    02-21-2006, 5:56 AM
    • Member
      128 point Member
    • gurjeetsaini
    • Member since 02-20-2006, 3:32 PM
    • Posts 89

    THANK YOU.RYAN.

    Gurjeet,England
Page 1 of 1 (3 items)
RSS Available

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.