<dean.h.brown@gmail.com> wrote in message
news:cb8d3724-bfe3-4934-9b23-79d012f37f85@27g2000hsf.googlegroups.com...
> I'm trying to set the date created when I add a new record: (using a
> FormView)
>
> This works:
> <asp:SqlDataSource ID="SqlDataSource1" runat="server"
> ConnectionString="<%$ ConnectionStrings:ConnectionString
> %>"
> InsertCommand="INSERT INTO [AdultEvent] ([DateCreated],
> [DateLastModified], [EventName])
> VALUES ('04/23/2008', '04/23/2008', @EventName)"
>
> but I want the dates to be the current date and time.
>
> I've tried variations on this:
> VALUES ('<%$ DateTime.Now.ToString('MM/dd/yyyy') %>', '04/23/2008',
> @EventName)"
>
> But I get:
> System.Data.SqlClient.SqlException: Incorrect syntax near 'MM'.
>
> Or:
> VALUES ('<%$ DateTime.Now %>', '04/23/2008', @EventName)"
>
> System.Data.SqlClient.SqlException: Conversion failed when converting
> datetime from character string

wrote:
> How about GetDate()
>
> Transact-SQL
>
> But I would recommend against direct sql inserts like that. Look up "SQL
> Injection"
>