setting a default value for a column in code or XSD

I want to set a date column in a datagrid view to default to today's
date. I have tried two approaches and am curious about a third. Please
help.

1.) How do I set the DefaultValue property of a column in and XSD? The
current value of the property is <DBNull>. I want it to be today's
date. I do not know the syntax and I have been unable to discover the
syntax. Microsoft is not friendly in that way (or I have not yet
discovered how to coax it to help me discover such things).
How do I default the date and/or how do I perform a search to discover
this myself?

I am assuming then, that the when the user does not enter a value this
defalut value will be used.
Also I understand that that date will not be displayed until after the
save.

2.) A preferred approach to me would be to have the datagrid view
populate the value when the user begins data entry on a new record. I
tried the following code but this did not work. It did not like "=
DateAndTime.Today;"

private void dgvLaborRate_RowsAdded(object sender,
DataGridViewRowsAddedEventArgs e)
{
// add default date
if (_SaveOrCancelRequired == true)
{
this.dgvLaborRate.CurrentRow.Cells[3].Value =
DateAndTime.Today;
}
}

Again I could not discover what to use to get the date returned using
C#. When I search Microsoft help and ask it to filter for only C#
results it still gives me VB.NET, Outlook, Pockt PC compact framework,
WIndows Mobile 5.0 SDK. etc. etc. ~ Again I do not know how to get
help with Microsoft help or it does not know how to give me what I
ask. ~ Again, any tips on finding answers?

How shold I supply the datetime to a column in code above?

3.) Another thing I might add is that this column is set with a
ColumnType of CalendarColumn. Perhaps there is a way thorugh this
column type to set the default to equal today. Is there a way to solve
it with this?


Thanks,
Doug
.