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)
        {
            this.loadGridView1();
            this.loadGridView2();
        }
    }
    protected void loadGridView1()
    {
        SqlConnection con = new SqlConnection("server=.;database=mrdb;uid=sa;pwd=;");

        try
        {
            con.Open();
            string sql = "select EmpID,EmpName,Number,Phone from employeeInfo";
            SqlDataAdapter sda = new SqlDataAdapter(sql, con);
            DataSet ds = new DataSet();
            sda.Fill(ds, "employeeInfo");
            GridView3.DataSource = ds;
            GridView3.DataBind();

        }
        catch (Exception error)
        {
           Response.Write(error.Message.ToString());
        }
        finally
        {

            con.Close();
        }
    }
    protected void loadGridView2()
    {
        SqlConnection con = new SqlConnection("server=.;database=mrdb;uid=sa;pwd=;");

        try
        {
            con.Open();
            string sql = "select employeeID,employeeName,employeePay from employeePay";
            SqlDataAdapter sda = new SqlDataAdapter(sql, con);
            DataSet ds = new DataSet();
            sda.Fill(ds, "employeeInfo");
            GridView4.DataSource = ds;
            GridView4.DataBind();

        }
        catch (Exception error)
        {
            Response.Write(error.Message.ToString());
        }
        finally
        {

            con.Close();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("server=.;database=mrdb;uid=sa;pwd=;");
        con.Open();
        string str = "select count(*) from employeeInfo where EmpID='" + TextID.Text.ToString() + "'";
        SqlCommand mycom = new SqlCommand(str, con);
        int intcont = Convert.ToInt32(mycom.ExecuteScalar());
        if (intcont > 0)
        {
            Response.Write("<script language=javascript>alert('对不起!该编号已经存在！')</script>");
            return;
        }
        else
        {
            string sql = "insert into employeeInfo(EmpID,EmpName,Number,Phone)values('" + TextID.Text + "','" + TextName.Text + "','" + TextNumber.Text + "','" + Textphone.Text + "')";
            try
            {
                SqlCommand com = new SqlCommand(sql, con);
                com.ExecuteNonQuery();
                Response.Write("<script language=javascript>alert('插入成功')</script>");
            }
            catch (Exception error)
            {
                Response.Write(error.Message.ToString());
            }
            finally
            {
                con.Close();  //断开连接
                loadGridView1();  //在GridView1里显示员工信息的方法；
                loadGridView2();  //在GridView2里显示员工工资的方法；
            }
        }
    }
}