using System;using System.Data.SqlClient;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;        }    }}