vb.net - Creation date column in SQL table -

what easiest way automatically fill datetime column in sql data table date row created? using sql server 2005 if matters.

edit: i've tried using getdate() default , works insert query not when tableadapter adds row.

alter table table add column not null default (getdate())