• Decrease Text SizeIncrease Text Size

Delete Records from the module.

Posted Date: 5/2/2023
    Printer Friendly Version   Email A Friend   Add This   Increase Text Size   Decrease Text Size

How do I delete records in Centralpoint Module



string executeConnectionString = @"Data Source=SERVER;Initial Catalog=cpweb_WebSite;User Id=cpsys_Execute;Password=Password;";
using (SqlConnection connect = new SqlConnection(executeConnectionString))
{
	Centralpoint.Web.Cms.DataCurrent data = new Centralpoint.Web.Cms.DataCurrent(connect);
	Guid batchId = new Guid("48b96c91-a2d8-4456-ba42-76ab08408f99");
	Guid moduleId = new Guid("a53c6782-0358-4531-bcbb-8d02b56f3987");
	Guid dataId = new Guid("1088888c-91f9-4403-86e3-9f1c67cd42d5");
	string filter = "Title LIKE '%My Test'";
	
	//this will delete all records from Module based on moduleId.
	data.Delete(moduleId, executeConnectionString);
	
	//This will delete all records from DataCurrent Table with the same batchId.
	data.Delete(batchId, moduleId, executeConnectionString);
	
	//This will delete just one record from a specific module based on the moduleId and dataId.
	data.Delete(Guid.Empty, moduleId, dataId, executeConnectionString);
	
	//This will delete all records from DataCurrent Table based on moduleId and SQL filter.
	data.Delete(Guid.Empty, moduleId, Guid.Empty, filter, executeConnectionString);
}






Related Taxonomy
  - How Do I?
  - Questions

Comments:

Be the first to leave a comment.
Please Login to post comments.