|
阅读:939回复:0
各位,请教一个MapX+VC ADO绑定Access数据库的问题
<P>请问在VC环境下怎么用ADO+MapX绑定Access数据库呢??</P>
<P>我的作法是:</P> <P>先声明_ConnectionPtr pConn;<BR> _RecordsetPtr pRecordSet;</P> <P>接着</P> <P>if(FAILED(pConn.CreateInstance(_T("ADODB.Connection")))) {<BR> AfxMessageBox(_T("Create Instance Failed"));<BR> return -1;<BR> }</P> <P> CString strConnection;<BR> strConnection=_T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=");<BR> strConnection+=clientPath;<BR> strConnection+=_T("\\成都.mdb");<BR> _bstr_t bstrConnection(strConnection);<BR> if(FAILED(pConn->Open(bstrConnection,_T(""),_T(""),-1))) {<BR> AfxMessageBox(_T("Can't Open Database"));<BR> pConn->Release();<BR> return -1;<BR> }</P> <P> if(FAILED(pRecordSet.CreateInstance(_T("ADODB.Recordset")))) {<BR> AfxMessageBox(_T("Create Instance Failed"));<BR> return -1;<BR> }</P> <P><BR> CString strSQL;<BR> strSQL=_T("Select * from Food");<BR> _variant_t varSQL(strSQL);</P> <P> if(FAILED(pRecordSet->Open(varSQL,pConn.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText))) {<BR> AfxMessageBox(_T("Open Table Failed"));<BR> pRecordSet->Release();<BR> return -1;<BR> }<BR> </P> <P>到目前为止都没有问题~~因为我用pRecordSet调试可以得到成都.mdb中的表的内容~~</P> <P>关键是接下去的MapX.GetDatasets().Add该怎么写呢?</P> <P>我想绑定的图层名为"food"</P> |
|