I have created a simple ASP.NET webform for gathering students' registration data.
When students enter their personal details on the ASPX website, the registration data goes into the 'Students' table in MS SQL Server 2008 R2 express edition.
The 'Students' table has fields 'FirstName' and 'Surname' and I have UNTICKED 'Allow Nulls' option for these fields in order to prevent students from entering their registration data without entering their name.
However, strangely I still get some blank records without any data on it. The FirstName field and Surname field are blank and in fact the record doesn't have any data/text on any of its fields at all, although I have UNTICKED the 'Allow Nulls' option for the FirstName and Surname field in the table design view.
How could this happen? ASPX online data entry error?