Cannot insert the value NULL into column 'rowguid', column does not allow nulls. INSERT fails.

Question

0.00/5 (No votes)

See more:

how i can avoid this problem:

C#

Cannot insert the value NULL into column 'rowguid', column does not allow nulls. INSERT fails.

sample querry:

SQL

insert into tablename (col1,col2,col3)  values('v1','v2','v3')

Posted 26-Jun-13 18:30pm

Qadri Jillani

Updated 26-Jun-13 18:32pm

v2

Add a Solution

3 solutions

Solution 2

Check you Table design and set allow null........

Posted 26-Jun-13 18:37pm

Nirav Prabtani

Comments

[no name] 27-Jun-13 0:58am

That's the lazy way out and can lead to more problems than the one it solves. The error may be gone, but what if this value is required and the program's logic does not expect null values and falls on its nose at many places because of that?

The only way to deal with this is to understand your data model. Only then you can make a decision about allowing nulls or not. If not, then the only solution would be to assure that a valid value is provided for this column when rows are inserted.

Nirav Prabtani 27-Jun-13 1:18am

Thanks....:)

Nirav Prabtani 27-Jun-13 1:19am

I will take care about that...:)

Solution 3

You can't insert null values if your 'rowguid' column is marked as Primary key.

Posted 26-Jun-13 18:55pm

ArunRajendra

Updated 26-Jun-13 18:56pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2013-06-26T18:34:00

Solution 1

Check your database schema - rowguid expects a value (as 'allow nulls' is most probably false).
As a result, you get this error.

Since a guid is a unique identifier, you might need to pass a value that is appropriate. I recommend you check your entire code flow to ensure you send in the correct value.

Posted 26-Jun-13 18:34pm

Abhinav S

Updated 26-Jun-13 18:35pm

v2