C#连接sqlserver与工具类

sqlServer连接类

internal class Db: IDisposable
    {
        private SqlConnection connection;
//
        public Db() { 
            //connection= new SqlConnection(@"server=SERVER;database=DATABASE;Trusted_Connection=SSPI");
            connection = new SqlConnection(@"server=SERVER;database=DATABASE;uid=uid;pwd=pwd");
            connection.Open();
        }

        public DataTable getBySql(string sql)
        {
            DataTable table= new DataTable();
            SqlDataAdapter sqlDataAdapter=new SqlDataAdapter(new SqlCommand(sql,connection));
            sqlDataAdapter.Fill(table);
            return table;
        }


        public void setBySql(string sql)
        {
            new SqlCommand(sql,connection).ExecuteNonQuery();
        }

        public void Dispose()
        {
            connection.Close();
        }
    }

工具类Util

    internal class util
    {
        //跨界面数据传输
        public static Dictionary<string,object> dict=new Dictionary<string,object>();

        //填充listview
        public static void fill( ListView listView ,DataTable table, string[] columns)
        {
            listView.Clear();
            listView.BeginUpdate();
            for(int i = 0; i < columns.Length; i++)
            {
                listView.Columns.Add(columns[i],listView.Width/columns.Length-1,HorizontalAlignment.Left);
            }
            for(int i = 0; i < table.Rows.Count; i++) {
                ListViewItem item=new ListViewItem();
                for(int j=0;j< table.Columns.Count; j++) {

                    if (j <= 0)
                    {
                        item.Text= table.Rows[i][j].ToString();
                    }
                    else
                    {
                        item.SubItems.Add(table.Rows[i][j].ToString());
                    }
                }
                listView.Items.Add(item);
            }
            listView.EndUpdate();
        }

        //填充下拉框
        public static void fill( ComboBox comboBox, DataTable table)
        {
            comboBox.Items.Clear();
            for (int i = 0; i < table.Rows.Count; i++)
            {
                for (int j = 0; j < table.Columns.Count; j++)
                {

                    comboBox.Items.Add(table.Rows[i][j]);
                }
            }
        }
    }