SQL间断式连接

sql.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace WindowsApplication1
{
    class sql
    {
        private static SqlConnection conn = new SqlConnection("workstation id=localhost;Integrated Security=SSPI;database=test");
        private static SqlCommand cmd = new SqlCommand();
        private static SqlDataAdapter da = new SqlDataAdapter();

        

        public static DataTable getdata(string cmdtext)
        {
            da.SelectCommand = cmd;
            da.SelectCommand.Connection = conn;
            da.SelectCommand.CommandText = cmdtext;
            conn.Open();
            da.SelectCommand.ExecuteNonQuery();
            conn.Close();
            DataSet ds = new DataSet();
            da.Fill(ds);

            return ds.Tables[0];
        }

        public static int exec(string cmdtext)
        {
            cmd.CommandText = cmdtext;
            cmd.Connection = conn;
            conn.Open();
            int i = cmd.ExecuteNonQuery();
            conn.Close();
            return i;
        }
    }
}