Want to insert milisecond data in SQL server 2012

At first, I don't know what does your rd[1] returns but for casting it is easy as

SqlCommand cmd= new SqlCommand(“INSERT INTO ProcessValues Values( @Date)", connection); 
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = "@Date";
parameter.SqlDbType = SqlDbType.DateTime2;
parameter.Value = DateTime.Parse(rd[1].ToString());
cmd.Parameters.Add(parameter);
cmd.ExecuteNonQuery();