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
Ïà¹ØÎÊ´ð£º
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......
ÎÒÓÃXmlDocumentÉú³ÉXML
XmlElement remarkNode = node.OwnerDocument.CreateElement("remark");
remark1Node.InnerXml = "";
Èç¹ûInnerXml¸³Öµ²»Îª¿Õ£¬ÔòÉú³ÉµÄ±ê¼ÇÊÇûÎÊÌâµÄ£¬±ÈÈ磺<r ......
ÇóÒ»±¾C#Éè¼ÆÄ£Ê½µÄÊé ,ÎҸоõÎҵĴúÂëÔËÓýӿÚ,ίÍÐ,ÊôÐԵĵط½ºÜÉÙ,¿Ï¶¨ÊÇÎÒµÄÉè¼ÆÄ£Ê½Ì«²îÁË ,ÓÐûÓÐÕâ·½Ãæ,´Ó¹úÍâ·Òë¹ýÀ´µÄ,±È½ÏºÃµÄÉè¼ÆÄ£Ê½µÄÊé,ÍÆ¼öһϰÉ,·Ç³£¸Ðл.
¸ßÈËÃÇ˵ ´úÂëÖØ¹¹µÄÊéºÃЩ,ÄÇÎÒÒª¸Ä¿´ ......
ÍøÉÏCOPYÒÔ¼°ÕûÀí»Ø´ðÍøÓѵÄÎÊÌâ¡£´ó¼Ò¿ÉÒÔ¼ÓÈëÎÒн¨µÄQQȺһÆðÁÄÁÄ£¬¹²Í¬Ñ§Ï°¡£
QQȺºÅ£º109967503
c#µÄÒ»Ð©ÌØÕ÷£º
Íêȫ֧³ÖÀàºÍÃæÏò¶ÔÏó±à³Ì£¬°üÀ¨½Ó¿ÚºÍ¼Ì³Ð¡¢Ð麯ÊýºÍÔËËã·ûÖØÔØµÄ´¦Àí¡£
¶¨ÒåÍêÕû¡ ......