我给listctrl分页，但是，分页的下一页对，上一页不对，请大家帮忙看一下代码，谢谢！！

[liujin1234]

这是上一页这个有错误，但是不知道哪错了？不是语法错误，是逻辑上的错误

void CPropPage1::OnButton1() 
{
	//CStaticName::a--;
	if (CStaticName::a==0)
	{
		MessageBox("这是首页！");
        GetDlgItem(IDC_BUTTON1)->EnableWindow(false);
        CStaticName::a=1;
	}else{
	try
	{
		m_pConnection.CreateInstance("ADODB.Connection");
		CString strConnect="Provider=Microsoft.Jet.OLEDB.4.0;\
			Data Source=Database\\City.mdb;Persist Security Info=False";
		m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
	}
	catch(_com_error e)
	{
		AfxMessageBox("数据库连接",0,0);
	}
    CStaticName::a--;
	int n=13*CStaticName::a;
	m_pRecordset.CreateInstance(__uuidof(Recordset));
	m_pRecordset_count.CreateInstance(__uuidof(Recordset));
	
	CString sql1;
	sql1.Format("select count(*) as num from Zu where name = '%s' ",TreeCurrent);
	
	_variant_t   vt1;   
	vt1.vt   =   sql1.IsEmpty() ? VT_NULL:VT_BSTR;   
	vt1.bstrVal  = sql1.AllocSysString();
	

	CString num;
	m_pRecordset_count->Open(vt1,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	if(!m_pRecordset_count->adoEOF){
		num=(LPCTSTR)(_bstr_t)m_pRecordset_count->GetCollect("num");
		
		
	}
	

	
	if (1==CStaticName::a)
	{
		MessageBox("到首页！");
		GetDlgItem(IDC_BUTTON1)->EnableWindow(false); 
	}else{

			GetDlgItem(IDC_BUTTON1)->EnableWindow(true);
			GetDlgItem(IDC_BUTTON2)->EnableWindow(true);
		CString sql;
		sql.Format("select top 13 ID,Name,ParentItem,SecNum,tel   from Zu where    ID1 not in (select  top %d   ID1  from Zu where  name = '%s' order by ID1 desc) and name = '%s' order by ID1 desc",n,TreeCurrent,TreeCurrent);
		
		_variant_t   vt;   
		vt.vt   =   sql.IsEmpty() ? VT_NULL:VT_BSTR;   
		vt.bstrVal  = sql.AllocSysString();
		
	
		
		m_pRecordset->Open(vt,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
		//删除所有列
		m_ctrllist.DeleteAllItems();
		int nIndex=0;
		
		while(!m_pRecordset->adoEOF && nIndex<13)
		{
			CString id=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ID");
			CString name=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Name");
			vt = m_pRecordset->GetCollect("ParentItem");
			CString parentitem=(vt.vt!=VT_NULL)?(LPCTSTR)(_bstr_t)vt:"";
			vt = m_pRecordset->GetCollect("SecNum");
			CString secnum=(vt.vt!=VT_NULL)?(LPCTSTR)(_bstr_t)vt:"";
			vt = m_pRecordset->GetCollect("tel");
			CString tel=(vt.vt!=VT_NULL)?(LPCTSTR)(_bstr_t)vt:"";
			
			m_ctrllist.InsertItem(nIndex,id);
			m_ctrllist.SetItemText(nIndex,1,name);
			m_ctrllist.SetItemText(nIndex,2,parentitem);
			m_ctrllist.SetItemText(nIndex,3,secnum);
			m_ctrllist.SetItemText(nIndex,4,tel);
			nIndex++;
			m_pRecordset->MoveNext();
		}
		m_pRecordset->Close();
	   
		
		}
	}
}

下面的是下一页，，是正确的

void CPropPage1::OnButton2() 
{

	

		try
		{
			m_pConnection.CreateInstance("ADODB.Connection");
			CString strConnect="Provider=Microsoft.Jet.OLEDB.4.0;\
				Data Source=Database\\City.mdb;Persist Security Info=False";
			m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
		}
		catch(_com_error e)
		{
			AfxMessageBox("数据库连接",0,0);
		}
		int n=13*CStaticName::a;
		m_pRecordset.CreateInstance(__uuidof(Recordset));
        m_pRecordset_count.CreateInstance(__uuidof(Recordset));
        
		CString sql1;
		sql1.Format("select count(*) as num from Zu where name = '%s' ",TreeCurrent);
		
		_variant_t   vt1;   
		vt1.vt   =   sql1.IsEmpty() ? VT_NULL:VT_BSTR;   
		vt1.bstrVal  = sql1.AllocSysString();
		
		//	CStaticName::a++;
		CString num;
		m_pRecordset_count->Open(vt1,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
		if(!m_pRecordset_count->adoEOF){
               num=(LPCTSTR)(_bstr_t)m_pRecordset_count->GetCollect("num");
			  
			  
		}
       
		int   value;  
        sscanf((LPCTSTR)num,   "%d",   &value);
		int temp=value%13;
		int page=value/13;
		if(temp!=0)
		{
             page=page+1; 
		}
		
        if (page==CStaticName::a)
        {
			MessageBox("到末页！");
            GetDlgItem(IDC_BUTTON2)->EnableWindow(false); 
        }else{
			GetDlgItem(IDC_BUTTON1)->EnableWindow(true);
				GetDlgItem(IDC_BUTTON2)->EnableWindow(true);
		CString sql;
		sql.Format("select top 13 ID,Name,ParentItem,SecNum,tel   from Zu where    ID1 not in (select  top %d   ID1  from Zu where  name = '%s' order by ID1 desc) and name = '%s' order by ID1 desc",n,TreeCurrent,TreeCurrent);
		
		_variant_t   vt;   
		vt.vt   =   sql.IsEmpty() ? VT_NULL:VT_BSTR;   
		vt.bstrVal  = sql.AllocSysString();
		
	   //	CStaticName::a++;

		m_pRecordset->Open(vt,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
		//删除所有列
		m_ctrllist.DeleteAllItems();
		int nIndex=0;
	
		while(!m_pRecordset->adoEOF && nIndex<13)
		{
			CString id=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ID");
			CString name=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Name");
			vt = m_pRecordset->GetCollect("ParentItem");
			CString parentitem=(vt.vt!=VT_NULL)?(LPCTSTR)(_bstr_t)vt:"";
			vt = m_pRecordset->GetCollect("SecNum");
			CString secnum=(vt.vt!=VT_NULL)?(LPCTSTR)(_bstr_t)vt:"";
			vt = m_pRecordset->GetCollect("tel");
			CString tel=(vt.vt!=VT_NULL)?(LPCTSTR)(_bstr_t)vt:"";
			
			m_ctrllist.InsertItem(nIndex,id);
			m_ctrllist.SetItemText(nIndex,1,name);
			m_ctrllist.SetItemText(nIndex,2,parentitem);
			m_ctrllist.SetItemText(nIndex,3,secnum);
			m_ctrllist.SetItemText(nIndex,4,tel);
			nIndex++;
			m_pRecordset->MoveNext();
		}
		m_pRecordset->Close();
         CStaticName::a++;
	
		}
	
}

[liangxd09]

怎么个错法，代码倒是没错，调不了不能帮你调，调进去看看参数都对吗

[liujin1234]

楼上的，谢谢你回答，我看着也都正确，但是不知道怎么的，就是不对，肯定由一个地方错了，

[峰白]

按F5调试一下，错误出现的时候查看“call stack”,看看哪一行出的错误

[Conry]

没看见你根据当前页数来移动记录指针，就从你的循环来看，就是取的前13个记录

[峰白]

又看了下，如果CStaticName::a=1的情况下运行OnButton1()

那么运行到这里时：CStaticName::a--;
int n=13*CStaticName::a;

n的值为0；然后运行到这里：

sql.Format("select top 13 ID,Name,ParentItem,SecNum,tel from Zu where ID1 not in \
(select top %d ID1 from Zu where name = '%s' order by ID1 desc) and name = '%s' order by ID1 desc",n,TreeCurrent,TreeCurrent);

得到的语句也不是你想设置的。

你应该：
if (CStaticName::a<=1)//这里改一下
{
MessageBox("这是首页！");
GetDlgItem(IDC_BUTTON1)->EnableWindow(false);
CStaticName::a=1;
return;
}

然后下面就不用判断CStaticName::a==1了

[liujin1234]

沙发

[liujin1234]

有人回答吗？谢谢

[高人一筹]

沙发 来顶顶 哥们我也在学这个有时间可以教教我么 可以得话 加下QQ以后有VC问题好问下你 呵呵 531802884
更欢迎各位高手可以给我提供指导

[liyunyan0219]

看看先