c#链接sql server数据库

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;

namespace bookInfo
{
    public class DataBase
    {
        public SqlConnection conn;
        public SqlCommand cmd;
        public SqlDataReader sr;
        string connString = "Data Source=(local);User Id=sa;Password=sa;database=myServer";   （其中，Data Source=数据库所在机器地址，User Id=用户名，Password=密码，database=数据库名）

        //建立连接
        public SqlConnection getConn()
        {
            conn = new SqlConnection(connString);
            conn.Open();
            return conn;
        }

        //执行结果返回行数
        public int executeQuery(string sql)
        {
            try
            {
                cmd = new SqlCommand(sql,getConn());
                return cmd.ExecuteNonQuery();
            }
            catch
            {
                return 0;
            }
            finally
            {
                conn.Close();
            }
        }

        //执行结果返回内容
        public DataSet zhiX(string sql, string tableName)
        {
            SqlDataAdapter sa = new SqlDataAdapter(sql, getConn());
            DataSet ds = new DataSet();
            sa.Fill(ds, tableName);
            return ds;
        }

        //关闭连接
        public SqlConnection close()
        {
            conn.Close();
            return conn;
        }
    }
}