Deleting a record

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

This code example shows how a BizForm record can be deleted.




using CMS.FormEngine;

using CMS.SettingsProvider;

using CMS.DataEngine;

using CMS.GlobalHelper;




      string bizFormName = "TestingSiteContactUs";

      string siteName = "CMSTestingSite";


      // Get BizForm definition

      BizFormInfo bfi = BizFormInfoProvider.GetBizFormInfo(bizFormName, siteName);


      if (bfi != null)


          // Get data type definition

          DataClassInfo dci = DataClassInfoProvider.GetDataClass(bfi.FormClassID);

          if (dci != null)


              // Get all bizform data

              GeneralConnection genConn = ConnectionHelper.GetConnection();

              DataSet ds = genConn.ExecuteQuery(dci.ClassName + ".selectall", null, null, null);


              if (!DataHelper.DataSourceIsEmpty(ds))


                  // Get ID of the first record

                  int formRecordID = ValidationHelper.GetInteger(ds.Tables[0].Rows[0][0], 0);

                  // Get the record with specified ID

                  DataClass formRecord = new DataClass(dci.ClassName, formRecordID, genConn);


                  if (!formRecord.IsEmpty())


                      // Delete the first record.



                      // Update number of entries in BizFormInfo




                       lblInfo.Text = "The record was deleted successfully.";





                   lblInfo.Text = "No data found.";





Page url: