<connectionStrings>

    <add name="StatisticsConnectionString" connectionString="data source=.;Initial Catalog=Statistics;Integrated Security=true;" providerName="System.Data.SqlClient" />

  </connectionStrings>

Web.config

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data;

using System.Data.SqlClient;

namespace Mystatistics

{

    /// <summary>

    /// 连接数据库的类

    /// </summary>

    public class DBLink

    {

        public static SqlConnection GetConnection()

        {

            SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["StatisticsConnectionString"].ConnectionString);

            return conn;

        }

    }

}

DBLink

        SqlConnection conn = DBLink.GetConnection();   //连接

        conn.Open();

        SqlCommand cmd = new SqlCommand();    //命令

        cmd.Connection = conn;

        cmd.CommandType = CommandType.StoredProcedure;    //指定命令类型是存储过程

        cmd.CommandText = "procMajorsByinstituteIdSelect";   //存储过程名

        cmd.Parameters.Add(new SqlParameter("@inInstituteId", instituteId));   //存储过程用到的参数,可以按这个一直添加

        SqlDataAdapter sda = new SqlDataAdapter(cmd);   //相当于内存里的datatable和从数据库获得的结果之间的桥梁

        DataTable dt = new DataTable();   //这个表装从数据库获得的数据,相当于本机内存里面的一个表

        sda.Fill(dt);  //填充

        /*从datatable绑定,并设置*/

        ddlMajor.DataValueField = "majorId";   //值,这两个字符串来自数据库select语句

        ddlMajor.DataTextField = "majorName";   //显示文字

        ddlMajor.DataSource = dt;

        ddlMajor.DataBind();  //绑定控件

        /*最后释放资源*/

        dt.Dispose();

        sda.Dispose();

        cmd.Dispose();   //释放

        conn.Close();   //关闭

        SqlConnection conn = DBLink.GetConnection();

        conn.Open();

        SqlCommand cmd = new SqlCommand();

        cmd.Connection = conn;

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.CommandText = "procGetMonthReport";   //存储过程名

        cmd.Parameters.Add(new SqlParameter("@startTime", startTime));

        cmd.Parameters.Add(new SqlParameter("@endTime", endTime));

        SqlDataAdapter sda= new SqlDataAdapter(cmd);

        DataSet ds = new DataSet();   //这个cmd 获得的结果是多个表,用dataset装

        sda.Fill(ds);

        /*处理获得的数据,注意若select没有结果但是想显示为0的强制转换的话会出现异常*/

        /*获得的第一个表*/

        underStuSum = Convert.IsDBNull(ds.Tables[].Rows[]["unum"])?:Convert.ToInt32(ds.Tables[].Rows[]["unum"]);

        mStuSum = Convert.IsDBNull(ds.Tables[].Rows[]["mnum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["mnum"]);

        dStuSum = Convert.IsDBNull(ds.Tables[].Rows[]["dnum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["dnum"]);

        mdStuSum = mStuSum + dStuSum;

        lblUnderStuSum.Text = underStuSum.ToString();

        lblMDStuSum.Text = mdStuSum.ToString();

        /*获得的第二个表*/

        singleRecruitsSum = Convert.IsDBNull(ds.Tables[].Rows[]["singlecompanynum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["singlecompanynum"]);

        lblSingleRecruitsSum.Text = singleRecruitsSum.ToString();

        /*获得的第三个表*/

        int u = Convert.IsDBNull(ds.Tables[].Rows[]["unum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["unum"]);

        int m = Convert.IsDBNull(ds.Tables[].Rows[]["mnum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["mnum"]);

        int d = Convert.IsDBNull(ds.Tables[].Rows[]["dnum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["dnum"]);

        singleProvidesSum = u + m + d;

        lblSingleProvidesSum.Text = singleProvidesSum.ToString();

        /*获得的第四个表*/

        groupSum = Convert.IsDBNull(ds.Tables[].Rows[]["groupsum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["groupsum"]);

        lblGroupSum.Text = groupSum.ToString();

        /*获得的第五个表*/

        groupCompanysSum = Convert.IsDBNull(ds.Tables[].Rows[]["groupcompanysum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["groupcompanysum"]);

        lblGroupCompanysSum.Text = groupCompanysSum.ToString();

        /*获得的第六个表*/

        int gu = Convert.IsDBNull(ds.Tables[].Rows[]["unum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["unum"]);

        int gm = Convert.IsDBNull(ds.Tables[].Rows[]["mnum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["mnum"]);

        int gd = Convert.IsDBNull(ds.Tables[].Rows[]["dnum"]) ?  : Convert.ToInt32(ds.Tables[].Rows[]["dnum"]);

        groupProvidesSum = gu + gm + gd;

        lblGroupProvidesSum.Text = groupProvidesSum.ToString();

        ds.Dispose();

        sda.Dispose();

        cmd.Dispose();

        conn.Close();

        SqlConnection conn = DBLink.GetConnection();

        conn.Open();

        SqlCommand cmd = new SqlCommand("select TypeID,TypeName from ArticleType", conn);

        if (ArticleType.Items.Count != )

            ArticleType.Items.Clear();

        SqlDataReader sdr = cmd.ExecuteReader();

        ArticleType.DataSource = sdr;

        ArticleType.DataTextField = "TypeName";

        ArticleType.DataValueField = "TypeID";

        ArticleType.DataBind();

        conn.Close();

        ArticleType.Items.Insert(, "请选择文章类型...");