Technology & Fun

Inserting null values into database from TextBox using StoredProcedure:

1. First you have to allow null to your column what you have created in table
2. Allow null to that column too in stored procedure parameter like this:

create procedure sp_PassNullValueInSp
(@id varhcra(10), @name varchar(10)= null)

3.c# code

if(txtMobileNumber.Text!="")
cmd.Parameters.Add("@name",SqlDbType.BigInt).Value
= txtname.Text);