|
||
This code example shows how a form record can be deleted.
[C#]
using CMS.FormEngine; using CMS.SettingsProvider; using CMS.DataEngine; using CMS.GlobalHelper;
...
string bizFormName = "TestingSiteContactUs"; string siteName = "CMSTestingSite";
// Get Form 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 Form 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);
BizFormItemProvider bProvider = new BizFormItemProvider(); // Get the record with specified ID BizFormItem formRecord = bProvider.GetItem(formRecordID, dci.ClassName); if (formRecord != null) // Delete the first record formRecord.Delete();
// Update number of entries in BizFormInfo BizFormInfoProvider.RefreshDataCount(bfi.FormName, bfi.FormSiteID);
lblInfo.Text = "The record was deleted successfully."; } } else { lblInfo.Text = "No data found."; } } } |