How to fill form with blank fields in sql server using vb.net, i m new to .net

[User 1875985]

Hi I am using html server controls with vb.net. I used sqlDataAdapter and Dataset to connect to tables. I am using sqlCommand to insert records in to database. If there is a better way to insert or update custom fields please tell me. Error: System.FormatException: Input string was not in a correct format Error Code: If Not Text4.Value.Empty Then SqlInsertCommand1.Parameters("@Date_Reg_RI").Value = Text4.Value Date_Reg_RI is a dateTime field in Database sql server2000 and i want to keep it blank. Any quick help is welcome. Regards Varun

[Colin Angus Mackay]

VAcharya wrote: Text4.Value.Empty Are you sure about that? String.Empty[^] VAcharya wrote: Date_Reg_RI is a dateTime field in Database sql server2000 and i want to keep it blank If by "blank" you mean a null value then you should use System.DBNull.Value. I'm not sure this helps. Perhaps you could explain more.

---

My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

[sstocker]

Datetime doesn't except null values (that is usually how it is set up), so if you want to insert a blank value I believe you can just insert "' '". Let me know if it works. Scott Stocker