i'm using this code:
SqlCommand cmd = new SqlCommand(" UPDATE memberform set active='" +DBNull.Value+"'",con);
cmd.ExecuteNonQuery();
But my bit value is False
Asked
Active
Viewed 47 times
0
Dim
- 122
- 11
-
and what's your problem? – Marek Woźniak May 15 '16 at 19:04
-
remove your begining space of query string `SqlCommand cmd = new SqlCommand("UPDATE memberform set active='" +DBNull.Value+"'",con);` – Mostafiz May 15 '16 at 19:05
-
It storages False and not Null – Dim May 15 '16 at 19:07
-
1Why not use `UPDATE memberform set active = null`? And BTW no quotes around `null`! – juergen d May 15 '16 at 19:07
-
1@GSerg, it is not MySql. – Crowcoder May 15 '16 at 19:08
-
Solved thank you. Should i delete answer? – Dim May 15 '16 at 19:09
-
@Crowcoder It does not matter. Feel free to find this question specifically for SQL Server though. – GSerg May 15 '16 at 19:09
-
@Dim Was there an answer here before? Has one been deleted? If you managed to solve the issue it is encouraged that you answer your own question and leave the answer up for others to see. – Peter David Carter May 15 '16 at 22:35