c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿â
±¾ÎĽ«c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿âµÄ·½·¨¼ÓÒÔ×ܽᣬÖ÷Òª½â¾öµÄÎÊÌâÈçÏ£º
´´½¨mdb
´´½¨table
¶ÁÈ¡tableÄÚÈÝ
²é
ѯtableÖеÄÄÚÈÝ
ÏòtableÖвåÈëÊý¾Ý
ɾ³ýtableÖеļǼ
ÏòtableÖвåÈëÕÕÆ¬
¶ÁÈ¡tableÖеÄÕÕÆ¬µÈ¡£
ÎÄ
½éÉÜC#
·ÃÎʲÙ×÷AccessÊý¾Ý¿âµÄ»ù´¡ÖªÊ¶£¬²¢Ìá
¹©Ò»¸öÏà¹ØµÄÀý³Ì¡£C#µÄADO.NET»¹²»ÄÜͨ¹ý±à³Ì·½Ê½´´½¨È«ÐµÄACCESS(MDB)Êý¾Ý¿â£¬ËùÒÔ»¹Ö»ÄÜʹÓÃADOXÕâ¸öÀ´×ÔCOMµÄÁ´½Ó¿âÀ´²Ù
×÷¡£
Ö÷Ҫ֪ʶµãÈçÏ£º
using System.Data.OleDb;
using System.Data;
Á¬½Ó×Ö·û
´®£ºString connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=product.mdb";
½¨Á¢Á¬½Ó£ºOleDbConnection connection = new
OleDbConnection(connectionString);
ʹÓÃOleDbCommandÀàÀ´Ö´ÐÐSqlÓï¾ä£º
OleDbCommand
cmd = new OleDbCommand(sql, connection);
connection.Open();
cmd.ExecuteNonQuery();
1.´´½¨mdb¿â£¬Àý³ÌÈçÏ£º
ÐèҪעÒâµÄÊÇ£º²ÎÊýmdbPathÊÇmdbµÄÍêÕû·¾¶£¨²»°üº¬±íµÄÃû³Æ£©¡£ÀýÈ磺D:\\test.mdb
//´´½¨mdb
public static bool
CreateMDBDataBase(string mdbPath)
{
try
{
ADOX.CatalogClass cat = new ADOX.CatalogClass();
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath +
";");
cat = null;
return true;
}
catch { return false; }
}
2.´´½¨¾ßÌåµÄ±í£¬À
Ïà¹ØÎĵµ£º
¿´Á˺ܶà.°´ÕÕ ×Ô¼ºÃ÷°×½âÊÍһϠ.NET RefºÍOut¹Ø¼ü×Ö ¶ÔÓÚÖµÀàÐÍ¡£ Èç¹û²»Ê¹ÓÃref /outÔò´«µÝµÄÖ»ÊÇÕâЩֵµÄCOPY, ʹÓÃÁËRefºÍOutµÄЧ¹û¾Í¼¸ºõºÍCÖÐʹÓÃÁËÖ¸Õë±äÁ¿Ò»Ñù¡£(´«µÝµÄ¾ÍÊÇÔÖµ),ËüÄܹ»ÈÃÄãÖ±½Ó¶ÔÔÊý½øÐвÙ×÷£¬¶ø²»ÊǶÔÄǸöÔÊýµÄCopy½øÐвÙ×÷ ¶ÔÓÚÒýÓÃÀàÐÍ: Èç¹û²»Ê¹ÓÃref /out,ÒòΪ´«µÝµÄÊÇÒýÓÃÀàÐ͵ĵØÖ·Öµ,Ô ......
ËØÊýÊÇÖ»Äܱ»1»ò±¾ÉíÕû³ý£¬ÇÒ²»ÄÜΪÆäËûÁ½¸öÕûÊýµÄ³Ë»ý¡£1¡¢2¡¢3±¾Éí¾ÍÊÇËØÊý£¬ÅжÏÒ»¸öÊýÊÇ·ñÎªËØÊý£¬Ö»ÐèÒªÓÃÕâ¸öÖµÒÀ´Î³ýÒÔ2µ½ËüµÄ¿ª·½Êý£¬Èç¹ûÆäÖÐÓÐÒ»¸öÊý¿ÉÒÔÕû³ý£¬ÄÇô¸ÃÖµ²»ÎªËØÊý£¬·µÖ®ÎªËØÊý¡£´úÂëÈçÏÂ
publicboolprimeNumber(intn)
{
¡¡¡¡boolb=true;
¡¡¡¡if(n==1||n==2)
¡¡¡¡¡¡¡¡b=true;
¡¡¡¡else
¡¡¡¡{ ......
using System;
using System.Web;
using System.Data;
using System.Text;
using System.Xml;
using System.IO;
namespace Baolee.GeneralMethod
{
/// <summary>
/// WriteXml µÄժҪ˵Ã÷¡£
/// </summary>
public class WriteXml
{
/// <summary>
......
·¢ËͶËÒÔ163ΪÀý
Ò»¡¢asp.net°æ using System.Web.Mail; //ÃüÃû¿Õ¼äÒýÓÃ
c#
MailMessage mail = new MailMessage();
mail.To = "shadow103@qq.com"; //½ÓÊÜÈ˵ÄÓÊÏä
& ......
Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“ Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ” ......