Access µÄ·ÖÒ³¹¦ÄÜ
if (currentPage ==1) {
//Èç¹ûµ±Ç°Ò³ÎªµÚ1Ò³
sql ="select top "+pageSize+" * from Table";
} else {
int start =(currentPage -1)*pageSize;
sql ="select top "+pageSize+" * from Table where ID not in (select top "+start+" ID from Table)";
}
Ïà¹ØÎĵµ£º
9.3 ͨ¹ýPHP²Ù×÷AccessÊý¾Ý¿â
9.3.1 Á¬½ÓAccessÊý¾Ý¿â
ÔÚPHPÖÐÁ¬½ÓAccessÓÐÈçÏÂ3ÖÖ·½Ê½¡£
£¨1£©´´½¨ÏµÍ³Êý¾ÝÔ´£¬ÓÃPHPÌṩµÄODBCº¯Êý
¼´¿É¡£
£¨2£©Í¬Ñù¿ÉÒÔʹÓÃPHPµÄODBCº¯Êý£¬µ«²»´´½¨
Êý¾ÝÔ´¡£¿ª·ÅÊý¾Ý¿âÁ¬½Ó£¨Open DateBase
Conection£¬ODBC£©ÊÇWindows Open
Server£¨¿ª·Å·þÎñ£©API£¨WOSA£©²úÆ·Ö®Ò ......
ÔÚASP.NETÖе÷ÓÃEXCEL×é¼þµÄʱºò,Èç¹ûûÓÐÅäÖÃDCOMÖÐEXCELȨÏÞÎÊÌâ,½á¹û³ÌÐò»á±¨:Access is denied.
½â¾öµÄ·½·¨ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖ£¬ÔÚweb.configÖÐÉèÖÃÒ»¸ö½Úµã.
<identity impersonate="true" />
²»¹ýÕâÖÖ·½·¨Ö»Äܽâ¾ölocalµçÄÔÉϵÄExcel Access is deniedµÄÎÊÌâ
Èç¹ûÊÇ·þÎñÆ÷µÄ»°,Óпͻ§»ú·ÃÎÊÒ³ÃæµÄʱºò, ......
Ç°¼¸ÌìÔÚ×Ô¼ºµÄ±Ê¼Ç±¾ÉÏ°²×°ÁËOFFICE2007¡£½ñÌì×öÁËÒ»¸ö°Ù¶ÈÓÑÇéÁ´½Ó¼ì²éµÄ¹¤¾ß£¬ ÔÚÁ¬½ÓACCESS2007Êý¾Ý¿âµÄʱºò£¬Ê¹ÓõÄÇý¶¯´úÂëΪ£º"provider=microsoft.jet.oledb.4.0;data source="&server.mappath("queryrecord.mdb") ¡£È··¢ÏÖÌáʾ£º
Microsoft JET Database Engine ´íÎó ''80004005''
²»¿Éʶ±ðµÄÊý¾Ý¿â¸ñʽ
µ« ......
¸üз½·¨Ò»£¬Ö±½ÓÔÚGridViewÖÐÀ´¸üÐÂÊý¾Ý.
¸üз½·¨¶þ£¬´ò¿ªÒ»¸öеÄÒ³ÃæÀ´¸üÐÂÊý¾Ý.
//¸üÐÂ
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
&nbs ......