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
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ÍøÉÏCOPYÒÔ¼°ÕûÀí»Ø´ðÍøÓѵÄÎÊÌâ¡£´ó¼Ò¿ÉÒÔ¼ÓÈëÎÒн¨µÄQQȺһÆðÁÄÁÄ£¬¹²Í¬Ñ§Ï°¡£
QQȺºÅ£º109967503
c#µÄÒ»Ð©ÌØÕ÷£º
Íêȫ֧³ÖÀàºÍÃæÏò¶ÔÏó±à³Ì£¬°üÀ¨½Ó¿ÚºÍ¼Ì³Ð¡¢Ð麯ÊýºÍÔËËã·ûÖØÔØµÄ´¦Àí¡£
¶¨ÒåÍêÕû¡ ......
¡°¾²Ì¬·½·¨ºÍ¾²Ì¬±äÁ¿´´½¨ºóʼÖÕʹÓÃͬһ¿éÄڴ棬¶øÊ¹ÓÃʵÀýµÄ·½Ê½»á´´½¨¶à¸öÄÚ´æ."
Õâ¾ä»°¶ÔÂð£¿
ÔÚ¶àÏ̺߳ÍÒì²½³ÌÐòÖ´ÐÐʱ£¬Ê¹Óþ²Ì¬·½·¨»á³öÏÖÒì³£Âð£¿
ÀàµÄ¶à¸öʵÀý,Æä´úÂëÔÚÄÚ´æÖÐÒ²Ö»ÊÇÒ»·Ý,ÿ¸öʵÀ ......
ÇëÎʸ÷λ´óÏÀ,ÎÒÌý˵c#ºÍjava¿ÉÒÔ»¥×ª,ÇëÎÊÓÃʲô¹¤¾ß?
C# code:
ÊÖ£¬ÄÔ´ü£¬¼üÅÌ¡£¡£¡£
»ù±¾ÉϺÜÄÑ
yourself
ºÇºÇ ¹Ø×¢Ï ûÌý˵¹ý
Ó﷨ת»»ÓÐʲôÒâÒ壬ËüÃÇ´¦ÓÚ²»Í¬µÄ¿ò¼Ü Éæ¼°µÄÀà¿â²»Ò»Ñù£¬ÓÃʲ ......