c# Á¬½ÓMySqlÊý¾Ý¿âµÄÁ½ÖÖ·½·¨
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ
MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using
System;
using
System.Collections.Generic;
using
System.ComponentModel;
using
System.Data;
using
System.Data.Odbc;
using
System.Drawing;
using
System.Linq;
using
System.Text;
using
System.Windows.Forms;
using
MySQLDriverCS;
namespace
mysql
{
public
partial
class
Form1
: Form
{
public
Form1()
{
InitializeComponent();
}
private
void
Form1_Load(object
sender, EventArgs
e)
{
MySQLConnection
conn = null
;
conn = new
MySQLConnection
(new
MySQLConnectionString
("localhost"
, "inv"
, "root"
, "831025"
).AsString);
conn.Open();
MySQLCommand
commn = new
MySQLCommand
("set names gb2312"
, conn);
commn.ExecuteNonQuery();
string
sql = "select * from exchange "
;
MySQLDataAdapter
mda =
Ïà¹ØÎĵµ£º
C#ÓëFlash½»»¥ £¨×ª×ÔСÀÚÔÚÏߣ©
C#ÓëFlash½»»¥
ǰ¶ÎÈÕ×Ó¹«Ë¾ÒªÇó×öÒ»¸öC#ÓëFlash½»»¥µÄ¶«Î÷£¬ÓÃÀ´C#Óë¶ÌÐÅèͨѶ½«Êý¾Ý´«µ½FlashÉÏÏÔʾÓë²Ù×÷µÄÓ¦Óá£
µÚÒ»²½C#Ìí¼Ó×é¼þ
´ò¿ªVS2005-¹¤¾ß-Ñ¡Ôñ¹¤¾ßÏäÏî-COM×é¼þ-Ñ¡ÔñShockwave Flash Object-È·¶¨
Ìí¼ÓºÃ×é¼þÍù³¡¾°ÉÏÍÏ·Å£¬Èç¹ûÌáʾע²áÐèÇó×¢²á
c# ×¢²á¿Ø¼þ-ÔÚÔËÐÐÊä ......
ÔÚASP.NetÒ»°ãµÄ³ÌÐò±àдÖУ¬ËùʹÓõÄÊý¾ÝÀïÃæ£¬ÈÕÆÚʱ¼äÊÇÒ»ÖÖÌØÊâµÄÊý¾ÝÀàÐÍ£¬Ò²ÊǾ³£±»Ê¹Óõġ£---µçÄԽ̳̼¼ÊõÑ§Ï°Íø
ÔÚVisual Basic.NETÖеÄÈÕÆÚʱ¼äÊý¾ÝÓÃÊýÖµµÄÊý¾ÝÀàÐͱ£´æ£¬¶øÇÒÓз¶Î§¡£
ÈÕÆÚµÄ·¶Î§Êǹ«Ôª1Äê1ÔÂ1ÈÕ¡«¹«Ôª9999Äê1 2ÔÂ3 1ÈÕ£¬Ê±¼äµÄ·¶Î§ÊÇ00£º00£º00¡«23£º59£º59¡£ÉùÃ÷¸ñÊ½È ......
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¶ÔS ......
Êý¾Ý²Ö¿âÖ®¸¸Bill InmonÔÚ1991Äê³ö°æµÄ“Building the Data
Warehouse”Ò»ÊéÖÐËùÌá³öµÄ¶¨Òå±»¹ã·º½ÓÊÜ——Êý¾Ý²Ö¿â£¨Data Warehouse£©ÊÇÒ»¸öÃæÏòÖ÷ÌâµÄ£¨Subject
Oriented£©¡¢¼¯³ÉµÄ£¨Integrated£©¡¢Ïà¶ÔÎȶ¨µÄ£¨Non-Volatile£©¡¢·´Ó³ÀúÊ·±ä»¯£¨Time
Variant£©µÄÊý¾Ý¼¯ºÏ£¬ÓÃÓÚÖ§³Ö¹ÜÀí¾ö²ß(D ......
mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö
Ò». MySQLÃÜÂëµÄ»Ö¸´·½·¨Ö®Ò»
Èç¹ûÍü¼ÇÁËMySQLµÄrootÃÜÂ룬¿ÉÒÔÓÃÒÔÏ·½·¨ÖØÐÂÉèÖãº
1. KILLµôϵͳÀïµÄMySQL½ø³Ì£»
killall -TERM mysqld
2. ÓÃÒÔÏÂÃüÁîÆô¶¯MySQL£¬ÒÔ²»¼ì²éȨÏ޵ķ½Ê½Æô¶¯£»
safe_mysqld --skip-grant-tables &
3. È»ºóÓÿÕÃÜÂ뷽ʽʹÓÃrootÓû§µÇ¼ MySQL£»
......