This code example shows how an existing BizForm record can be modified.
[C#]
using CMS.FormEngine; using CMS.SettingsProvider; using CMS.DataEngine; using CMS.GlobalHelper;
...
string bizFormName = "TestingSiteContactUs"; string siteName = "CMSTestingSite";
// Read BizForm definition BizFormInfo bfi = BizFormInfoProvider.GetBizFormInfo(bizFormName, siteName);
if (bfi != null) { // Read 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 ID of the first row record DataClass formRecord = new DataClass(dci.ClassName, formRecordID, genConn);
if (!formRecord.IsEmpty()) { // Set new field values formRecord.SetValue("FirstName", "Bob"); formRecord.SetValue("LastName", "Marley"); formRecord.SetValue("Email", "bob@email.com"); formRecord.SetValue("Message", "Good job:)"); formRecord.SetValue("FormUpdated", DateTime.Now);
// Save updates in the database formRecord.Update();
lblInfo.Text = "The first record was updated successfully."; } } else { lblInfo.Text = "No data found."; } } } |
Page url: http://devnet.kentico.com/docs/5_5r2/devguide/index.html?api_bizforms_updating_a_record.htm