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)
    {
        if (!IsPostBack)
            bind();
    }
    protected void bind()
    {
        SqlConnection sqlcon = new SqlConnection("Data Source=(local);Database=db_05;Uid=sa;Pwd=");
        SqlCommand sqlcom = new SqlCommand("proc_across_table_new", sqlcon);
        sqlcom.CommandType = CommandType.StoredProcedure;
        sqlcom.Parameters.Add("@TableName", SqlDbType.VarChar, 50).Value = "员工信息表";
        if (DropDownList1.SelectedValue == DropDownList2.SelectedValue)
        {
            Response.Write("<script>alert('表头依据字段和分组依据字段不能相同')</script>");
            return;
        }
        if (DropDownList1.SelectedValue == "员工生日")
        {
            sqlcom.Parameters.Add("@NewColumn", SqlDbType.VarChar, 50).Value = "DATEPART(MM, birthday)";
            sqlcom.Parameters.Add("@BeforeColumnName", SqlDbType.VarChar, 50).Value = "";
            sqlcom.Parameters.Add("@AfterColumnName", SqlDbType.VarChar, 50).Value = "月";
            sqlcom.Parameters.Add("@GroupColumn", SqlDbType.VarChar, 50).Value = "dept";
            sqlcom.Parameters.Add("@FirstColumnName", SqlDbType.VarChar, 50).Value = "部门名称";
            sqlcom.Parameters.Add("@StatColumn", SqlDbType.VarChar, 50).Value = "0";
        }
        else if(DropDownList1.SelectedValue=="所在部门")
        {
            sqlcom.Parameters.Add("@NewColumn", SqlDbType.VarChar, 50).Value = "dept";
            sqlcom.Parameters.Add("@BeforeColumnName", SqlDbType.VarChar, 50).Value = "";
            sqlcom.Parameters.Add("@AfterColumnName", SqlDbType.VarChar, 50).Value = "";
            sqlcom.Parameters.Add("@GroupColumn", SqlDbType.VarChar, 50).Value = "DATEPART(MM, birthday)";
            sqlcom.Parameters.Add("@FirstColumnName", SqlDbType.VarChar, 50).Value = "月份";
            sqlcom.Parameters.Add("@StatColumn", SqlDbType.VarChar, 50).Value = "0";
        }
        sqlcom.Parameters.Add("@SecondColumnName", SqlDbType.VarChar, 50).Value = "部门人数";
        sqlcom.Parameters.Add("@Operator", SqlDbType.VarChar, 10).Value = "COUNT";
        SqlDataAdapter myda = new SqlDataAdapter();
        myda.SelectCommand = sqlcom;
        DataSet myds = new DataSet();
        myda.Fill(myds);
        GridView1.DataSource = myds;
        GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        bind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        bind();
    }
}