ASP.NET+MYSQL
MysqlµÄconnector/net5.0ÏÂÔØµØÖ·:
http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.6.zip/from/pick
°²×°ºÃÒÔºó,
µãÊôÐÔ,È»ºóµã²éÕÒÄ¿±ê,µãÏòÉÏÒ»²ãĿ¼,ÕÒµ½Binaries\.NET 2.0,È»ºó½«Õâ¸öÎļþ¸´ÖƵ½ÄãµÄ¹¤³ÌĿ¼ÏÂ,Ò»°ãÕâÑùµÄDLLÎļþ»á±£´æµ½binĿ¼ÏÂ.
ÔÚ´úÂëÒ³ÀïÊäÈëusing Mysql.Data.MysqlClient;È»ºóÔÙÔÚPage_Loadº¯ÊýÀïдMysqlConnection£¬ÔÚµ¥´Êдµ½Ò»°ëʱÌáʾ¾Í³öÀ´ÁË£¬ÏÂÃæµÄ¾Í²»ÓÃдÁ˰É?¶¼ÒѾ³öÏÖ”´úÂëÖÇÄÜÍê³ÉÁË”,Ëæ±ãдһ¶Î´úÂëÊÔÊԾͿÉÒÔÁË,ºÍSqlserverÍêÈ«ÏàËÆ.
ÏÂÃæÌṩÁ½¶Î´úÂ빩²Î¿¼,Ò»¸ö´úÂëÒ³,Ò»¸öÊÇHTMLÒ³:
default2.aspx.csϵĴúÂ룺
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 MySql.Data.MySqlClient;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string query = "select * from guestbook";
MySqlConnection myConnection = new MySqlConnection("server=localhost;user id=root;password=;database=guestbook");
MySqlCommand myCommand=new MySqlCommand(query,myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
MySqlDataReader myDataReader = myCommand.ExecuteReader();
string bookres="";
while (myDataReader.Read()==true)
{
bookres+=myDataReader["id"];
bookres+=myDataReader["user"];
&
Ïà¹ØÎĵµ£º
ͨ¹ý SqlDataSource ¿Ø¼þ£¬¿ÉÒÔʹÓà Web ·þÎñÆ÷¿Ø¼þ·ÃÎÊλÓÚ¹ØÏµÊý¾Ý¿âÖеÄÊý¾Ý¡£ÆäÖпÉÒÔ°üÀ¨ Microsoft SQL Server ºÍ Oracle Êý¾Ý¿âÒÔ¼° OLE DB ºÍ ODBC Êý¾ÝÔ´¡£Äú¿ÉÒÔ½« SqlDataSource ¿Ø¼þÓëÊý¾Ý°ó¶¨¿Ø¼þ£¨Èç GridView¡¢FormView ºÍ DetailsView ¿Ø¼þ£©Ò»ÆðʹÓã¬Óü«ÉÙ´úÂë»òÉõÖÁ² ......
ÔÚ¡¶ASP.NET¿ª·¢£ºÔÚÓû§¿Ø¼þÖÐÌí¼ÓÊôÐÔ¡·ÕâһƪÎÄÕÂÖÐÎÒÃǶ¨ÒåÁËÒ»¸öÓû§µÇ¼µÄÓû§¿Ø¼þUserLogin.ascx Îļþ£¬ÀïÃæ°üº¬ÁËÒ»¸öLinkButton·þÎñÆ÷°´Å¥¿Ø¼þ£¬µ±Óû§µ¥»÷¸Ã°´Å¥Ê±·þÎñÆ÷¶Ë»á×Ô¶¯Éú³ÉÒ»¸ö»Ø·¢À´¼¤·¢Page.Loadʼþ¡£³ýÁË·þÎñÆ÷×Ô¶¯²úÉú»Ø·¢À´¼¤·¢Page.LoadʼþÍ⣬ÎÒÃÇ¿ÉÒÔ¸øLinkButtonÌí¼ÓÒ»¸öËü×Ô¼ºµÄʼþ ......
Page_Load--Ò³Ãæ¼ÓÔØÊ¼þ.
Page.IspostBackÅжÏÊÇ·ñµÚÒ»´Î¼ÓÔØ¡£
ÿ´ÎÏìÓ¦·þÎñÐÅÏ¢(¼È¿Í»§ÇëÇóASP.NETÒ³Ãæ-ASPXÎļþ»òWeb·þÎñ-
ASMXÎļþ)¾Í¼ÓÔØÒ»´Î(Ö´ÐÐÒ»´ÎPage_Load)¡£
¼ÓÔØµÄʱºò²¢²»ÊÇÿ´Î¶à±àÒëÒ»´Î´úÂëÎļþ£¬ÒòΪ£ºÃ¿Ò»´ÎÇëÇó
ASPXÎļþʱ²¢²»ÊǶàÒª½øÐÐÒ»´Î±àÒ룬¶øÊǵÚÒ»´ÎÖ´ ......
ÒÔǰ×ö.NET winformµÄʱºò£¬Ò»Ö±¶¼ÊÇÓà Console.WriteÏò¿ØÖÆÌ¨Êä³öÐÅÏ¢µÄ£¬Õâ´Î×öwebµÄʱºò£¬·¢ÏÖÕâ¸öÓï¾äÓò»ÁË¡£
²éÁËÒ»ÏÂ×ÊÁÏ£¬²Å·¢ÏÖweb³ÌÐòÖ´ÐÐʱ£¬ÊDZ»¸½¼Óµ½IIS½ø³ÌµÄÒ»¸öµ¥¶ÀµÄAppDomainÖеģ¬ËùÒÔ¾ÍËãÓÐÊä³öÒ²¿´µ½£¬ËùÒÔConsole.Writeµ÷ÊÔÐÅÏ¢ÎÞ·¨ÏÔʾ³öÀ´¡£
ÄÇô½â¾ö°ì·¨ÊÇ£¬ÓÃdebug´úÌæ£º
System.Diagn ......