>Hello All, pulling my hair out over this one, how do I pass an empty date value ( equivalent to VFP's { \ \ } ) to a SQL Server stored proc using ADO.NET and C#, I've tried sending empty strings which works from VFP using ODBC but returns an error "Cannot convert empty string to DateTime type", the problem I have is these date values are string values from textboxes and are not always populated, if I set them to null the SP works ( is this the proper way to go in SQL ? ) any help much...


If you are a UTMag subscriber, see my January 2005 column. I explain how to handle it.

PS: my articles are also available at http://pages.videotron.com/emoreau/