Datetime Conversion Error?

 Hi,
I am getting the following error when
executing the ExecuteInsert in the code below..:
 
Conversion failed when converting
datetime from character string.




    private bool
ExecuteInsert(String quantity)
   
{
[snip]

       
con.Open();

       
SqlCommand command = new SqlCommand();
       
command.Connection = con;
       
TextBox TextBox1 =
(TextBox)FormView1.FindControl("TextBox1");
       
Label 1 = (Label)FormView1.FindControl("Label3");
       
Label 2 = (Label)FormView1.FindControl("Label13");


       
command.CommandText = "INSERT INTO Transactions (etc,Date,etc)
VALUES (etc,@date,@etc)";
       
command.Parameters.AddWithValue([snip]);
       
command.Parameters.AddWithValue([snip]);
        command.Parameters.AddWithValue("@date",
DateTime.Now.ToString());
       
command.Parameters.AddWithValue([snip]);
       
command.Parameters.AddWithValue([snip]);
       
command.ExecuteNonQuery();

       
con.Close();
       
command.Dispose();
       
return true;
    }
    protected
void Button2_Click(object sender, EventArgs e)
   
{
        TextBox TextBox1 =
FormView1.FindControl("TextBox1") as TextBox;
       
bool retVal = ExecuteUpdate(Int32.Parse(TextBox1.Text));
       
if (retVal)
           
Response.Redirect("~/URL/EXTENSION.aspx");
       
Insert();

    }
    private
void Insert()
    {
       
TextBox TextBox1 = FormView1.FindControl("TextBox1") as
TextBox;
       
ExecuteInsert(TextBox1.Text);
    }
}  Thanks if someone can help!Jon