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)
    {
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "" || TextBox4.Text == "" || TextBox5.Text == "" || TextBox6.Text == "" || TextBox7.Text == "" || TextBox8.Text == "" || TextBox9.Text == "")
        {
            Response.Write("<script language=javascript>alert('不允许输入空数据！');location='javascript:history.go(-1)'</script>");
        }
        SqlConnection con = new SqlConnection("server=(local);user id=sa;pwd=;DataBase=db_07");
        con.Open();
        //通过SqlConnection的BeginTransaction方法创建名为st的对象Transaction
        SqlTransaction st = con.BeginTransaction();
        SqlCommand com = con.CreateCommand();
        //将SqlTransaction对象分配给SqlCommand对象的Transaction属性
        com.Transaction = st;
        try
        {
            //向表1插入数据
            com.CommandText = "insert into tb_21a(name,age,sex)values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')";
            com.ExecuteNonQuery();
            //向表2插入数据
            com.CommandText = "insert into tb_21b(name,age,sex)values('" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "')";
            com.ExecuteNonQuery();
            //向表3插入数据
            com.CommandText = "insert into tb_21c(name,age,sex)values('" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "')";
            com.ExecuteNonQuery();
            //提交事物
            st.Commit();
            Response.Write("<script language=javascript>alert('添加成功！');location='javascript:history.go(-1)'</script>");
        }
        catch (Exception error)
        {
            //回滚事物
            st.Rollback();
        }
        finally
        {
            con.Close();
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
        TextBox5.Text = "";
        TextBox6.Text = "";
        TextBox7.Text = "";
        TextBox8.Text = "";
        TextBox9.Text = "";
    }
}