Beginning C# 2008 Databases 笔记（三）

CHAPTER 8 Understanding Transactions
了解事务

你能使用除了一下这些的 T-SQL statements 在一个事务中：
ALTER DATABASE, RECONFIGURE, BACKUP, RESTORE, CREATE DATABASE, UPDATE STATISTICS, and
DROP DATABASE.
Also, you cannot use sp_dboption to set database options or use any system procedures
that modify the master database inside explicit or implicit transactions.

• BEGIN TRANSACTION:       开始
• COMMIT TRANSACTION:     成功
• ROLLBACK TRANSACTION: 失败
@@ERROR 返回错误编号，成功返回 0。

Code
-- If an error occurred, roll back
if @maxerr <> 0
  begin
    rollback
    print 'Transaction rolled back'
  end
else
  begin
    commit
    print 'Transaction committed'
  end

ado.net
try
{
  // open connection
  conn.Open();
  // begin transaction
  SqlTransaction sqltrans = conn.BeginTransaction();
  // 干嘛干嘛
  
  
  // commit transaction
  sqltrans.Commit();  
}
catch (System.Data.SqlClient.SqlException ex)
{
  // roll back transaction
  sqltrans.Rollback();
  MessageBox.Show(
"Transaction rolled back\n" + ex.Message,
"Rollback Transaction");
}
catch (System.Exception ex)
{
  MessageBox.Show("System Error\n" + ex.Message, "Error");
}
finally
{
  // close connection
  conn.Close();
}

CHAPTER 9 Getting to Know ADO.NET


SqlTypes            Maps SQL Server data types to .NET types

CHAPTER 10 Making Connections

data source = .\sqlexpress
server = .\sqlexpress
address = .\sqlexpress
addr = .\sqlexpress
network address = .\sqlexpress