vc+mapx数据绑定一例(头痛),请高手指点

楼主^#

更多发布于：2004-12-10 02:06

下面的程序不知为何总是不能实现数据绑定,请大家和斑竹帮忙分析一下,在此万分感激!!!
cdaodatabase cgeoexpertview::s_db;


void cgeoexpertview::onadddata()
{
cstringlist tables;
const cstring dbpath ="g:\\geoexpert\\mapstats.mdb";
s_db.open(dbpath);
cdaodatabase* db = ;s_db;
if(db == null)
 {
 afxmessagebox("wrong");
 return;
}
 int ncount = db->gettabledefcount();
cdaotabledefinfo info;
for(int i = 0; i < ncount; i++)
{
db->gettabledefinfo(i, info);
if(!(info.m_lattributes ; dbsystemobject) ;; !(info.m_lattributes ;dbhiddenobject))
tables.addtail(info.m_strname);
}
if(;m_ctrlmapx == null)
 {
 afxmessagebox("add data called without a map control");
 return;
}
 // then, remove all the tables which we've already added as datasets.
cmapxdatasets datasets = m_ctrlmapx.getdatasets();
ncount = datasets.getcount();
for(i = 1; i <= ncount; i++) {
 position pos = tables.find(datasets.item(i).getname());
 if(pos != null)
 tables.removeat(pos);
}

if(tables.getcount() == 0) {
 afxmessagebox("no tables left to add");
 return;
}
 coptionalvariant optvt;
cdaorecordset rs(;s_db);
 colevariant rsvt;
 rs.open(dbopentable, "usa");
rsvt.vt = vt_dispatch;
rsvt.pdispval = rs.m_pdaorecordset;
rsvt.pdispval->addref();

colevariant titlevt("usa");

colevariant geofieldvt;
 geofieldvt = "state_name";

 cmapxbindlayer bindlyr;
colevariant bindlayervt;
if(!bindlyr.createdispatch(bindlyr. getclsid()))
{
 trace0("failed to create bindlayer object");
 return;
}
 bindlayervt.vt = vt_dispatch;
 bindlayervt.pdispval = bindlyr.m_lpdispatch;
 bindlayervt.pdispval->addref();
 bindlyr.setlayertype(mibindlayertypenormal);
bindlyr.setlayername("usa");
 cmapxfields fields;
 colevariant fieldsvt;
 if(!fields.createdispatch(fields.getclsid()))
{
 trace0("failed to create bindlayer object");
 return;
}
 fields.add("totpop", "totpop");
 fieldsvt.vt = vt_dispatch;
fieldsvt.pdispval = fields.m_lpdispatch;
fieldsvt.pdispval->addref();
 try {
 theapp.dowaitcursor(1);
 if(;m_ctrlmapx != null)
 m_ctrlmapx.getdatasets().add(midatasetdao, rsvt, titlevt, geofieldvt, optvt, bindlayervt, fieldsvt, optvt);
 theapp.dowaitcursor(0);
} catch(coledispatchexception* e) {
 e->reporterror();
 e->delete();
} catch(coleexception* e) {
 e->reporterror();
 e->delete();
}
}

<IMG align=middle border=0 src="http://www.lbschina.com.cn/forum/emot/em31.gif"><img src="images/post/smile/dvbbs/em15.gif" />

喜欢0 评分0

举报回复

teleinfor

路人甲

注册日期2004-09-14
发帖数45
QQ
铜币242枚
威望0点
贡献值0点
银元0个

加关注写私信

1楼^#

发布于：2004-12-10 15:56

具体抛出什么异常？？？我是利用的ADO绑定数据库，另外对mapx对象你利用_variant_t操作转换一下传入。应该没什么问题，这块的数据帮定应该容易。举个例子吧：CMapXBindLayer BindLayer; //= new CMapXBindLayer();
 BindLayer.CreateDispatch(BindLayer.GetClsid());
 BindLayer.SetLayerName(strLayerName.c_str());
 BindLayer.SetRefColumn1("Longitude");
 BindLayer.SetRefColumn2("Latitude");
 BindLayer.SetLayerType(miBindLayerTypeXY);// COleVariant BindLayer;
// BindLayer.vt = VT_DISPATCH;
// BindLayer.pdispVal = pBindLayer->m_lpDispatch;
// BindLayer.pdispVal->AddRef();这段多余的注释掉算了。传入GetDatasets.Add()时候利用_variant_t(BindLayer)数据库额连接，建议你用ADO吧，DAO不懂不用。ADO简单明了。

举报回复喜欢评分

muxingren 路人甲注册日期2004-09-21 发帖数7 QQ 铜币141枚威望0点贡献值0点银元0个加关注写私信	2楼^# 发布于：2004-12-19 10:19 谢谢,我用DAO也解决了:)
	举报回复(0) 喜欢(0) 评分

INTER-11

路人甲

注册日期2004-06-30
发帖数16
QQ
铜币148枚
威望0点
贡献值0点
银元0个

加关注写私信

3楼^#

发布于：2004-12-19 23:31

高手帮忙看一下我这个代码，数据绑定老是出现错误！InValid GeoField specified. Name not fou
nd, or index out of range. 我快发疯了，为什么啊？？图层有一个字段和数据源的某一个字段肯定匹配的。 CMapXODBCQueryInfo QueryInfo;
COleVariant QueryInfoVt;QueryInfo.CreateDispatch(QueryInfo.GetClsid()) QueryInfo.SetConnectString("ODBC;");
QueryInfo.SetDataSource("RoadInformation"); //RoadInformation是数据源名
QueryInfo.SetSqlQuery("select * from ROADLINE"); //ROADLINE是表名 QueryInfoVt.vt=VT_DISPATCH;
QueryInfoVt.pdispVal=QueryInfo.m_lpDispatch;
QueryInfoVt.pdispVal->AddRef(); CMapXDataset dataSet=m_ctrlMapX.GetDatasets().Add(miDataSetODBC, QueryInfoVt, "Roadlinedataset");

举报回复喜欢评分

您需要登录后才可以回帖，登录或者注册

vc+mapx数据绑定一例(头痛),请高手指点

最新喜欢：