library.cs

来自「 一个用Ｃ＃编写的图书管系统」· CS 代码 · 共 50 行

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

namespace Library
{
    class Library
    {
        private static string cnnString = "Data Source=.;Initial Catalog=Library;Integrated Security=True";
        //private static  string cnnString = "Data Source=127.0.0.1;Initial Catalog=SRSMS;User ID=sa;Password=sa";
        public static string chuanzhi;
        /// <summary>
        /// 用来做增加、删除、修改等操作
        /// </summary>
        /// <param name="sql">传入SQL语句</param>
        /// <returns>返回影响的行数</returns>
        public static int ExecuteNoQuery(string sql)
        {
            SqlConnection cnn = new SqlConnection(cnnString);
            SqlCommand cmd = new SqlCommand(sql, cnn);
            int returnValue = -1;
            try
            {
                cnn.Open();
                returnValue = cmd.ExecuteNonQuery();
            }
            catch
            {
                returnValue = -1;
            }
            return returnValue;
        }

        /// <summary>
        /// 用来做查询操作
        /// </summary>
        /// <param name="sql">传入SQL语句</param>
        /// <returns></returns>
        public static DataSet ExecuteDataSet(string sql)
        {
            SqlDataAdapter sda = new SqlDataAdapter(sql, cnnString);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            return ds;
        }
    }
}