Do not use the CDelete class directly. Use the preallocated WIDatabase.Delete variable instead.
Namespace: Wiker.WIDatabaseFunctions to Delete records from tables.
Assembly:
Syntax
C# |
---|
public class CDelete : CConditionCommon |
Visual Basic |
---|
Public Class CDelete _ Inherits CConditionCommon |
Visual C++ |
---|
public ref class CDelete : public CConditionCommon |
Examples

WIDatabase WIDB; CDatabaseInfo DBInfo; /* Create CDatabaseInfo object and populate with database login info */ DBInfo = new CDatabaseInfo(); DBInfo.DatabaseType = eDatabaseType.SQL; DBInfo.Location = "SqlServer"; DBInfo.DBName = "TestDatabase"; DBInfo.Username = "LoginName"; DBInfo.Password = "LoginPassword"; /* Create new instance of WIDatabase */ WIDB = new WIDatabase(DBInfo); /* Set table name to delete from */ WIDB.Delete.Table("tblTableName"); /* Set Condition (WHERE) cause */ WIDB.Delete.Condition("LastName", eOperator.EndsWith, "ton"); /* Deletes all records in table 'tblTableName' where column 'LastName' ends with 'ton' */ if (!WIDB.Delete.Execute()) { MessageBox.Show(string.Format("Failed To Delete records\n{0} - {1}", WIDB.LastError.ToString(), WIDB.LastErrorMessage)); } WIDB.Close();