Пример #1
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string        fileName = "文件名";
        ResultDataSet Rs2      = new ResultDataSet();
        database_inte db2      = new database_inte();

        ClsData dbobj = db2.DB2Obj;

        dbobj.BeginTrans("test");
        string sql1 = "insert into FileInfo (fileName,fileSize) values ('" + fileName + "','50')";
        string sql2 = "insert into FileType (typeName,parentID) values ('标题',0)";

        if (!dbobj.GetRs(sql1, out Rs2))
        {
            dbobj.RollBack("test");
            return;
        }
        if (!dbobj.GetRs(sql2, out Rs2))
        {
            dbobj.RollBack("test");
            Label1.Text = "失败";
            return;
        }
        if (dbobj.CommitTrans("test") == false)
        {
            dbobj.RollBack("test");
            Label1.Text = "失败";
            return;
        }

        Label1.Text = "成功";
    }