I need to send an update string to a record and if the field is blank, it should write NULL to the db. I has datetime fields and int fields and everytime I update the sql it will put 00:00 for my datetime and 0 for my int. I do not have the whole update string with me, but this is the layout i use:
Update Communications set Dispatched = '" + txtdispatched.text + "' where Item = '" + txtitem.text + "'"
Any help would be greatly appreciated. Thanks in advance.
I am using VB.NET not C++