I want 2 insert null value in numeric column if it is blank
i have us foll code bt it is giving me err:
vDr["Drg_Days"] = (txtDrgDays.Text==""?null:txtDrgDays.Text);
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin GhadgePosted Jan 14, 2011, 8:08 AM
But i want 2 insert null value in numeric column table when it has blank value or null value.
Thnk u for reply
Dorababu MekaPosted Jan 14, 2011, 6:06 AM
INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", NULL,...)
Mamta MPosted Jan 14, 2011, 6:02 AM