default.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Server=(local);database=db_05;Uid=sa;Pwd=");
        SqlDataAdapter dap = new SqlDataAdapter("SELECT 所在部门, "
            + "SUM(CASE 员工姓名 WHEN '明日' THEN 销售业绩 ELSE NULL END)AS [明日],"
            + "SUM(CASE 员工姓名 WHEN '科技' THEN 销售业绩 ELSE NULL END)as [科技] ,"
            + "SUM(CASE 员工姓名 WHEN '明日科技' THEN 销售业绩 ELSE NULL END)AS [明日科技],"
            + "SUM(CASE 员工姓名 WHEN '明日科技公司' THEN 销售业绩 ELSE NULL END)AS [明日科技公司],"
            + "SUM(CASE 员工姓名 WHEN '明日科技有限公司' THEN 销售业绩 ELSE NULL END)AS [明日科技有限公司]"
            +"  FROM 销售表 GROUP BY 所在部门", con);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        GridView1.DataSource = ds.Tables[0].DefaultView;
        GridView1.DataBind();
    }
}