Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ìø×ªÒ³ÃæµÄÈýÖÖ·½·¨±È½Ï

1¡¢ response.redirect Õâ¸öÌø×ªÒ³ÃæµÄ·½·¨Ìø×ªµÄËٶȲ»¿ì£¬ÒòΪËüÒª×ß2¸öÀ´»Ø(2´Îpostback)£¬µ«Ëû¿ÉÒÔÌø תµ½ÈκÎÒ³Ãæ£¬Ã»ÓÐÕ¾µãÒ³ÃæÏÞÖÆ(¼´¿ÉÒÔÓÉÑÅ»¢Ìøµ½ÐÂÀË)£¬Í¬Ê±²»ÄÜÌø¹ýµÇ¼±£»¤¡£µ«ËÙ¶ÈÂýÊÇÆä×î´óȱÏÝ!redirectÌø×ª»úÖÆ£ºÊ×ÏÈÊÇ·¢ËÍÒ»¸öhttpÇëÇ󵽿ͻ§¶Ë£¬Í¨ÖªÐèÒªÌø×ªµ½ÐÂÒ³Ãæ£¬È»ºó¿Í»§¶ËÔÚ·¢ËÍÌø×ªÇëÇóµ½·þÎñÆ÷ ......

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


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

mysql concat,substringÓ÷¨


ÔÚ¹¤×÷ÖÐÅöµ½Ò»¸öMysql×ֶθüÐÂÎÊÌâ
ÔÚcustom±íÖÐÓÐÒ»¸ötariffurlµÄÖµÖÐÓÐÈçÏÂÇé¿ö£º
uploadfiles ariff2007031172720306698.jpgÒÔ¼°uploadfiles ariff2007031172720306690.jpg;uploadfiles ariff2007031172720306691.jpgÐÎʽ
Òª¸ü¸Ä³Éuploadfiles/tariff/200703/1172720306698.jpg¼° uploadfiles/tariff/200703/11727 ......

mysql hibernateÖ÷¼üÅäÖÃ

  ÔÚ½üÆÚµÄÏîĿά»¤¹¤×÷ÖУ¬Ê±³£³öÏÖÖ÷¼üÖØ¸´µÄÒì³£¡£¾­¹ýһϵÁÐ×ÊÁϵIJéѯ֮ºó£¬·¢ÏÖʱhibernateÓ³ÉäÎļþÅäÖÃÎÊÌâ¡£
  mysqlÌṩÖ÷¼ü“×Ô¶¯ÔöÁ¿”µÄÅäÖã¬Ö¸¶¨¸ÃÀàÐ͵ÄÖ÷¼ü£¬mysqlÄܹ»×Ô¶¯¼ÓÒ»¡£
  ÔÚhibernateÓ³ÉäÎļþÖУ¬¹ØÓÚÖ÷¼üµÄÅäÖò»ÄÜÊÇ
<generator class="increment"&g ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ