update null for type date

Question

I have a sentence follow:

    string strSQL = "update pl_poli set ag_vouch = ' ',ag_vdate = #, ag_vmode = null where
 pl_no = '" + textBox5.Text + "' and pl_endtno ='" + textBox6.Text + "'";

I can't update because error "data type mismath". i have fill ag_vdate is type date I want to Update it -> null Please can you help me. Thank you so much.

en.wikipedia.org/wiki/SQL_injection Please be carefull :) What DBMS are you using ? — remi bourgarel
– remi bourgarel, Commented Aug 27, 2010 at 9:28

Pranay Rana · Accepted Answer · 2010-08-27 09:38:28Z

1

In your case you cannot pass " # " at datetime column because sql server consider this as varchar value and not able to convert this in datetime so...

Try to do as below

using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlCommand command = connection.CreateCommand())
{
    command.CommandText = "INSERT INTO table1 (column1, column2) VALUES (@param1, @param2)";

    command.Parameters.Add("@param1", SqlDbType.DateTime).Value = 
        DateTime.TryParse(txtDate.Text, out d) ?
            (object)d :
            DBNull.Value // inserting NULL
    ...

    connection.Open();
    command.ExecuteNonQuery();
}

edited Aug 27, 2010 at 9:38

answered Aug 27, 2010 at 9:32

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

update null for type date

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related