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ÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......
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µÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......