Problem inputting text box values into a SQL Database when the text box is left blank
I am trying to input values from a set of text boxes into my SQL database. I have three fields which are decimal fields in my database. If I put a numeric value in the text boxes for these fields then the insert works fine. The problem I am running into is when the text boxes are left blank. I get an invalid input string error message. Any ideas on how i can just have the database insert a null when these text boxes are blank. My fields in my DB do allow null values. Thanks.
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.