Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP.net¿ÉÒÔÓÃACCESSÒ²¿ÉÒÔÓÃSQLSERVERÔõôʵÏÖ£¿

ÏÖÔÚ×öµÄÒ»¸ö¹«Ë¾ÏîĿҪÇóÒªÓÐÁ½¸ö°æ±¾ Ò»¸öÊÇÓÃAccessµÄÊý¾Ý¿â  ÁíÒ»¸öÓÃsql server µÄÊý¾Ý¿â

ÇëÎÊÓÐ×ö¹ýÏà¹Ø¹¦ÄܵĸßÊÖ°ïæָ½Ì ÈçºÎʵÏÖ£¿

ÓõÄÊÇʲô˼·£¿
²Î¿¼petshopÀïÃæµÄ¼Ü¹¹¡£¡£¡£

Á¬½ÓÈ«²¿Ê¹ÓÃOleDBConnection

SQLÓï¾äÈ«²¿Ê¹Óñê×¼T-SQL¼´¿É

ÔËÓÃÁ½ÖÖÁ¬½Ó¡£Ò»¸öÓÃAccessµÄÊý¾ÝÁ¬½Ó£¬Ò»¸öÓÃsqlµÄÁ¬½Ó

ÒýÓÃ
Á¬½ÓÈ«²¿Ê¹ÓÃOleDBConnection

SQLÓï¾äÈ«²¿Ê¹Óñê×¼T-SQL¼´¿É


·½°¸¿ÉÒÔ

ÔËÓÃÁ½ÖÖÁ¬½ÓÀà¡£Ò»¸öÓÃAccessµÄÊý¾ÝÁ¬½Ó£¬Ò»¸öÓÃsqlµÄÁ¬½Ó

Õâ¸öÊý¾Ý¿âÁ¬½ÓµÄ·½Ê½Òª¸Ä±ä£¬ÎÒÏ뻹ÓоÍÊÇSQLÓï¾ä£¬ÎÒÏëÒ²Òª½øÐкܴóµÄ¸Ä±ä¡£

ÒýÓÃ
Á¬½ÓÈ«²¿Ê¹ÓÃOleDBConnection

SQLÓï¾äÈ«²¿Ê¹Óñê×¼T-SQL¼´¿É


ÕâÑù¾ÍÓÐÖ»Óô¿Óï¾äµÄ»°  ÄÇsql×¢Èë ÔӰ죿  access Äܲ»ÄÜ´«²ÎÊý£¿

дһ¸ö½Ó¿ÚºÍÁ½¸öÊý¾Ý·ÃÎʲãÕë¶ÔÁ½ÖÖÊý¾Ý¿â

ÒýÓÃ
ÔËÓÃÁ½ÖÖÁ¬½Ó¡£Ò»¸öÓÃAccessµÄÊý¾ÝÁ¬½Ó£¬Ò»¸öÓÃsqlµÄÁ¬½Ó


ÎÒÏÖÔÚÕýÔÚÊÔÕâÖÖ·½Ê½  ´æ´¢¹ý³Ì¿´À´ÊDz»¿ÉÒÔÓÃÁË  ±¾À´ÓÃsqlÊý¾Ý¿â¸ÄÁ¬½ÓΪAccessºóÄǸĵĵط½Ì«¶àÁË Êý¾Ý²ãµÄ¶«Î÷¶¼Òª¸Ä

д³É½Ó¿Ú

¹¤³§Ä£Ê½¡£¡£¡£

ÆäËûµÄ»ù±¾¶¼ÊÇÒ»Ñù  ¾ÍÊÇÁ¬½ÓÊý¾Ý¿âµÄÓï¾äÓеã²îÒì
½«SQL¸Ä³ÉOLEDB ¾ÍOKÁË
Â¥Ö÷²»Óõ£ÐÄÆäËûµÄ

²Î¿¼Î¢ÈíµÄPETSHOPµÄ¹¤³§Ä£Ê½

ÒýÓÃ
ÔËÓÃÁ½ÖÖÁ¬½ÓÀà¡£Ò»¸öÓÃAccessµÄÊý¾ÝÁ¬½


Ïà¹ØÎÊ´ð£º

asp.net·ÖÒ³ÎÊÌâ

select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......

asp.net Ï̵߳ÄÎÊÌ⣿ - .NET¼¼Êõ / ASP.NET

ǰ¶Îʱ¼äÅöµ½Ò»µÀÃæÊÔÌâÈçÏ£º
test.aspxÒ³ÃæÓÐÈçÏ´úÂ룺
 Response.Write(Test.GetDate());
TestÀàÈçÏ£º
public class Test
{
  static string dt="";
  public static s ......

ASP.NET MVC¼Ü¹¹·¢²¼ÁË - .NET¼¼Êõ / ASP.NET

ASP.NET MVC¼Ü¹¹·¢²¼ÁË,ÄãÓÃÁËÂð£¿
»¹ÔÚѧϰÖÐ

ÎÒÒ²ÔÚѧϰ¡£ÂòÊ飬Ìý½Ì³Ì£¬¿´ÍøÉÏ×ÊÁÏ£¬ÏÂÔØÀý×Ó£¬¸Ð¾õÌý²»´íµÄ£¬²»¹ý±ÈÆð¹¤³§Ä£Ê½£¬ËƺõÑ·É«Á˵㡣¡£¡£»¶Ó­µ½ÎÒ²©¿Í»¥Ïàѧϰ

¶¼ÓÃÁË5¸ö°æ±¾ÁË ´Ó PV1 µ½beta ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ