User Profile

Collapse

Profile Sidebar

Collapse
Jake77
Jake77
Last Activity: Jun 23 '10, 10:47 AM
Joined: Apr 23 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jake77
    replied to Can't insert a row to a table with identity on
    in SQL Server
    Nope - that didn't do the trick

    I actually turned ALL table's Identity attribute to OFF except for the one in question.
    Still I get the same error.

    The question is why do I get a "Cant Insert NULL" error message when the values in this column should be automatically inserted and increased by the DB?

    Tnx!
    See more | Go to post

      Leave a comment:

    • Jake77
      started a topic Can't insert a row to a table with identity on
      in SQL Server

      Can't insert a row to a table with identity on

      Hey

      I'm trying to nsert a raw to a table that has one column marked with identity ON.

      The code is like this:

      string sqlString1 = "INSERT into T_Branches (BranchTypeID, BranchName) VALUES (" + _BranchType + ", '" + _BranchName + "')";


      SqlConnection objConnection = new SqlConnection() ;
      SqlDataAdapter objAdapater...
      See more | Go to post
      No activity results to display
      Show More
      Working...