ÓÃMFC ODBCÁ¬½ÓACCESS£¬ÏÔʾСÊýµÄʱºîÓöµ½ÎÊÌâ¡£
´ó¼ÒºÃ£¬ÎÒÔÚÓÃMFC ODBCÁ¬½ÓACCESS£¬ÏÔʾСÊýµÄʱºîÓöµ½¸öÎÊÌ⣬ÎÒÔÚACCESSÀïµÄ¸Ã×Ö¶ÎÊý¾ÝÀàÐÍÀïÑ¡ÔñµÄÊǵ¥¾«¶È£¬ÔÚ¹¤³ÌÀï¸Ã×ֶεıäÁ¿ÀàÐÍÑ¡ÔñµÄÊÇFLOAT£¬ÔÚÖ´Ðй¤³ÌµÄʱºî£¬ÏÔʾµÄ¸Ã×Ö¶ÎÏÂÃæµÄÊý¾ÝÈ´ÊÇÈ«²¿Îª0£¨ACCESSÀï¸Ã×Ö¶ÎÏÂÃæÓÐÕûÊýÒ²ÓÐСÊý£©£¬²»ÖªµÀÕâÊÇÔõô»ØÊ£¬Ï£Íû´ó¼Ò°ïæÕÒÕÒÔÒò£¬ÎÒÊǸոսӴ¥Êý¾Ý¿âµÄ£¬²»ÊǺÜÁ˽⣬ºÇºÇ£¬Ð»Ð»ÁË
×¢:ÔÚACCESSºÍ¹¤³ÌÀïµÄÊý¾ÝÀàÐͶ¼ÉèÖÃΪÕûÐÍ µÄʱºîÊÇÄÜÕý³£ÏÔʾµÄ,ÎÒ·´Ëü¶¼¸Ä³ÉFLOAT¾Í³ö´íÁË!
˵µÄͦ¶Ô£¬µ«³ÌÐòÄØ£¿£¿£¿Äã²»Ìù´úÂ룬զ½â¾öÎÊÌ⣿£¿£¿
ºÇºÇ,²»ºÃÒâ˼,ÍüÌùÁË,ÏÔʾ´úÂëÈçÏÂ:
int CLhwyView::Show()
{
int i=0;
m_pSet->MoveFirst();
do
{
CString s;
s.Format("%d",m_pSet->m_column1);
m_ListCtrl.InsertItem(i,s,0);
m_ListCtrl.SetItemText(i,1,m_pSet->m_column2);
s.Format("%d",m_pSet->m_column3);
m_ListCtrl.SetItemText(i,2,s);
s.Format("%d",m_pSet->m_column4);
m_ListCtrl.SetItemText(i,3,s);
s.Format("%d",m_pSet->m_column5);
m_ListCtrl.SetItemText(i,4,s);
s.Format("%d",m_pSet->m_column6);
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
Çë´ó¼Ò°ï棬ÎÒÏëÔÚAccess´°ÌåÀïÃæÏÔʾ±íºó£¬Ñ¡Ôñ±íÖеÄij¸ö×ֶΣ¬¾Í¿ÉÒÔ¸ù¾ÝÑ¡ÔñµÄÕâЩµ¥Ôª¸ñÇóºÍ¡¢Ç󯽾ù£¬¾ÍÈçExcelÓÒϽÇ״̬À¸ÄÇÑù£¬ºÜ·½±ãµÄͳ¼ÆÇóºÍÇ󯽾ù£¬Ð»Ð»£¡
Äã¿ÉÒÔÓÃÒ»¸ögridview »òÕ߯äËûʲô¿Ø¼þ ¶ ......