Depending on what time picker you use (and I have no idea) you may need to convert it's output to a TimeSpan and then pass that: TimeSpan maps directly to/from an SQL Time field.
TimeSpan theTime = DateTime.Now.TimeOfDay;
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand com = new SqlCommand("INSERT INTO myTable (theTime) VALUES (@TIME)", con))
{
com.Parameters.AddWithValue("@TIME", theTime);
com.ExecuteNonQuery();
}
}