求简单连接数据库的方法(c++) 大家把自己用vc做数据库的方法贴出来,共同交流一下.我觉得不用控件,用sdk做数据库很困难.试了好几次都不行啊!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 很好做啊。用ODBC比较简单啊。 http://www.vckbase.com/document/viewdoc.asp?id=634 http://www.csdn.net/Develop/Read_Article.asp?Id=16163http://www.vckbase.com/document/listdoc.asp?mclsid=11&sclsid=1105 CDatabase m_database;//定义并链接数据源一般在App里进行if (!m_database.OpenEx("DSN=wwtick00;UID=sa",CDatabase::noOdbcDialog))//gzp;PWD=aaaaaa { AfxMessageBox("数据库连接失败!"); return FALSE; }//定义CRecordset记录集CRecordset m_set(&(pApp->m_database));char sqlbuf[120];sprintf(sqlbuf,"select StationID,StationName from Station where StationType =%d",id);if (m_set.Open(CRecordset::forwardOnly,sqlbuf)){ CDBVariant value; int uid; while (!m_set.IsEOF()) { m_set.GetFieldValue("StationID",value); uid = value.m_iVal; m_set.GetFieldValue("StationName",value); sprintf(trebuf,"%s",*(value.m_pstring)); tvInsert.hParent = hTree; tvInsert.hInsertAfter = TVI_LAST; tvInsert.item.mask = TVIF_TEXT|TVIF_IMAGE|TVIF_PARAM|TVIF_SELECTEDIMAGE; tvInsert.item.pszText = trebuf; tvInsert.item.iImage = 1; tvInsert.item.iSelectedImage = 4; tvInsert.item.lParam = uid; m_wndTree1.InsertItem(&tvInsert); m_set.MoveNext(); } m_set.Close();} 注意,我用的是ODBC方法,你需要配置数据源,建议你用ADO 流ifstream循环打开多个文件出错 怎么获得动态菜单的句柄 [请教]用vc如何将bmp格式的图像转化为pmg格式? 两个星星了,散分。:P GetBuffer和ReleaseBuffer的问题 如何设置按钮的背景颜色(用sdk) 大家知道哪里有达到像word页面预览效果的源程序? SetWindowLong更改ExtStyle后如何让其立即生效? mfc的tab control问题!child dialog的按钮以及初始化不管用 FileView添加类 KillTimer();是做什么用的啊? ADO数据库导入ACCESS的问题
http://www.vckbase.com/document/listdoc.asp?mclsid=11&sclsid=1105
if (!m_database.OpenEx("DSN=wwtick00;UID=sa",CDatabase::noOdbcDialog))//gzp;PWD=aaaaaa
{
AfxMessageBox("数据库连接失败!");
return FALSE;
}
//定义CRecordset记录集CRecordset m_set(&(pApp->m_database));
char sqlbuf[120];
sprintf(sqlbuf,"select StationID,StationName from Station where StationType =%d",id);
if (m_set.Open(CRecordset::forwardOnly,sqlbuf))
{
CDBVariant value;
int uid;
while (!m_set.IsEOF())
{
m_set.GetFieldValue("StationID",value);
uid = value.m_iVal;
m_set.GetFieldValue("StationName",value);
sprintf(trebuf,"%s",*(value.m_pstring));
tvInsert.hParent = hTree;
tvInsert.hInsertAfter = TVI_LAST;
tvInsert.item.mask = TVIF_TEXT|TVIF_IMAGE|TVIF_PARAM|TVIF_SELECTEDIMAGE;
tvInsert.item.pszText = trebuf;
tvInsert.item.iImage = 1;
tvInsert.item.iSelectedImage = 4;
tvInsert.item.lParam = uid;
m_wndTree1.InsertItem(&tvInsert);
m_set.MoveNext();
}
m_set.Close();
}