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

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ÍêÈ«ÏàËÆ.
ÏÂÃæÌṩÁ½¶Î´úÂ빩²Î¿¼,Ò»¸ö´úÂëÒ³
default2.aspx.csϵĴúÂ룺
C#´úÂë
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"];
bookres += myDataReader["pass"];
}
myDataReader.Close();
myConnection.Close();
lb1.Text = bookres;
}
}
1¡¢ÏÂÔØMySQLÊý¾Ý¿â£¬µØÖ·£ºhttp://www.mysql.com/£¬´óСֻÓм¸Ê®¸öÕ×¶øÒÑ£¬°²×°ºÜ·½±ã£¬½ÓÌáʾ¼´¿É¡£
2¡¢MySQL°²×°ºóĬÈÏÊÇûÓпͻ§¶Ë¹¤¾ßµÄ(ÏñSQLServerµÄÆóÒµ¹ÜÀíÆ÷£¬²éѯ·ÖÎöÆ÷µÈ)£¬Ö»ÊÇÒ»¸ö·þÎñÆ÷´æ´¢Êý¾Ý£¬ÎªÁË·½±ãÄãÒªÔÙÏÂÔØÒ»¸ö¿Í»§¶Ë¹¤¾ß£¬ÓÐºÜ¶à£¬ÍÆ¼öʹÓÃSQL Manager for MySQL£¬¼ò½àСÇÉ£¬¹¦ÄÜҲǿ´ó¡£ÏÂÔØ£ºhttp://www.sqlmanager.net/en/products/mysql/manager/download
3¡¢ASP.NETÁ¬½ÓMySQLÐèÒªÒ»¸ö×é¼þ(.net±¾Éí²»Ìṩ·ÃÎÊMySQLµÄÇý


Ïà¹ØÎĵµ£º

Asp.netÒ³Ãæ´«µÝ²ÎÊýµÄ¼¸ÖÖ·½·¨¶Ô±È½²½â

µÚÒ»ÖÖ·½·¨£º
ͨ¹ýURLÁ´½ÓµØÖ·´«µÝ
send.aspx:
   protected void Button1_Click(object sender, EventArgs e)
     {
         Request.Redirect("Default2.aspx?username=honge");
     }
receive.aspx:
string user ......

asp.net¿Í»§¶Ë»ò·þÎñ¶ËÑéÖ¤·½Ê½


¿Í»§¶ËÑéÖ¤·½Ê½£º
 protected void Page_Load(object sender, EventArgs e)
    {
       
        if (!IsPostBack)
        {
       &nbs ......

ÔÚASP.NETÖÐʹÓÃTreeview¿Ø¼þºÍXML


ÔÚASP.NETÖÐʹÓÃTreeview¿Ø¼þºÍXML
ÒÔǰ£¬ÔÚWEBÒ³ÃæÖÐÈç¹ûÏëʹÓÃÊ÷ÐοؼþµÄ»°£¬ÍùÍù»áÓÐЩÂé·³£¬ÓÐʱÉõÖÁÒª×Ô¼ºÐ´´úÂëÀ´´ïµ½ÓÃÊ÷ÐÎÁбíÏÔʾÊý¾ÝµÄÄ¿µÄ¡£ÔÚasp.netÖУ¬ÎÒÃÇ¿ÉÒԺܷ½±ãµØÊ¹ÓÃÓÉ΢ÈíÌṩµÄInternet Exploer Web Controls¿Ø¼þÀ´ÊµÏÖÊ÷ÐÎÁÐ±í¡£ÔÚ΢ÈíÌṩµÄÕâÌ×Internet Exploere Web Controls¿Ø¼þ¼¯ºÏÖУ¬°üÀ ......

ASP.NET 2.0ÍøÕ¾ÓÅ»¯¼¼ÇÉ×ܽá

1. µ±²»ÐèҪʹÓÃSessionµÄʱºòÇë¹Ø±Õ
        ¹Ø±ÕSessionµ±²»ÐèҪʹÓõÄʱºò
• ÈôÒª½ûÓÃÒ³µÄ»á»°×´Ì¬£¬Ç뽫@ Page Ö¸ÁîÖеÄEnableSessionState ÊôÐÔÉèÖÃΪfalse¡£ÀýÈ磬 <%@ Page EnableSessionState="false" %>¡£
• ×¢ÒâÈç¹ûÒ³ÐèÒª·ÃÎʻỰ±äÁ¿£¬µ«²»´òËã´´½¨»òÐÞ¸ÄËüÃÇ£¬Ôò½« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ