·ÃÎÊaccessÎÊÌ⣬ÇóÖú - .NET¼¼Êõ / C#
ÔÚc#³ÌÐòÀïÃæÆ´½ÓµÄsqlÓï¾äÖ±½ÓÔÚaccessÖÐÖ´ÐÐÄܲéѯ³öÊý¾Ý£¬µ«ÊÇÔÚC#³ÌÐòÀïÃæ¾Í²»ÄÜÖ´ÐУ¬Ò»Ö±Ã»ÕÒµ½ÔÒò£¬
SELECT TOP 15 *
from B_MemberPublishMessage
WHERE PUBLISHTIME <= now() AND STARTCITY = '³É¶¼' AND ((ENDPROVINCE+ENDCITY+ENDCOUNTRY+PUBLISHCONTENT LIKE '*ÐĮ̈*') )
ORDER BY [MaxID] DESC
Íû¸÷λָµã~~~¾ÈÃüÓõÄ~
ÐèÒª¿´ÄãÔÚC#ÀïÃæÊÇÔõôµ÷ÓÃÖ´ÐÐÕâÌõSQLµÄ£¬
1.Êý¾Ý¿âÈçºÎÁ¬½ÓµÄ´úÂë
2.Ö´ÐÐÕâÌõÃüÃûµÄ´úÂë
ͬÒâÂ¥ÉÏ£¬°ÑÁ¬½Ó´®ºÍÏà¹Ø´úÂëÌù³öÀ´£¬Ò²ÐíÄÜ·¢ÏÖ´íÎó¡£
private static string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @"MemberData.rar;User ID=admin;Password=;Jet OLEDB:Database Password=123";
public static DataSet Query(string SQLString)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OleDbDataAdapter command = new OleDbDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (System.Data.OleDb.OleDbException ex)
{
// throw new Exception(ex.Message);
}
return ds;
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
´íÎóÌáʾ£º
Error creating bean with name 'DAOProxy' defined in class path resource [appcontext.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionMana ......
ÓÐûÓÐASP.net ÆóÒµÍøÕ¾¹ÜÀíϵͳ£¬ÒªÇóÊÇ¿ªÔ´µÄ·£¡
È¥SourceForge.netÉÏÕÒÕÒ¡£
http://www.wygkdown.cn/qywz37wrtxcn.rar
http://www.wygk.cn/Product.asp?BigClassName=4ÆóÒµÍøÕ¾¹ÜÀíϵͳÕý°æ
cup ......