sqlclass.cs

中小企业人力资源管理系统

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

namespace HRP.BaseClass
{
    class SqlClass
    {
        /// <summary>
        /// 连接数据库
        /// </summary>
        /// <returns>返回数据库连接</returns>
        public SqlConnection SqlConBind()
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "Data Source=2B592DC6CE92428;Initial Catalog=db_HRP;User ID=sa;PassWord=server";
            return con;
        }
        /// <summary>
        /// 数据集
        /// </summary>
        /// <param name="strsql">sql语句</param>
        /// <param name="strTbl">表名</param>
        /// <returns>返回数据集</returns>
        public DataSet SqlDaAd(string strsql, string strTbl)
        {
            SqlConnection con = this.SqlConBind();
            SqlDataAdapter sda = new SqlDataAdapter(strsql, con);
            DataSet ds = new DataSet();
            sda.Fill(ds, strTbl);
            con.Close();
            return ds;
        }
        /// <summary>
        /// SqlDataAdapter
        /// </summary>
        /// <param name="Strsql">sql语句</param>
        /// <returns>返回SqlDataAdapter</returns>
        public SqlDataAdapter sqlsda(string strsql)
        {
            SqlConnection con = this.SqlConBind();
            SqlDataAdapter sda = new SqlDataAdapter(strsql, con);
            return sda;
        }
        /// <summary>
        /// 执行SqlCommand
        /// </summary>
        /// <param name="strsql">sql语句</param>
        public void sqlcmd(string strsql)
        {
            SqlConnection con = this.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand(strsql,con);
            scd.ExecuteNonQuery();
            con.Close();
        }
    }

}