插入的時候資料插入不全有些還是空白填充不知道什么原因了大家幫我看一下謝謝了
uj5u.com熱心網友回復：
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);
}
uj5u.com熱心網友回復：
這是我寫的代碼除錯各項的值沒問題就是插入的時候有些顯示有些沒有uj5u.com熱心網友回復：
先保證在查詢分析器中手動執行插入沒問題。轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/120625.html
標籤：數據庫