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

ASP.NETÓëMySqlµÄÁ¬½Ó

1.Êý¾ÝÁ¬½Ó·½Ê½
ASP.NET±¾ÉíµÄÊý¾Ý·ÃÎÊADO.NET²»Ö§³Ö¶ÔÓÚMySqlµÄÁ¬½ÓºÍ²éѯ£¬µ«ÊÇMySQL¹ÙÍøÉϾùÌṩÁ˶àÖÖASP.NETÁ¬½Óµ½MySQLµÄ·½Ê½£º
£¨1£©ODBCÇý¶¯µÄ·ÃÎÊ·½Ê½£ºmysql-connector-odbc-5.1.5-win32.msi£¬ODBC
£¨2£©ADO.NET¶ÔÓÚMySQLµÄ·ÃÎÊ·½Ê½£ºmysql-connector-net-6.2.2.zip
¸öÈËÑ¡ÓõÄÊǵڶþÖÖ£¬¸Ð¾õ·½±ã£¬ºÍ.NET¶ÔSQL SERVERµÈµÄ·ÃÎÊ»ù±¾ÀàËÆ£¬ÓÃÆðÀ´±È½Ï˳ÊÖ¡£
2.ADO.NET·½Ê½Êý¾ÝÁ¬½ÓµÄʹÓÃ
ÔÚͨ¹ýmysql-connector-net-6.2.2.zip·ÃÎÊMySQLǰ£¬±ØÐëÏȽ«MySql.Data.dll·ÅÔÚBinÎļþ¼ÐÏÂ
£¨1£©Èç¹ûʹÓÃVSµÄ¿Ø¼þ½çÃæ£¬¿ÉÖ±½Ó¿ÉÊÓ»¯²Ù×÷ÓëÊý¾Ý¿âÏàÁ¬
£¨2£©×Ô¼ºÊ¹ÓÃSqlDataSource»òObjectDataSourceÊéдÁ¬½Ó´úÂëʱ£¬ÐèÒªÔÚÕ¾µãÓÒ¼üÌí¼ÓÒýÓã¬ÒýÓÃmysql.dataµÄdllÎļþºÍÃüÃû¿Õ¼äMySql.Data.MySqlClient
ÿ¸öÒª·ÃÎÊMySQLÊý¾Ý¿âµÄÒ³Ãæ£¬¶¼±ØÐëÔÚÍ·²¿Ìí¼Ó"using MySql.Data;using MySql.Data.MySqlClient;“
3.ÔÚWeb.ConfigÒ³ÃæÌí¼ÓÊý¾Ý¿âÁ¬½Ó×Ö·û´®
Ìí¼ÓÔÚWeb.ConfigµÄ<configuration></configuration>ÖУ¬¾Í²»ÓÃÖØ¸´Ð´Á¬½Ó´úÂ룬ÿ¸öÒ³Ãæ¿ÉÒÔÖ±½ÓÒýÓãº
<connectionStrings>
<add name="Conn_User"
connectionString="server=localhost;User Id=root;password=root;Persist Security Info=True;database=db_user"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
4.Á¬½ÓMySQLÓëSqlServerµÄ²»Í¬
£¨1£©ËùÓеÄsql¿ªÍ·µÄSQLÁ¬½Ó²ÎÊý¶¼»»³ÉMysql¿ªÍ·µÄ£¬Èç"SqlCommand->MySqlCommand"£¬"SqlDataSource->MySqlDataSource"£¬ÖîÈç´ËÀàµÄ
£¨2£©SQLÓï¾äÖпÉÒÔʹÓòÎÊý£¬²»¹ý×¢ÒâSQL ServerÖвÎÊý·ûºÅÊÇ"@"£¬¶øMySQLÖÐÊÇ"?"


Ïà¹ØÎĵµ£º

mysqlÖÐÎÄÅÅÐò

UTF8 ĬÈÏУ¶Ô¼¯ÊÇ utf8_general_ci , Ëü²»Êǰ´ÕÕÖÐÎÄÀ´µÄ¡£ÄãÐèÒªÇ¿ÖÆÈÃMySQL°´ÖÐÎÄÀ´ÅÅÐò¡£
select

*

from
core_vender_info
order

by

convert
(vender_abbrev USING gbk) COLLATE gbk_chinese_ci
......

ASP.NET Ó¦ÓóÌÐòÉúÃüÖÜÆÚ¸ÅÊö

 
±¾Ö÷Ìâ¸ÅÊöÓ¦ÓóÌÐòÉúÃüÖÜÆÚ£¬ÁгöÖØÒªµÄÉúÃüÖÜÆÚʼþ£¬²¢ÃèÊöÈçºÎ±àдÊʺÏÓ¦ÓóÌÐòÉúÃüÖÜÆÚµÄ´úÂë¡£ÔÚ ASP.NET ÖУ¬ÈôÒª¶Ô ASP.NET Ó¦ÓóÌÐò½øÐгõʼ»¯²¢Ê¹Ëü´¦ÀíÇëÇ󣬱ØÐëÖ´ÐÐһЩ´¦Àí²½Öè¡£´ËÍ⣬ASP.NET Ö»ÊǶÔä¯ÀÀÆ÷·¢³öµÄÇëÇó½øÐд¦ÀíµÄ Web ·þÎñÆ÷½á¹¹µÄÒ»²¿·Ö¡£Á˽âÓ¦ÓóÌÐòÉúÃüÖÜÆÚ·Ç³£ÖØÒª£¬ÕâÑù²ÅÄÜÔÚÊ ......

ASP.NET·þÎñÆ÷¿Ø¼þÖ®ÊÓͼ״̬

ASP.NET·þÎñÆ÷¿Ø¼þÖ®ÊÓͼ״̬
ΪWebÒ³Ãæ¼°Æä¿Ø¼þ±£³Ö״̬ÐÅÏ¢ÊǷdz£ÓбØÒªµÄ¡£È»¶ø£¬ÓÉÓÚWebÓ¦ÓóÌÐò´´½¨ÓÚHTTPЭÒéµÄ¶¥²ã£¬ÕâÊÇÒ»¸öÎÞ״̬µÄЭÒ飬Òò´Ë£¬±£³Ö״̬ÐÅÏ¢Ôò±äµÃ·Ç³£À§ÄÑ¡£ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬ASP.net 2.0¼¼ÊõÌṩÁ˶àÖÖ½â¾ö·½°¸£¬ÀýÈ磬ÀûÓÃSession¡¢Cookie¡¢ÊÓͼ״̬¡¢¿Ø¼þ״̬¡¢Òþ²ØÓò¡¢²éѯ×Ö·û´®¡¢¸ö ......

ѧϰASP.NET ³õ̽Application״̬

ѧϰASP.NET-³õ̽Application״̬ - ÉÏһƪ¡¶Ç³Ì¸TeeChart×é¼þÔÚASPÖеÄÓ¦Óá·ÏÂһƪ¡¶ÓÃIS6½øÐÐASPÈí¼þµÄ´ò°üºÍ×Ô¶¯°²×°(²¹³ä)¡·×ÖÌå: С|ÖÐ|´ó ¼ò|·±¾«²ÊÍÆ¼ö asp.netÖеÄapplicationÊý×é Asp.netÖÐapplication¶ÔÏóÎÊÌ⣿ÇëÇó.netѧÕßÖ¸µã…… °²×°Asp.net 2.0·þÎñÆ÷³öÏÖServer Application Unavailable ASP. ......

ºÃÊéÍÆ¼ö ¼´Ñ§¼´ÓÃASP.NETÓ¦Óÿª·¢

ASP.NETÊÇĿǰ¿ª·¢WebÓ¦ÓõÄÒ»ÖÖȫз½Ê½¡£±¾ÊéµÚl¡¢2Õ½éÉÜÁËASP.NETµÄһЩ»ù±¾¸ÅÄîºÍ»ù±¾Óï·¨¡£ÆäÓàÕ½ÚÖ÷ÒªÊǶԸ÷ÖÖʾÀý½øÐÐÏêϸ·ÖÎö¡£½éÉÜÁ˸÷ÖÖASP.NETµÄ½â¾ö·½°¸£¬°üÀ¨´´½¨»¥¶¯Ê½ÄÚÁªÍøÓ¦ÓóÌÐò¡¢´´½¨ÌåÓýÕ¾µã¡¢´´½¨ÈËÁ¦×ÊÔ´Ó¦Óᢴ´½¨ÔÚÏßÅÄÂôÕ¾µãµÈ¡£Í¨¹ýÕâЩʵÓõĽâ¾ö·½°¸µÄѧϰ£¬¶ÁÕß¼ÈÄܵõ½ºÜ¶àʵÓõĴúÂë£¬Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ