Convert Access INSERT statement to SQL Server (C#)

Hi,
    What do I need to do to the following Access code to convert to using SQL Server 2005?. I have got so far but am now stuck with the INSERT statement parameters & on adding the current date/time. I am ok with my connection string.  

*****************************Original Access*****************************************************************************
        System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
        System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();
        System.Data.OleDb.OleDbParameter parameter1 = new System.Data.OleDb.OleDbParameter();
        System.Data.OleDb.OleDbParameter parameter2 = new System.Data.OleDb.OleDbParameter();
        conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; DATA   Source=|DataDirectory|MyDatabase.mdb;Persist Security       Info=False";
        command.Connection = conn;
        command.CommandText = "INSERT INTO DownloadCounts ([DateTime], [IPAddress], Program) VALUES (Now(),?,?)";
        command.CommandType = System.Data.CommandType.Text;
        parameter1.ParameterName = "IPAddress";
        parameter1.DbType = System.Data.DbType.String;
        parameter1.Value = HttpContext.Current.Request.UserHostName;
        command.Parameters.Add(parameter1);
        parameter2.ParameterName = "ProgramName";
        parameter2.DbType = System.Data.DbType.String;
        parameter2.Value = "ProgramName";
        command.Parameters.Add(parameter2);
        try
        {
            conn.Open();
            command.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
           //
        }
        finally
        {
            conn.Close();
        }
****************************Original Access*****************************************************************************

**************************New SQL*************************************************************************************

        System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
        System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand();

        System.Data.SqlClient.SqlParameter parameter1 = new System.Data.SqlClient.SqlParameter();
        System.Data.SqlClient.SqlParameter parameter2 = new System.Data.SqlClient.SqlParameter();

        conn.ConnectionString = "myserver connection string";
       
        command.Connection = conn;
        command.CommandText = "INSERT INTO DownloadCounts (Date, IPAddress, Program) VALUES (@Date,@IPAddress,@Program)";
     
        command.CommandType = System.Data.CommandType.Text;
        parameter1.ParameterName = "IPAddress";
        parameter1.DbType = System.Data.DbType.String;
        parameter1.Value = HttpContext.Current.Request.UserHostName;
        command.Parameters.Add(parameter1);
        parameter2.ParameterName = "ProgramName";
        parameter2.DbType = System.Data.DbType.String;
        parameter2.Value = "ProgramName";
        command.Parameters.Add(parameter2);
        try
        {
            conn.Open();
            command.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
           //
        }
        finally
        {
            conn.Close();
        }
*******************************New SQL***************************************************************************

Thanks
Paul.Start Free Trial