CString nr,Hr,Sr;
Hr= m_List.GetItemText(pNMListView->iItem,0);//得到第一列那行的表项
strtemp.Format("第%d行%s第%d列%s",pNMListView->iItem,Hr, pNMListView->iSubItem,Sr);
strtemp= strtemp +"插入"+nr;
AfxMessageBox(strtemp);
CString SQL;
SQL.Format("UPDATE DemoTable SET %s = '%s' WHERE 代码 = '"+Hr+"'", Sr,nr);
AfxMessageBox(SQL);
_variant_t RecordsAffected;
m_pConnection->Execute((_bstr_t)SQL,&RecordsAffected,adCmdText);
//////
str="删除列"+name;
sql = "alter table DemoTable drop column ";
sql= sql +""+name+"";
name = g_str;
str="加入列"+name;
CString strSQL;
strSQL.Format("alter table DemoTable add column %s ", name);
strSQL=strSQL+ "VARCHAR(100) NULL";
///
m_pRecordset->MoveFirst();
m_pRecordset->Move(m_nIndex);
// 删除当前行记录
m_pRecordset->Delete(adAffectCurrent);
m_pRecordset->Update();
///
var = m_pRecordset->GetCollect(_variant_t(strColName));
strColName为变量