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 Button1_Click(object sender, EventArgs e)
    {
        bind();
    }
    protected void bind()
    {
        SqlConnection sqlcon = new SqlConnection("Data Source=(local);Database=db_05;Uid=sa;Pwd=");
        SqlCommand sqlcom = new SqlCommand("proc_across_table", sqlcon);
        sqlcom.CommandType = CommandType.StoredProcedure;
        sqlcom.Parameters.Add("@TableName", SqlDbType.VarChar, 50).Value = "商品销售表";
        if (DropDownList1.SelectedValue == DropDownList2.SelectedValue)
        {
            Response.Write("<script>alert('表头依据字段和分组依据字段不能相同')</script>");
            return;
        }
        sqlcom.Parameters.Add("@NewColumn", SqlDbType.VarChar, 50).Value = DropDownList1.SelectedValue;
        sqlcom.Parameters.Add("@GroupColumn", SqlDbType.VarChar, 50).Value = DropDownList2.SelectedValue;
        sqlcom.Parameters.Add("@StatColumn", SqlDbType.VarChar, 50).Value = "订货数量";
        sqlcom.Parameters.Add("@Operator", SqlDbType.VarChar, 10).Value = "SUM";
        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();
    }
}