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ÖÐÊÇ"?"
Ïà¹ØÎĵµ£º
±ÏÒµÉè¼ÆµÄ³ÌÐòÖ÷Ìå±àºÃÁË£¬ÔËÐÐÉÙÁ¿Êý¾ÝûÓÐÈκÎÎÊÌ⣬һµ©Êý¾ÝÁ¿Ôö¼Óµ½22w£¬ÔËÐÐʱ¼ä¾Í³¤µÃÁîÈË·¢Ö¸¡£µ¼Ê¦½¨Ò飬³ÌÐòÖо¡¿ÉÄܵؼõÉÙÓëÊý¾Ý¿â½»»¥µÄ´ÎÊý£¬¾¡¿ÉÄܵذѹ¤×÷¶ª¸øÊý¾Ý¿âÍê³É¡£ÔÚÕâһ˼ÏëµÄÖ¸µ¼Ï£¬ÎÒÈýÌì´ó·ùÐ޸ijÌÐò£¬²¿·Ö´úÂ뼸ºõÊÇ·ÐÂÁËÒ»±é¡£×ܵÄÀ´Ëµ£¬ÔËÐÐʱ¼äȷʵµÃµ½ÁË ......
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;
using ......
¹ØÓÚ asp.net ·þÎñÆ÷¿Ø¼þ¼¸¸ö ID µÄ˵Ã÷[ZT]
Òý×Ô:http://lujf1978.blog.163.com/blog/static/2320126620078114112822/
¶ÔÓÚÿһ¸ö·þÎñÆ÷¿Ø¼þSystem.Web.UI.Control ¶¼¾ßÓÐ ID£¬UniqueID£¬ClientID Èý¸öÊôÐÔ£¬ÄÇôÕâ¸öÈýÕßµ½µ×ÓкӹØÏµ£¬ÔÚ¿Í»§¶ËHTMLÖÐÓÖÊÇÈçºÎ¶ÔÓ¦³ÊÏÖµÄÄØ£¿
ID£º»ñÈ¡»òÉèÖ÷ÖÅ䏸·þÎñÆ÷¿Ø¼þµÄ ......
ÔÚASP.NetÒ»°ãµÄ³ÌÐò±àдÖУ¬ËùʹÓõÄÊý¾ÝÀïÃæ£¬ÈÕÆÚʱ¼äÊÇÒ»ÖÖÌØÊâµÄÊý¾ÝÀàÐÍ£¬Ò²ÊǾ³£±»Ê¹Óõġ£---µçÄԽ̳̼¼ÊõÑ§Ï°Íø
ÔÚVisual Basic.NETÖеÄÈÕÆÚʱ¼äÊý¾ÝÓÃÊýÖµµÄÊý¾ÝÀàÐͱ£´æ£¬¶øÇÒÓз¶Î§¡£
ÈÕÆÚµÄ·¶Î§Êǹ«Ôª1Äê1ÔÂ1ÈÕ¡«¹«Ôª9999Äê1 2ÔÂ3 1ÈÕ£¬Ê±¼äµÄ·¶Î§ÊÇ00£º00£º00¡«23£º59£º59¡£ÉùÃ÷¸ñÊ½È ......