VS2008²Ù×÷AccessÎÊÌâ - .NET¼¼Êõ / C#
VS2008ÖÐC#²Ù×÷AccessÊý¾Ý¿â£¬ÍøÉÏÏÂÔØÁËÒ»¸öÀ࣬¿ÉÒÔÕý³£Á¬½Ó£¬¶ÁÈ¡Êý¾Ý£¬µ«ÊDzåÈëɾ³ý²Ù×÷ËÆºõÓÐÎÊÌ⣬ÒÔÏÂÊDz¿·Ö´úÂ룺
Êý¾Ý¿âÀࣺ
namespace AccessDb
{
public class AccessDbClass
{
public AccessDbClass(string Dbpath)
{
ConnString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
ConnString += Dbpath;
Conn = new OleDbConnection(ConnString);
Conn.Open();
}
public bool ExecuteSQLNonquery(string SQL)
{
OleDbCommand cmd = new OleDbCommand(@"DELETE from student", Conn);
try
{
cmd.ExecuteNonQuery();
return true;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return false;
}
}
}
}
µ÷ÓôúÂ룺
AccessDbClass mydb = new AccessDbClass("test.mdb");
if (mydb.ExecuteSQLNonquery(@"Delete * from student"))
{
MessageBox.Show("OK");
}
&nb
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......
¡°¾²Ì¬·½·¨ºÍ¾²Ì¬±äÁ¿´´½¨ºóʼÖÕʹÓÃͬһ¿éÄڴ棬¶øÊ¹ÓÃʵÀýµÄ·½Ê½»á´´½¨¶à¸öÄÚ´æ."
Õâ¾ä»°¶ÔÂð£¿
ÔÚ¶àÏ̺߳ÍÒì²½³ÌÐòÖ´ÐÐʱ£¬Ê¹Óþ²Ì¬·½·¨»á³öÏÖÒì³£Âð£¿
ÀàµÄ¶à¸öʵÀý,Æä´úÂëÔÚÄÚ´æÖÐÒ²Ö»ÊÇÒ»·Ý,ÿ¸öʵÀ ......
ÓÃlistviewÏÔʾ³ö´ÓÊý¾Ý¿âÖвéѯ³öµÄ¼Ç¼£¬ÏëÔÚ×îºó¼Ç¼ºóÃæÌí¼ÓÒ»ÌõºÏ¼ÆÐУ¬ÈçºÎʵÏÖ£¡Ð»Ð»´ó¼Ò£¡
°ó¶¨Êý¾ÝÄãÓ¦¸ÃûÎÊÌâ°É£¬°ó¶¨ÍêÒÔºóÓÃÒ»¸öÑ»·°ÑÄãҪͳ¼ÆÊý¾ÝµÄÁÐÖеÄÊý¾Ý×ܺÍÓÃÒ»¸ö±äÁ¿½ÓÊÜ£¬È»ºóÔÚÑ»·ÍâÃæne ......
ÇëÎʸ÷λ´óÏÀ,ÎÒÌý˵c#ºÍjava¿ÉÒÔ»¥×ª,ÇëÎÊÓÃʲô¹¤¾ß?
C# code:
ÊÖ£¬ÄÔ´ü£¬¼üÅÌ¡£¡£¡£
»ù±¾ÉϺÜÄÑ
yourself
ºÇºÇ ¹Ø×¢Ï ûÌý˵¹ý
Ó﷨ת»»ÓÐʲôÒâÒ壬ËüÃÇ´¦ÓÚ²»Í¬µÄ¿ò¼Ü Éæ¼°µÄÀà¿â²»Ò»Ñù£¬ÓÃʲ ......