How do you save a (C#) DateTime into a SQL Server datetime column?

[Steve Kershaw]

Hi,

I have a table in a SQL Server 2005 database that has a column of type
"datetime". From a C# program I need to insert todays date into this
column like so:

gridAdapter.InsertNewGridID( Convert.ToDateTime(DateTime.Today) );

I keep on getting an error: "Implicit conversion from data type
sql_variant to int is not allowed. Use the CONVERT function to run this
query."

How is this done?

Thanks in advance.
Steve