c#连接sqlserver、插入数据、从数据库获取时间

namespace Test
{
    //连接数据库
    public class Connection
    {
        private static string connectionString =
            \"Server = 192.168.1.222;\" +
            \"Database = Test;\" +
            \"User ID = Test;\" +
            \"Password = abc123;\";

        /// <summary>
        /// 连接数据库
        /// </summary>
        /// <returns></returns>
        private SqlConnection ConnectionOpen()
        {
            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            return conn;
        }

        /// <summary>
        /// 向表(Table)中插入一条数据
        /// </summary>
        public void Insert(string value1, string value2, string value3, DateTime dateTime)
        {
            SqlConnection conn = ConnectionOpen();
            string sql =
                \"insert into Table(row1, row2, row3, DateTime) values (\'\" +
                value1 + \"\', \'\" + value2 + \"\', \'\" + value3 + \"\', \'\" + dateTime + \"\')\";
            SqlCommand comm = new SqlCommand(sql, conn);
            comm.ExecuteReader();
　　
            conn.Close();
        }

        /// <summary>
        /// 从数据库中获取当前时间
        /// </summary>
        /// <returns></returns>
        public DateTime GetDateTimeFromSQL()
        {
            SqlConnection conn = ConnectionOpen();
            string sql = \"select getdate()\";
            SqlCommand comm = new SqlCommand(sql, conn);
            SqlDataReader reader = comm.ExecuteReader();
            DateTime dt;
            if (reader.Read())
            {
                dt = (DateTime)reader[0];
                conn.Close();
                return dt;
            }
            conn.Close();
            return DateTime.MinValue;
        }
    }
}