Getting the value of an identity field when you add a record to database in most of the cases is useful.

One way to accomplish that is to use store procedures. But how you do it if you don't want to use a stored procedure? By using ExecuteScalar method in OleDbCommand or whichever provider you use.

This tutorial will show you how to implement the most basic form of the Calendar control, then adjust it to make it look like an event calendar where the days containing events are marked as such.