ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍ꣬±£´æÔÚÄÚ´æÖУ¬¶ÁдMDBÂýÊÇûÓа취µÄ£¬Ã»ÓиüºÃµÄ°ì·¨
ÓÃdatareader Ö»¶Á ËÙ¶È»áÉÙ¿ìµã
Ò²²»ÖªµÀÄãÄÇÂý¾ßÌåÊǶàÂý ¾¡Á¿Óô洢¹ý³Ì µÚÒ»´Î¶ÁµÄʱºòÊÇ»á±È½ÏÂý
ÊDz»ÊÇÊý¾ÝÌ«¶àÁË£¡
ÒªÊÇÌ«¶à£¬ÄÇÄã¾ÍÉÙÈ¡µãÂð£¡
½øÐзÖÒ³,Ò»´ÎÖ»ÏÔʾ¶àÉÙÌõ
Êý¾ÝÔ´·Ö²¼,AJAX·ÖʱȡÊý¾Ý(²»»á)
Êý¾Ý¶à¿Ï¶¨ËÙ¶ÈÂý£¬Í¨¹ý·ÖÒ³ÏÔʾÊý¾Ý
²Î¿¼
ÓзÖÒ³°¡£¬µ«ÊÇЧ¹û²»ÊǺܺÃ
ÎÒÕâÖÖ·ÖÒ³±È½ÏÆÕͨ
ÓÐûÓкõķÖÒ³·½Ê½£¿
Ïà¹ØÎÊ´ð£º
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎÎ ......
¿É·ñ½«accessÊý¾Ý¿âÍêÈ«µ¼Èësqlserver
µ±È»¿ÉÒÔ
Óõ¼Èëµ¼³ö¹¤¾ßÀ´×ö
ͬÒâÂ¥ÉÏ¡£
SQL code:
/*************µ¼ÈëAccess********************/
insert into B±í selet * from openrowset('Microsoft.Jet ......