I have a form with a Calendar control and text field. IF the user wants to pick a date it can choose from the Calendar and it wioll pop up in the textbox control. But if it does not choose anything it should accept null value
.
here is my code

if(txtreviewdate.Text.Trim()=="")
            {
                sqlCommand4.Parameters["@ReviewDate"].Value =null;
            }
            else
            {
                sqlCommand4.Parameters["@ReviewDate"].Value = txtreviewdate.Text;
            }

But if I run is code it says that @revies date is missing from the stored procedure. Ten if I put the date then it accepts.
Please help so that it accepts a blank date field

You can not pass the C# Null keyword into SQL like that because, as you have seen, it will bomb the stored procedure.

Instead you need to use the DBNull class to let the stored procedure know that you are passing NULL data into it so you would do something like this: (I assume you are working with MSSQL)

sqlCommand4.Parameters["@ReviewDate"].Value = DBNull.Value;

That should work for you. Hth.

"The one language all programmers understand is profanity."

Thank you very much. It worked.Thanks.