»ñÈ¡accessÊý¾Ý¿â¿ÉѹËõ´óСÎÊÌâ - VC/MFC / Êý¾Ý¿â
ͨ¹ýADO²Ù×÷accessÊý¾Ý¿â£¬ÓÉÓÚÊý¾Ý²Ù×÷ÒÔ¼°»º´æÔÒò£¬Êý¾Ý¿âÎļþ»áÔ½À´Ô½´ó¡£ÕâʱºòÎÒÃǾͻáͨ¹ýѹËõaccessÊý¾Ý¿âÀ´½â¾ö£¬µ«ÊÇÈç¹ûÿ´ÎÔËÐÐÊý¾Ý¿âµÄʱºò£¬¶¼Ñ¹ËõÒ»±é£¬ÄÇÖØ¸´¹¤×÷Ò²¶àÁ˵ã°É£¬ÎÒÏë¡£ËùÒÔÎÒÏëÄܲ»ÄÜͨ¹ýÅжÏaccessÊý¾Ý¿â¿ÉѹËõ¿Õ¼ä´óСÀ´Ñ¡ÔñʲôʱºòѹËõÄØ£¿²»¹ýÓÉÓÚÎÒÄÜÁ¦²»×ã°¡£¬Ã»ÄÜÏëµ½ºÃµÄ°ì·¨£¬Çë½ÌÏ´ó¼Ò£¬Ñ§Ï°Ï¡£
½áÌùÌáÐÑ
Èç¹ûÄúµÄÎÊÌâÒѾµÃµ½½â¾ö£¬ÇëÄúÔçÈÕ½áÌù£¬ÈçËÄÈÕºóδ½áÌù£¬¸ÃÌù½«×öÇ¿ÖÆ½áÌù´¦Àí¡£
Èç¹ûÄúµÄÎÊÌâÉÐδµÃµ½½â¾ö£¬Çë»Ø¸´·½±ãÆäËûÍøÓÑÖªµÀÄãÈÔ¹Ø×¢¸ÃÎÊÌâ¡£ÈçËÄÈÕºóûÓÐÆäËûÍøÓѺÍÂ¥Ö÷±¾È˻ظ´£¬¸ÃÌù½«×öÇ¿ÖÆ½áÌù´¦Àí¡£
Èç¹ûÌù×ÓÖ»ÓÐÂ¥Ö÷ºÍÇ¿ÖÆ½áÌùµÄ°æÖ÷±¾È˻ظ´£¬½«°´ÎÞÂúÒâ½áÌû´¦Àí¡£
×¢£ºÇ¿ÖƽáÌù°æÖ÷±¾È˽«²»»á·ÖÅä´ðÌâ·Ö
Ïà¹ØÎÊ´ð£º
VB.NET code:
Public Class excelAccess
Public Function exceltoTb(ByVal strExcelFileName As String, ByVal strSheetName As String) As System.Data.DataTable
Dim cnnStr As String = " ......
ÓÉÓÚ×éºÏ¿òµÄÐÐÀ´Ô´Êý¾ÝºÜ¶à,ËùÒÔÎÒдÁËÒÔÏ´úÂë:
Private Sub F_NAME_Change()
Me.F_NAME_±êÇ©.SetFocus
Me.F_NAME.Requery
Me.F_NAME.SetFocus
If Nz(F_NAME) <& ......
ÎÒÓÃVC++×ö¸öС³ÌÐò£¬ÐèÒªÁ¬½ÓAccessÊý¾Ý¿â¡£Êý¾Ý¿âÁ¬½ÓÊdzɹ¦µÄ¡£ÔÚÏòÊý¾Ý¿â²åÈëÊý¾Ýʱ£¬×ÜÊÇÌáʾ"INSERT INTOÓï¾äµÄÓï·¨´íÎó"¡£µ«ÎÒ¸ú×ÙÎÒµÄVC++³ÌÐò½«insertÓï¾ä¿½³öÀ´·Åµ½ Access ÖÐÖ±½ÓÖ´ÐÐÊÇ¿ÉÒԵġ ......
public class OleConn
{
private static OleDbConnection conn;
private OleConn()
{
}
public static OleDbConnec ......
´ó¼ÒºÃ°¢£¬ÎÒÓÐÒ»¸öÀà
class CItem
{
public:
char itemName[20][100];
CItem();
};
CItem::CItem()
{
memset(itemName,0x00,sizeof(itemName));
}
CItem* items[20]={NULL};
items[0]=new CItem();
......