Webmaster Forum / ASP / Database Access / April 2008

I have an Events table in a database (MS SQL).  I would like to
present the
information like this:
August:

Is there a quick way to understanding how to insert/update
datetime/shortdatetime fields in an SQL database from an ASP?
Many thanks,
Rob

I'm very new to ASP and am now working on an existing site that is
written in ASP. I'm trying to populate a dropdown box with the results of
a query. There is current code that does this but it populates with team
name whereas I want division name.

Title says it  ... my C# web application uses a number of FormViews that are
inserted/updated/deleted via stored procedures.
Is there a way thru C# coding (example?) to validate a date field as valid
input before inserting/updating?  Test the length of a varchar/char field?  

I was hoping someone could offer me a bit of help here. I am trying to
connect to an unpassworded Access 2007 database for use in a small website.
For testing purposes I have everything stored locally, and am using the
following connection string:

I'm retrieving records from my db and update them.  Text fields are no
problem, but when it comes to different types of fields, such as 'select'
fields with options the default in the option list is the first item in the
list and not the actual database record.

I've a table that displays something like this:
clientid  order  OrderDate
-------- ------  ---------
1        Printer