#region 连接数据库练习
SqlConnection con = new SqlConnection();
con.ConnectionString = "server=.;database=LDTEST;uid=binggo_admin;pwd=12345678";
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.Text;
com.CommandText = "select top 1000 * from people ";
SqlDataReader dr = com.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
dr.Close();
foreach (DataRow item in dt.Rows)
{
Console.WriteLine(item["name"].ToString() + "的年龄是" + item["age"].ToString());
}
#endregion
#region 插入外加事务
Console.WriteLine("插入标记:");
SqlConnection coninert = new SqlConnection();
coninert.ConnectionString = "server=.;database=LDTEST;uid=binggo_admin;pwd=12345678";
coninert.Open();
SqlCommand cominsert = new SqlCommand();
cominsert.Connection = coninert;
cominsert.CommandType = CommandType.Text;
SqlTransaction myTran;
myTran = coninert.BeginTransaction();
cominsert.Transaction = myTran;
string sql1 = @"
INSERT INTO dbo.People
(ID, name, sex, age)
VALUES('96325852', --ID - varchar(max)
'事务第一个', --name - varchar(max)
0, --sex - bit
'20'-- age - varchar(max)
)";
cominsert.CommandText = sql1;
int insert1 = cominsert.ExecuteNonQuery();
string sql2 = @"
INSERT INTO dbo.People
(ID, name, sex, age)
VALUES('96325853', --ID - varchar(max)
'事务第一个', --name - varchar(max)
0, --sex - bit
'20'-- age - varchar(max)
)";
cominsert.CommandText = sql2;
int insert2 = cominsert.ExecuteNonQuery();
insert2 = -1;
if (insert1 > 0 && insert2 > 0)
{
myTran.Commit();
}
else
{
myTran.Rollback();
}