sqldsinsertcode.aspx.cs

《圣殿祭司的ASP.NET 2.0开发详解——使用C#》光盘内容.包含了书籍所含的源代码.非常经典的一本asp.net2.0的书籍

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;
using System.Data.Common;

public partial class sqldsInsertCode : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

	protected void btnInsert_Click(object sender, EventArgs e)
	{
		InsertEmployees();
	}

	protected void InsertEmployees()
	{
		//声明InsertParameter
		sqldsEmployees.InsertCommand = "INSERT INTO Employees(LastName, FirstName, City, Address) VALUES (@paramLastName,@paramFirstName,@paramCity,@paramAddress)";

		sqldsEmployees.InsertParameters.Add("paramLastName", TypeCode.String, "");
		sqldsEmployees.InsertParameters.Add("paramFirstName", TypeCode.String, "");
		sqldsEmployees.InsertParameters.Add("paramCity", TypeCode.String, "");
		sqldsEmployees.InsertParameters.Add("paramAddress", TypeCode.String, "");


		try
		{
			for (int i = 1; i < 100; i++)
			{
				sqldsEmployees.InsertParameters["paramLastName"].DefaultValue = "LName" + i.ToString();
				sqldsEmployees.InsertParameters["paramFirstName"].DefaultValue = "FName" + i.ToString();
				sqldsEmployees.InsertParameters["paramCity"].DefaultValue = "City" + i.ToString();
				sqldsEmployees.InsertParameters["paramAddress"].DefaultValue = "Address" + i.ToString();
				sqldsEmployees.Insert();
			}
			showMsg("事务成功，已确认事物！");
		}
		catch
		{
			showMsg("事务失败，并回复事务！");
		}
	}

	protected void sqldsEmployees_Inserting(object sender, SqlDataSourceCommandEventArgs e)
	{
		DbCommand cmd = e.Command;	//取得SqlDataSource的SqlCommand对象
		DbConnection conn = cmd.Connection;	//取得SqlCommand的数据库连接
		conn.Open();	//打开数据库连接
		DbTransaction tran = conn.BeginTransaction();	//声明Transaction事务
		cmd.Transaction = tran;	//指定SqlCommand使用Transaction事务
	}

	protected void sqldsEmployees_Inserted(object sender, SqlDataSourceStatusEventArgs e)
	{
		if (e.Exception == null)
		{
			e.Command.Transaction.Commit();
		}
		else
		{
			e.Command.Transaction.Rollback();
		}
	}

	protected void showMsg(string AlertMessage)
	{
		Literal txtMsg = new Literal();
		txtMsg.Text = "<script>alert('" + AlertMessage + "')</script>" + "<BR/>";
		Page.Controls.Add(txtMsg);
	}
}