Cannot insert the value NULL into column UserId, table

Question

HelloI am taking help from your code fromhttpaspsnippetscomArticlesSimpleUserRegistrationFormExampleinASPNetaspxand when i execute it it Shows a null exception error referring to cannot insert null values into UserId column in tablepointing at userId  ConvertToInt32cmdExecuteScalar

Mudassar · Accepted Answer

You need to make sure the procedure is returning data The sample is working fine so compare the sample code and SQL with your code and SQL

LokeshBR · Answer

HiYou need to Set IDENTITY Auto Increment on the UserId Column so that it will take the UserId automaticallyThere are many options1 Delete the UserId Column and run the following scriptALTER TABLE Users ADD UserId INT IDENTITY 1 12 Set the Identity Specification to Yes by following below stepsa Right Click on the table and select Designb Click on UserId Column and see the Column properties belowc Expant the Identity Specification and Set the Is Identity to Yes

Cannot insert the value NULL into column 'UserId', table

Company

Explore

Follow us

Contact Us