C#代码连接SQL Server数据库

来源：互联网发布：nginx 无reload 编辑：程序博客网时间：2024/06/05 02:02
class SqlExecute    {        private string connectionString;        private SqlConnection conn;        private SqlCommand cmd;        private SqlDataAdapter adapter;        private SqlDataReader reader;        private DataSet dataset;        public SqlExecute()        {            connectionString = "server=localhost;uid=sa;pwd=saas;database=stu";        }        private void getStatement()        {            try            {                connectionString = "server=localhost;uid=sa;pwd=saas;database=stu";                conn = new SqlConnection(connectionString);                conn.Open();            }            catch(Exception e)            {                        }        }        public void closeData()        {            try            {                if(conn.State == ConnectionState.Open)                    conn.Close();                            }            catch(Exception e)            {                        }                    }        public int newDataUpdate(string sql)        {            getStatement();            cmd = new SqlCommand();            cmd.CommandType = CommandType.Text;            cmd.Connection = conn;            cmd.CommandText = sql;            int i = cmd.ExecuteNonQuery();            return i;        }        public DataSet sqlQuery(string sql)     //查询数据        {            adapter = new SqlDataAdapter(sql,connectionString);            dataset = new DataSet();            adapter.Fill(dataset);            return dataset;        }        public void fillGrid(string sql,DataGridView dgv)       //填充GridView        {            DataSet ds = sqlQuery(sql);            dgv.DataSource = ds.Tables[0];        }    }