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

·ÃÎÊ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²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

winform±à³ÌÓëASP.NETÓÐÁ¬ÏµÂð - .NET¼¼Êõ / C#

ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼­Åжϵȶ¼ÐèÒªwinform»ù´¡

C#ÓïÑÔ 
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹

Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......

springÁ¬½Óaccess³öÏÖ´íÎó

´íÎóÌáʾ£º
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 ÆóÒµÍøÕ¾¹ÜÀíϵͳ - .NET¼¼Êõ / C#

ÓÐûÓÐASP.net ÆóÒµÍøÕ¾¹ÜÀíϵͳ£¬ÒªÇóÊÇ¿ªÔ´µÄ·£¡

È¥SourceForge.netÉÏÕÒÕÒ¡£

http://www.wygkdown.cn/qywz37wrtxcn.rar

http://www.wygk.cn/Product.asp?BigClassName=4ÆóÒµÍøÕ¾¹ÜÀíϵͳÕý°æ

cup ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ