VC 删除SQL中的数据

hxg130435477

于 2008-06-13 08:46:00 发布

阅读量845

点赞数

分类专栏：技术文章标签： sql delete null list

本文链接：https://blog.csdn.net/hxg130435477/article/details/2542345

版权

技术专栏收录该内容

58 篇文章 2 订阅

订阅专栏

if(0 == m_list.GetSelectedCount()) { MessageBox("ÇëÑ¡ÔñÄúÒªÐÞ¸ÄµÄÔ±¹¤!!~~~","ÌáÊ¾ÐÅÏ¢",MB_ICONASTERISK | MB_OK); return; } int n; CString sql; // sql.Format("delete from serverloadtbl where serverno = %d"); sql = "delete from serverloadtbl where serverno = '"; sql += strServerNo + "'"; n = m_list.GetSelectionMark(); strServerNo = m_list.GetItemText(n,0);

sql = "delete from serverloadtbl where serverno = '"; sql += strServerNo + "'"; //MessageBox(sql); if(m_R->State == adStateOpen) m_R->Close(); m_C->CommandText= _bstr_t(sql); m_C->CommandType=adCmdText; m_C->Parameters->Refresh(); m_C->Execute(NULL,NULL,adCmdUnknown); //m_C->Release(); //m_C->Execute(_bstr_t(sql),NULL,adCmdText,m_P); MessageBox("É¾³ý³É¹¦","ÌáÊ¾",MB_ICONINFORMATION | MB_OK); ClearCListCtrl(&m_list);

//m_list.DeleteAllItems(); // // int i_n; // i_n = m_list.GetHeaderCtrl()->GetItemCount(); // // for(int i = 0 ; i <= i_n; i++) // { // m_list.DeleteColumn(0); // }

CAddServerDlg::OnInitDialog();