tran.aspx.cs

数据库连接查询

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Linq;
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.Xml.Linq;
using System.IO;
using System.Transactions;
using System.Data.Common;

public partial class tran : System.Web.UI.Page
{
    NorthwindDataContext ctx = new NorthwindDataContext("server=srv-devdbhost;database=Northwind;uid=sa;pwd=Abcd1234");

    protected void Page_Load(object sender, EventArgs e)
    {
        StreamWriter sw = new StreamWriter(Server.MapPath("tran.txt"), false);
        ctx.Log = sw;

        //if (ctx.Connection != null) ctx.Connection.Open();
        //DbTransaction tran = ctx.Connection.BeginTransaction();
        //ctx.Transaction = tran;
 
        using (TransactionScope scope = new TransactionScope())
        {
            try
            {
                CreateCustomer(new Customer { CustomerID = "abcdf", CompanyName = "zhuye" });
                CreateCustomer(new Customer { CustomerID = "abcde", CompanyName = "zhuye" });
            }
            catch { }
            scope.Complete();
        }
   
        //try
        //{
        //    CreateCustomer(new Customer { CustomerID = "abcdf", CompanyName = "zhuye" });
        //    CreateCustomer(new Customer { CustomerID = "abcde", CompanyName = "zhuye" });
        //    tran.Commit();
        //}
        //catch
        //{
        //    tran.Rollback();
        //}
        sw.Close();
        
    }

    private void CreateCustomer(Customer c)
    {
        ctx.Customers.Add(c);
        ctx.SubmitChanges();
    }
}