How to resolve the SQLDateTime Overflow error in ASP.Net data class

I've been working alot with building data classes in ASP.Net.  While building some new tables, I ran into an odd problem.   This was all part of my Solunar Time Tables project at www.Solunar.com The SQL table has 3 different datetime columns.  All are set as Nullable in SQL.  But whenever a new instance of my data class is saved, any datetime properties that were not assigned a value throw a SQL DateTime Overflow error exception.  Sure you can get around it by setting some default value, but I don't always want/need that. Here's what I did t...

Mar 01, 2009 READ MORE
How to FTP files in AC7 code

Introduction Did you know that you can send and receive files via FTP right in your own web pages? Did you know you can do it with 4 lines of code AND know if it worked? Aha, now I have your attention AbleCommerce 7 includes a nifty little FTP component that makes uploading and downloading files via FTP a snap. This brief tutorial will explain how to do a simple FTP upload to a remote site. Remember, since .Net programming is all server-side, this is from the perspective of your web server and not your web browser. In other words, this is how you make your web server upload a file to a re...

Jul 02, 2008 READ MORE