access²éѯ£¬Èç¹û´æÔÚ½ö·µ»ØµÚÒ»Ðнá¹û

Êý¾Ý¿âÏÖÔÚÓÐ63000ÐÐÊý¾Ý£¬Ä¿Ç°²éѯÔÚ40ºÁÃë×óÓÒ¡£

ÎÒÏëÎʵÄÊÇÈçºÎ½ö½ö·µ»ØµÚÒ»¸ö²éѯ½á¹û£¬È»ºóÁ¢¼´½áÊøµ±Ç°²éѯ£¨Ä¿µÄ¾ÍÊÇÈòéѯʱ¼ä¶ÌÒ»µã£©£¬²»Öƶ¨ÖªµÀÈçºÎдsqlÓï¾ä¡£


//ÎÒÏÖÔÚÊÇʹÓÃÏÂÃæ·½·¨

            string result = "";

            string mySQL = "select * from " + TableName  + " where Md5='" + Md5String + "'";

            OleDbCommand myCommand = new OleDbCommand(mySQL, myConnection);

            OleDbDataReader myReader = myCommand.ExecuteReader();


            while ( myReader.Read())
            {
                result = myReader.GetString(0) + " " + myReader.GetString(1);

            }
         
·Ç³£¸Ðл

---

C# code:
string mySQL = "select Top 1 * from " + TableName + " where Md5='" + Md5String + "'";

{{--