¸÷λ´ó´ó°ï°ïæ vs2008 asp.netÔõÑùÁ¬½ÓMysQLÊý¾Ý¿â
ÎÒÓõÄvs2008¿ª·¢¹¤¾ß
ÓïÑÔasp.net
Êý¾Ý¿âMysQL
ÒªÔõÑù²ÅÄÜÁ¬½Ó
Ïêϸµã˵
ÏÈллÁË
http://developer.51cto.com/art/200907/140162.htm
http://blog.csdn.net/sciland/archive/2009/03/25/4023679.aspx
ÏÂÔØ¸ö MySql.dll
Á¬½Ó×Ö´®sql server µÄÒ»Ñù¡£
ÎÒÏÖÔÚÓà odbc + ΢ÈíÆóÒµ¿â·Ç³£·½±ã°²È«¶øÇÒÏë»»Êý¾Ý¿âµÄ»°Ò²ÊǷdz£¼òµ¥¡£Î¢ÈíÆóÒµ¿â·Ç³£Ç¿´ó½¨Òé´ó¼ÒʹÓÃ
Ŷ ÄÇÖ»Ôöɾ¸Ä²éÓï¾ä¶¼¸úSqlServerÒ»ÑùµÄÂð
ϸö¶¯Èí.net´úÂëÉú³ÉÆ÷Á¬ÉÏMySQLµ¼³ö¸ö¼òµ¥µÄÈý²ã¼Ü¹¹µÄÀý×Ó¿´¿´¾ÍÃ÷°×ÁË¡£»òÕßÖ±½ÓÏÂËûµÄÆÕͨÈý²ã½á¹¹Ê¾ÀýÏîĿԴÂë¡£http://www.maticsoft.com/download.aspx
°ïÂ¥Ö÷¶¥Ò»Ï£¬ÎÒÒ²ÕÒ¼òµ¥µÄ·½·¨
Ò»ÑùµÄÁ´½Ó°¡ <add key="ConnectionString" value="server=****; user id=***; password=*****; database=remy2009"/>
ASP.NETÁ¬½ÓMySQLÐèÒªÒ»¸ö×é¼þ(.net±¾Éí²»Ìṩ·ÃÎÊMySQLµÄÇý¶¯)MySQL.Data.Dll£¬´ËΪ¹Ù·½Ìṩ(´¿C#¿ª·¢£¬¿ªÔ´àÞ)£¬Óжà¸ö°æ±¾Ñ¡Ôñ£¬²ÉÓõÄÊý¾Ý·ÃÎÊģʽΪADO.NET£¬¸úasp.net·ÃÎÊsqlserverºÜÏñ£¬·Ç³£¼òµ¥¡£
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£¬ÔÚµ¥´Êдµ½Ò»°ëʱÌáʾ¾Í³öÀ´ÁË£¬ÏÂÃæµÄ¾Í²»ÓÃдÁ˰É?¶¼ÒѾ³öÏÖ¡±´úÂëÖÇÄÜÍê³ÉÁË¡±,Ëæ±ãдһ¶Î´úÂëÊÔÊ
Ïà¹ØÎÊ´ð£º
Imports System.ComponentModel
Imports System.Web.UI
Imports System.Web.UI.Design
Imports System.Web.UI.WebControls
Namespace CBDAspNet.WebControls.HTML
''' <summary>
'' ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......