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

ASP.NET ²Ù×÷MySQLÊý¾Ý¿âµÄ·½·¨ËµÃ÷

using System;
using System.Data;
using System.Diagnostics;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
namespace System
{
 /// <summary>
 /// Description of MySqlDBUtil.
 /// </summary>
 public class MySqlDBUtil
 {
        private static String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString.ToString();
  private MySqlDBUtil()
  {
  }
  
  //Ö´Ðе¥Ìõ²åÈëÓï¾ä£¬²¢·µ»Øid£¬²»ÐèÒª·µ»ØidµÄÓÃExceuteNonQueryÖ´ÐС£
  public static int ExecuteInsert(string sql,MySqlParameter[] parameters)
        {
         //Debug.WriteLine(sql);
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                MySqlCommand cmd = new MySqlCommand(sql, connection);
                try
                {
                    connection.Open();
                    if(parameters!=null)cmd.Parameters.AddRange(parameters);
                    cmd.ExecuteNonQuery();
                    cmd.CommandText = @"select LAST_INSERT_ID()";
&nb


Ïà¹ØÎĵµ£º

FCKeditor 2.X ÔÚ Asp.NetÖеÄÉèÖÃ

FCKeditorÏà¹Ø×ÊÁϼò½é£º
¹Ù·½ÍøÕ¾http://www.fckeditor.net/
¹Ù·½Îĵµhttp://wiki.fckeditor.net/
ÏÂÔØµØÖ·http://www.fckeditor.net/download/default.html
¹Ù·½ÑÝʾhttp://www.fckeditor.net/demo/default.html
FCKEditor asp.netÉèÖÃ
ÏÂÔØ£ºhttp://www.fckeditor.net
£¨ÒªÏÂÔØFCKeditor2.4.2.zipºÍFCKeditor.NET ......

Set MySQL to use UTF 8 and convert database

##/etc/my.cnf:
# [mysql]
# default-character-set=utf8
# [mysqld]
# character-set-server=utf8
# collation-server=utf8_general_ci
# [client]
# default-character-set=utf8
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
# dump db
mysqldump -u dbuser -pdbpass --opt --skip-set-charset --defaul ......

mysqlÊý¾Ý¿â±¸·ÝÓ뻹ԭ

mysqlÊý¾Ý¿â±¸·ÝÓ뻹ԭÃüÁ
±¸·Ý£º
ÈçÎÒÃÇÐèÒª°Ñ Êý¾Ý¿âÃûΪ£ºshopping µÄÊý¾Ý¿â±¸·Ý£º Óû§ÃûΪ£ºroot£¬ÃÜÂëΪ£º12345£¬ÄÇôÃüÁîÈçÏ£º
Ö±½Ó½øÈëdos£¬Èç¹ûûÓÐÅäÖÃmysqlµÄ»·¾³±äÁ¿£¬ÄÇôÐèÒª°ÑdosµÄµ±Ç°Ä¿Â¼Çл»µ½mysqlµÄbinĿ¼Ï£¬È»ºóÇÃÈëÒ»ÏÂÃüÁ
        mysqldump -uroo ......

±à¼­MYSQLʱ³ö´í£ºNo curses/termcap library found

»·¾³£ºCentOS linux 5.2
ϵͳֻ°²×°VI±à¼­Æ÷Ó뿪·¢¹¤¾ß
 
Ôڱ༭MYSQLʱ£º
#./configure --prefix=/usr/local/mysql --with-charset=gb2312  --with-extra-charsets=all 
Ö´Ðкó³öÏÖÈçÏ´íÎó£º
checking for tgetent in -ltermcap… no
checking for termcap functions library… config ......

asp.netÖг£ÓõÄ26¸öÓÅ»¯ÐÔÄܵķ½·¨

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