一:ADOTable1->Active=true;
ADOTable1->First();
while(!ADOTable1->Eof)
{
ADOTable1->Delete();
}
二:sql="delete from table";
执行这个语句就可以了。
三:CommandPtr com;
com.CreateInstance(__uuidof9Command));
com.ActionConnection=....
com->CommandText="delete * from Tablname"
com->Excute(NULL,NULL,adCmdText);
四:_RecordsetPtr m_pRec;
.....
m_pRec->Open("truncate table table_name", adCmdText,adOpenStatic, adLockOptimistic
自己的程序:
try
{
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open("delete from picture",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
m_listGrid.DeleteAllItems();
MessageBox("清空成功");
}
catch(...)
{
MessageBox("清空失败");
}