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

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ÖÐÊÇ"?"


Ïà¹ØÎĵµ£º

asp.net c# Êý¾Ý¿â±¸·Ý

protected void btnsearch_ServerClick(object sender, EventArgs e)
    {
        string lujing=this.Text2.Value.ToString().Trim();
        string shujuku = this.jine.Value;
      &nbs ......

asp.net ÑéÖ¤Âë

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 26¸ö³£ÓÃÐÔÄÜÓÅ»¯·½·¨

Êý¾Ý¿â·ÃÎÊÐÔÄÜÓÅ»¯
Êý¾Ý¿âµÄÁ¬½ÓºÍ¹Ø±Õ
¡¡¡¡·ÃÎÊÊý¾Ý¿â×ÊÔ´ÐèÒª´´½¨Á¬½Ó¡¢´ò¿ªÁ¬½ÓºÍ¹Ø±ÕÁ¬½Ó¼¸¸ö²Ù×÷¡£ÕâЩ¹ý³ÌÐèÒª¶à´ÎÓëÊý¾Ý¿â½»»»ÐÅÏ¢ÒÔͨ¹ýÉí·ÝÑéÖ¤£¬±È½ÏºÄ·Ñ·þÎñÆ÷×ÊÔ´¡£ ASP.NETÖÐÌṩÁËÁ¬½Ó³Ø(Connection Pool)¸ÄÉÆ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â¶ÔÐÔÄܵÄÓ°Ï졣ϵͳ½«Óû§µÄÊý¾Ý¿âÁ¬½Ó·ÅÔÚÁ¬½Ó³ØÖУ¬ÐèҪʱȡ³ö£¬¹Ø±ÕʱÊÕ»ØÁ ......

ASP.NET·ÖÒ³·½·¨µÄÁ˽â³Ì¶È

ASP.NET·ÖÒ³·½·¨µÄÁ˽â³Ì¶È
¡¾³öÏÖÆµÂÊ¡¿
¡ï¡ï¡ï¡ï¡î
¡¾½â´ð¡¿
ASP.NET·ÖÒ³µÄ³£Ó÷½·¨ÓÐÒÔϼ¸ÖÖ¡£
q ÆôÓò¿·ÖÊý¾Ý¿Ø¼þµÄÄÚÖ÷ÖÒ³¹¦ÄÜ£¬ÈçÉèÖÃGridView¿Ø¼þµÄ“AllowPaging”ÊôÐÔΪ“true”£¬ÀàËÆµÄÊý¾Ý¿Ø¼þ»¹ÓÐDetailsViewµÈ¡£
q ͨ¹ýSQL²éѯÓï¾ä£¬ÒÔÌáȡָ¶¨²¿·ÖµÄÊý¾ÝµÄ·½Ê½Íê³É·ÖÒ³µÄ¹¦ÄÜ¡£Ò ......

ÔÚasp.netÖÐʹÓÃsession³£¼ûÎÊÌ⼯½õ

ÎÊ£ºÎªÊ²Ã´SessionÔÚÓÐЩ»úÆ÷ÉÏż¶û»á¶ªÊ§£¿
´ð£º¿ÉÄܺͻúÆ÷µÄ»·¾³ÓйØÏµ£¬±ÈÈ磺·À»ðǽ»òÕßɱ¶¾Èí¼þµÈ£¬³¢ÊԹرշÀ»ðǽ¡£
ÎÊ£ºÎªÊ²Ã´µ±µ÷ÓÃSession.Abandonʱ²¢Ã»Óм¤·¢Session_End·½·¨£¿
´ð£ºÊ×ÏÈSession_End·½·¨Ö»Ö§³ÖInProc£¨½ø³ÌÄڵģ©ÀàÐ͵ÄSession¡£Æä´ÎÒª¼¤·¢Session_End·½·¨£¬±ØÐë´æÔÚSession£¨¼´ÏµÍ³ÖÐÒѾ­Ê¹Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ