数据库连接文件

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

/// <summary>

/// conn 的摘要说明

/// </summary>

public class databind

{

    // public static string sqlstr = ConfigurationManager.ConnectionStrings["server=192.168.1.9;database=yin;uid=sa;pwd=123456"].ConnectionString;

   //public static string sqlstr = "server=192.168.1.9;database=tiezi;uid=sa;pwd=123456";

 public static string sqlstr = "server=YIN\\SQLEXPRESS;database=yinzi;uid=sa;pwd=123456";

    public static int GetExecuteNonQuery(string sql, bool IsProc, params SqlParameter[] pars)

    {

        int count = 0;

        SqlConnection con = new SqlConnection(sqlstr);

        con.Open();

        SqlCommand cmd = con.CreateCommand();

        cmd.CommandText = sql;

        cmd.CommandType = IsProc ? CommandType.StoredProcedure : CommandType.Text;

        cmd.Parameters.AddRange(pars);

        count = cmd.ExecuteNonQuery();

        con.Close();

        con.Dispose();

        cmd.Dispose();

        return count;

    }

    public static SqlDataReader GetExecuteReader(string sql, bool IsProc, params SqlParameter[] pars)

    {

        SqlConnection con = new SqlConnection(sqlstr);

        con.Open();

        SqlCommand cmd = con.CreateCommand();

        cmd.CommandText = sql;

        cmd.CommandType = IsProc ? CommandType.StoredProcedure : CommandType.Text;

        cmd.Parameters.AddRange(pars);

        SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

        return sdr;

    }

}