Hi

here is the scenario.

I am using Form View to insert data to the table.

My table is MS sql server table of which all the columns are allow no nulls

However, sometimes i need to empty values ie no value to the table column.

Is it possible?

Recommended Answers

can you insert a null value into a column that doesn't allow nulls? I would guess not. You could possibly create some default value to insert that isn't likely to be a value chosen/used by whoever is filling out the form.

Jump to Post

All 2 Replies

can you insert a null value into a column that doesn't allow nulls? I would guess not. You could possibly create some default value to insert that isn't likely to be a value chosen/used by whoever is filling out the form.

Ok I will explain again

I want to insert empty value not null value.

empty value can be string empty.

In the formview there is a text field let's say a description text box. But it is not required to insert any value in it.

So when inserting data in the form view, I get the error cannot insert null value in the coloumn description.

The issue is I am using Formview directly.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.