用ado循环取各clistctrl多行数据并插入sqlserver数据库问题

Question

插入的时候数据插入不全有些还是空白填充不知道什么原因了大家帮我看一下谢谢了

Answer 1

CString Order;
CString Addressee;
CString MaiID;
CString Address;
CString Express;
CString ExpressNumber;
CString strSQL;
_variant_t RecordsAffected;
int i=0;
int ncount=p_list.GetItemCount();
strSQL.Format(_T("INSERT INTO order1info(order1,addressee,maiid,address,express)VALUES('%s','%s','%s','%s','%s')"),Order,Addressee,MaiID,Address,Express);
try
{
m_pconnection.CreateInstance("ADODB.Connection");
m_pconnection->ConnectionString=_T("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=QH-20160810ZMWN\\SQLEXPRESS");
m_pconnection->Open("","","",adModeUnknown);        //--循环插入数据--//
while (i<ncount)
{ Order=p_list.GetItemText(i,0);
Addressee=p_list.GetItemText(i,1);
MaiID=p_list.GetItemText(i,2);
Address=p_list.GetItemText(i,3);
Express=p_list.GetItemText(i,4);
ExpressNumber=p_list.GetItemText(i,5);
int ll=0;
m_pconnection->Execute((_bstr_t)strSQL,&RecordsAffected,adCmdText);
++i;
}

}
catch (_com_error ee)
{
CString errormessagee;
errormessagee.Format(_T("连接数据库插入时失败!\r\n错误信息:%s"),ee.ErrorMessage());
AfxMessageBox(errormessagee);
}