¸ßÈ˽ø £¡£¡access Êý¾Ý¿âÎÊÌâ~~
±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢
Ö´ÐÐÇ°
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉáÆúʽϳµ¶ ÎÙ¸ÖÉáÆúʽϳµ¶
4 ÎÙ¸ÖÉáÆúʽϳµ¶ µ¶Í·
5 ÎÙ¸ÖÉáÆúʽϳµ¶ ÎÙ¸Ö¿¹Õ𵶱ú
6 ¸ßËÙ¸ÖÉáÆúʽϳµ¶ ¸ßËÙ¸ÖÉáÆúʽϳµ¶
Óï¾ä
update T_ProductSeries set ProductSeriesName = 'ÎÙ¸Ö¿¹Õ𵶱ú' and ProductSeriesRemark = 'ÎÙ¸Ö¿¹Õ𵶱ú' where ProductSeriesID = 5
Ö´Ðкó£º
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉáÆúʽϳµ¶ ÎÙ¸ÖÉáÆúʽϳµ¶
4 ÎÙ¸ÖÉáÆúʽϳµ¶ µ¶Í·
5 -1 ÎÙ¸Ö¿¹Õ𵶱ú
6 ¸ßËÙ¸ÖÉáÆúʽϳµ¶ ¸ßËÙ¸ÖÉáÆúʽϳµ¶
Çë½ÌÁË Ôõô»ØÊ°¡ £¡£¡£¡
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 0 LVϳµ¶ÏµÁÐ
3 0 ÎÙ¸ÖÉáÆúʽϳµ¶
4 -1 µ¶Í·
5 -1 ÎÙ¸Ö¿¹Õ𵶱ú
6 ¸ßËÙ¸ÖÉáÆúʽϳµ¶ ¸ßËÙ¸ÖÉáÆúʽϳµ¶
¸üкóÔõôȫÊÇÊý×Ö°¡~~~~~~
¿´¿´ÄãµÄ´úÂëÀïÃæ°É,Ó¦¸ÃÊǼÓʲôÁË
update T_ProductSeries set ProductSeriesName = 'ÎÙ¸Ö¿¹Õ𵶱ú' ,ProductSeriesRemark = 'ÎÙ¸Ö¿¹Õ𵶱ú' where ProductSeriesID = 5
accessµÄÓï·¨ÊÇÓÃand Âð?
sqlÀïÓöººÅ¸ô¿ª¾ÍÐÐ.
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øСµÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×ֶΠfrom ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËٶȣ¡
Ò»´ÎÈ«²¿¶ÁÍê ......