C#´«µÝ²ÎÊýµ½ACCESSÖеIJéѯ - .NET¼¼Êõ / C#
ACCESSÖвéѯÈçÏ£º
PARAMETERS letter Text ( 255 );
SELECT ¡¡¡¡ from table1 WHERE letter = letter
ÎÒ¿´µ½¹ý´«µÝÁ½¸ö²ÎÊý£¨Ê±¼ä£©µÄÀý×Ó¡£ÒòΪСµÜÊǰ®ºÃ£¬²»ÊÇרҵ³ÌÐòÔ±£¬ËùÒÔ²»ÖªµÀÔõô¸Ä¡£Çë¸ßÈËÖ¸µã£¬ÎÒÐèÒª´«µÝµÄÊÇ×Ö·û¡£
ÏÂÃæÊÇ´«µÝʱ¼äµÄÀý×Ó£º
C# code:
this.conn.Open();
DataSet ds = new DataSet();
OleDbCommand command = new OleDbCommand(str_QueryName);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@StartDay", OleDbType.Date).Value = str_StartDay;
command.Parameters.AddWithValue("@EndDay", OleDbType.Date).Value = str_EndDay;
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
adapter.Fill(ds);
this.conn.Close();
return dt;
×Ô¼º¶¥¶¥¡£Çë¸ßÈ˴ͽ̡£
½ã½ã¡£²»ÊÇsql¡£ÊÇaccess½¨Á¢µÄÒ»¸ö²éѯ¡£
ÎÒµÄÄǸöÀý×ÓÊÇ´«µÝÁ½¸öʱ¼ä²ÎÊý¡£ÎÒÐèÒªµÄÊÇ´«µÝÒ»¸ö×Ö·û´®£¨ACCESSÖеÄTEXT£©µÄÀý×Ó¡£ лл¡£Ð¡µÜ²»ÖªÔõô¸Ä
ºÃÈËÔÚÄÇÀï¡¡
Ïà¹ØÎÊ´ð£º
ÇëÎÊVFPÖÐÈçºÎµ÷ÓÃC/C++º¯Êý£¿
ÄãÒªµ÷ÓÃʲô¹¦Äܵĺ¯Êý£¿Òª¿´¿´VFPÖÐÓÐûÓжÔÓ¦µÄº¯Êý£¬Èç¹ûÓоÍÊ¡×ÅÔÙµ÷ÓÃÁË¡£Èç¹ûûÓУ¬¿ÉÒÔ½«C/C++º¯Êýд¸öDLL»òFLL£¬È»ºóÔÚVFPµ÷Óü´¿É¡£
Ê®¶¹Èý ÀÏʦ£¬Ôõô²ÅÄÜÐÞ¸Ä×Ô¼ºµÄ ......
´ó¼ÒºÃ£¬ÕâÊÇÒ»¸öÖ÷ÒªÃæÏòc/c++/mfcµÄȺ£¬×î½ü½øÐÐÁËÒ»´Î´óÇåÀí£¬»¶Ó¸÷λ¸ßÊÖ¼ÓÈ룬ºÃѧ°®ÎʵÄÐÂÊÖ£¬Ò²¿ÉÒÔÉêÇëµÄ£¬ÉêÇë¸ñʽ Ö°Òµ£¨c/c++/mfc ÈÎѡһ»òÕ߶ࣩ ¹¤×÷ÄêÏÞ£¨Ñ§ÉúÖ±½Óд´ó¼¸£©¾ÍÐÐÁË£¬ÈëȺµÄÒªÇó¾ÍÊÇÒª» ......
´ó¼ÒºÃ£¬ÕâÊÇÒ»¸öÖ÷ÒªÃæÏòc/c++/mfcµÄȺ£¬×î½ü½øÐÐÁËÒ»´Î´óÇåÀí£¬»¶Ó¸÷λ¸ßÊÖ¼ÓÈ룬ºÃѧ°®ÎʵÄÐÂÊÖ£¬Ò²¿ÉÒÔÉêÇëµÄ£¬ÉêÇë¸ñʽ Ö°Òµ£¨c/c++/mfc ÈÎѡһ»òÕ߶ࣩ ¹¤×÷ÄêÏÞ£¨Ñ§ÉúÖ±½Óд´ó¼¸£©¾ÍÐÐÁË£¬ÈëȺµÄÒªÇó¾ÍÊÇÒª» ......
ÄÚÈÝÈçÌâ¡£¡£ÔÚC#Àï¸ÄÈçºÎÐ´ÄØ£¿
±¾À´Ë¼Â·ÊÇÏȱȶԽڵãÃû³Æ£¬ÈçÊǵϰ¾Í±£´æÒªÉ¾³ý½ÚµãµÄϱê·ÅÔÚÊý×éÀȻºóÑ»·É¾³ý£¬µ«·¢ÏÖ¡£¡£µ±ÎÒɾ³ýµÚÒ»¸öºó£¬ËùÓнڵãϱêÊýÁ¿¶¼·¢Éú¸Ä±ä¡£¡£
¾Í²»ÄÜÔÙ°´ÕÕ֮ǰ¼Í¼µÄ½Úµã ......
ÔÚ¸ùĿ¼/libÖдæ·ÅÒ»¸ölog.c£¬log.h£¬²¢ÓÃÏÂÃæµÄÓï¾ä£º
gcc -c log.c
ar crv liblog.a log.o
±àÒë³öÒ»¸öliblog.a¾²Ì¬¿â£¬È»ºóÔÚÎļþ¼Ð£º/testfileÖд´½¨Ò»¸ötest.cºÍtestc.c£¬test.cÖÐÒýÓÃÁËtestc.cÖж¨ÒåµÄ·½·¨ ......