i create table call content(Contentinfo, Contenttitle, createdatetime.datetime)

Then in asp.net i am using detailsview to insert the data. So how in the same time i entry the contentinfo and contenttitle, the createdatetime column can auto generate the date and time save to my database?

1. Create a new table in Enterprise Manager and create the datetime column. Make sure you don't allow NULLS on this column.

2. In the lower area where it says "Default Value", put in getDate().

Every time you insert into this table it will make a time stamp in that column if that's what you want.

Thank you very much...it work:D:D

OK boy... go get em. Glad it worked for you.