Visual basic.net Datagrid and SQL

[JamesBowtell]

Hey

I have a datagrid connected to a table in an SQL compact database. How would I automatically add today’s date in a column when adding a new record?

Cheers

 

[cjard]

yourdt.YourDateColumn.DefaultValue = DateTime.Now.Date

 

[MattP]

You can set the default for the column in SQL Server.

ALTER TABLE YourTable
ADD CONSTRAINT DF_YourTable_YourColumn
DEFAULT GETDATE() FOR YourColumn

or modify the table in SQL Server Management Studio and set the 'Default Value or Binding' for the column to GETDATE().