how to insert null value

Question

hi, All

 

hear is my statement

i am trying to insert null value through statement

if (txtBankAcNo.Text == "") { sSqlDbCommand.Parameters["@BankAcNo"].Value = null; }
                        else { sSqlDbCommand.Parameters["@BankAcNo"].Value = txtBankAcNo.Text; }

but is throwing Error: expects the parameter '@BankAcNo' which is not supplied

 

Regards!

 

Hitesh

 

 

Answer 1

Hi,

If parameter is declared as NULL, you don't need to pass it.

 

IF BankNo.text <> ""

 sSqlDbCommand.Parameters["@BankAcNo"].Value = BankNo.text; 

 

Thanks,

---

Tejas Shah
SQL YOGA

Answer 2

In stored procedure, the parameter @BankAcNo is not defined as nullable.

---

My Blog

Answer 3

Hello,

The stored procedure should be like below

CREATE PROCEDURE Procedure_Name
(
 @BankAcNo INT = NULL
)
AS
BEGIN
// Logic goes over here

END

Hope its clear & helpful....

---

Pavan Kokkula Infosys Technologies Limited.

Answer 4

Hi Hitesh

You could also try passing in DBNull.Value.

Regards

James

---

James Sales MCP, MCTS - Senior Software Developer - Solihull, England

Answer 5

Still, the parameter in stored procedure should be nullable otherwise it will generate error.

---

My Blog