default2.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 Default2 : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    SqlDataAdapter myda;
    DataSet myds;
    string strCon = "Data Source=(local);Database=db_05;Uid=sa;Pwd=";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Fieldbind();
            try
            {
                GVbind();
            }
            catch
            {
                Response.Write("<script>alert('统计列不能为日期或字符串类型，请重新选择！');location='Default.aspx';</script>");
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx");
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GVbind();
    }
    protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GVbindByListBox();
    }
    //绑定GridView控件
    protected void GVbind()
    {
        sqlcon = new SqlConnection(strCon);
        sqlcom = new SqlCommand("proc_clairvoyant_table", sqlcon);
        sqlcom.CommandType = CommandType.StoredProcedure;
        sqlcom.Parameters.Add("@TableName", SqlDbType.VarChar, 50).Value = "员工信息表";
        sqlcom.Parameters.Add("@PageFieldByColumn", SqlDbType.VarChar, 50).Value = Session["Page"].ToString();
        sqlcom.Parameters.Add("@RowFieldByColumn", SqlDbType.VarChar, 50).Value = Session["Row"].ToString();
        sqlcom.Parameters.Add("@ColumnFieldByColumn", SqlDbType.VarChar, 50).Value = Session["Column"].ToString();
        sqlcom.Parameters.Add("@PageFieldValue", SqlDbType.VarChar, 50).Value = "";
        sqlcom.Parameters.Add("@RowFieldValue", SqlDbType.VarChar, 200).Value = "";
        sqlcom.Parameters.Add("@ColumnFieldValue", SqlDbType.VarChar, 200).Value = "";
        sqlcom.Parameters.Add("@DataFieldByColumn", SqlDbType.VarChar, 50).Value = Session["Data"].ToString();
        sqlcom.Parameters.Add("@DataFieldOperateMethod", SqlDbType.VarChar, 10).Value = Session["OMethod"].ToString();
        myda = new SqlDataAdapter();
        myda.SelectCommand = sqlcom;
        myds = new DataSet();
        myda.Fill(myds);
        GridView1.DataSource = myds;
        GridView1.DataBind();
    }
    //双击ListBox中项时重新绑定GridView控件
    protected void GVbindByListBox()
    {
        sqlcon = new SqlConnection(strCon);
        sqlcom = new SqlCommand("proc_clairvoyant_table_new", sqlcon);
        sqlcom.CommandType = CommandType.StoredProcedure;
        sqlcom.Parameters.Add("@TabName", SqlDbType.VarChar, 50).Value = "员工信息表";//表名
        sqlcom.Parameters.Add("@head", SqlDbType.VarChar, 50).Value = Session["Row"].ToString();//行字段
        sqlcom.Parameters.Add("@Data", SqlDbType.VarChar, 50).Value = Session["Data"].ToString();//数值字段
        sqlcom.Parameters.Add("@Bunch", SqlDbType.VarChar, 1000).Value = ListBox1.SelectedValue + ",";//添加的多字段
        sqlcom.Parameters.Add("@Amount", SqlDbType.Int, 50).Value = 1;
        myda = new SqlDataAdapter();
        myda.SelectCommand = sqlcom;
        myds = new DataSet();
        myda.Fill(myds);
        GridView1.DataSource = myds;
        GridView1.DataBind();
    }
    //绑定员工姓名
    protected void Fieldbind()
    {
        for (int i = 0; i < Session.Count - 1; i++)
        {
            ListBox1.Items.Add(Session[i].ToString());
        }
    }
}