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

vs2008Óëmysql½áºÏµÄÓ÷¨...

¿ÉÒÔ¸ø¸öÀý×ÓÂð°¡£¿

ÈçÊý¾Ý¿âÁ´½Ó·½·¨£¬ÊµÏÖ Ôö£¬É¾£¬¸Ä£¬²é£¬µÈËĸö·½·¨
Óиö¿ªÔ´.netÈí¼þ½Ð×öDBLinq£¬ÕâÀïÎÒËѵ½Ò»¸ö½éÉÜ£º

http://www.cnblogs.com/bitstudio/archive/2009/03/20/1417672.html

DBLinqʹÓÃÕâ¸öÍøÖ·ÏÂÔØ£¨²»ÒªÊ¹ÓÃÉÏÃæµÄ£©£ºhttp://www.codeplex.com/dblinq

¾Í¸úÄãʹÓÃLinq to SQLÒ»Ñù£¬¾ÍÄÇô¾Å¸öÃüÁ10·ÖÖÓѧ»á·ÃÎÊMySQL¡¢MySQL¡¢PostgreSQL,¡¢Oracle¡¢Ingres¡¢SQLite¡¢FireBird¡£

²»ÊÇ¡°¾Å¸ö¡±£¬ÊÇ¡°¼¸¸ö¡±¡£

Mark,DBLinq,

ÈõÈõµÄÎÊÏ£¬Õâ¸öÊDz»ÊÇÏ൱ÓÚÎÒÃÇ֮ǰµÄSQLHelper°¡¡£

Ö»ÊÇÕâ¸öÊÇLinq°æµÄ£¿

ÎÒµÈÏÂÈ¥¿´ÏÂ

ÄÇÎÒÏë¸ù¾ÝÒ»¸ö×ֶβéÑ¯ÄØ£¿£¿ 
        string sql = "SELECT * from nt_User WHERE name = @name";

            try
            {
                MySqlDataReader reader = DBconn.GetReader(sql, new MySqlParameter("@name",name));
                if (reader.Read())
                {

£¿£¿£¿

  string sql = "SELECT * from nt_User WHERE name = ?name";


Ïà¹ØÎÊ´ð£º

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

cÓïÑÔÈçºÎÁ¬½ÓMYSQL£¿

´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ