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µ÷Óü´¿É¡£
Ê®¶¹Èý ÀÏʦ£¬Ôõô²ÅÄÜÐÞ¸Ä×Ô¼ºµÄ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
±ÈÈçµ±³ÌÐò³öÏֶδíÎóʱ£¬ÈçºÎÈóÌÐòÖØÐ¿ªÊ¼£¬¶ø²»ÊDZ»ÏµÍ³ÖÕÖ¹¡£
ÄãÏëÒì³£´¦ÀíÂð£¿
C²»Ö§³Ö¡£
ÔÙ˵£¬Òì³£ºÍ´íÎóÊDz»Í¬µÄ¡£
¶Î´íÎó¾ÍÓ¦¸ÃÖÕÖ¹¡£
assert()
abort()
exit()
µ±³ÌÐò³öÏֶδíÎóʱ,ÎÞ· ......