sql 数据库连接 暨 ado.net 小例

1. using System;
2. using System.Collections.Generic;
3. using System.Text;
4. using System.Data;
5. using System.Data.SqlClient;
7. namespace CommandDemo
8. {
9.     class Program
10.     {
11.         static void Main(string[] args)
12.         {
13.             SqlConnection connection = new SqlConnection();
14.             SqlTransaction objTrans = null;
15.             connection.ConnectionString = "Persist Security Info=False;User ID=administrator;Password=zenq;Initial Catalog=StuDB;Data Source=.";
16.             try
17.             {
18.                 connection.Open();
20.                 objTrans = connection.BeginTransaction();
22.                 /*SqlCommand sqlCmd = new SqlCommand();
23.                 sqlCmd.Connection = connection;*/
24.                 SqlCommand sqlCmd = connection.CreateCommand();
25.                 sqlCmd.Transaction = objTrans;
26.                 sqlCmd.CommandType = CommandType.Text;
27.                 sqlCmd.CommandText = "insert into Students(Name,Sex,Birthday) values('Jone',1,'2005-5-1')";
29.                 sqlCmd.ExecuteNonQuery();
31.                 sqlCmd.CommandText = "insert into Students(Name,Sex,Birthday) values('Jone',1,'2005-5-1')";
32.                 sqlCmd.ExecuteNonQuery();
34.                 objTrans.Commit();
35.                 Console.WriteLine("添加成功!");
36.             }
37.             catch (SqlException ex)
38.             {
39.                 Console.WriteLine(ex.Message);
40.                 if (objTrans != null)
41.                 {
42.                     objTrans.Rollback();
43.                 }
44.             }
45.             finally
46.             {
47.                 if (connection.State != ConnectionState.Open)
48.                 {
49.                     connection.Close();
50.                 }
51.             }
53.             Console.ReadKey();
54.         }
55.     }
56. }