ADO.net - 事务使用范例

来源：互联网发布：javascript的定时函数编辑：程序博客网时间：2024/05/01 09:46
using (SqlConnection con = new SqlConnection(conStr))
            {
                con.Open();

                using (SqlTransaction tran = con.BeginTransaction())
                {
                    using (SqlCommand com = new SqlCommand("", con, tran))
                    {
                        try
                        {
                            Guid id = Guid.NewGuid();

                            com.Parameters.Add(new SqlParameter("id", id));
                            com.Parameters.Add(new SqlParameter("targetId", form.TargetId));
                            com.Parameters.Add(new SqlParameter("fileName", form.FileName));
                            com.Parameters.Add(new SqlParameter("fileName1", form.FileName1));

                            com.Parameters.Add(new SqlParameter("Name", form.Name));
                            com.Parameters.Add(new SqlParameter("CUserId", form.CUserId));

                            com.CommandText = "insert into dbo.cs_UploadFiles([Id],[TargetId],[FileName],[FileName1]) values(@id,@targetId,@fileName,@fileName1)";

                            com.ExecuteNonQuery();

                            com.CommandText = "insert into dbo.cs_Infos([Id],[TargetId],[Name],[CUserId]) values(@id,@targetId,@Name,@CUserId)";

                            com.ExecuteNonQuery();

                            tran.Commit();
                            return 1;
                        }
                        catch
                        {
                            tran.Rollback();
                            return 0;
                        }
                    }
                }
            }
0 0