vc++ADOX创建数据库

上传者: china_jqy | 上传时间: 2023-11-22 08:03:12 | 文件大小: 13.59MB | 文件类型: ZIP
vc++利用ADOX创建数据库 // ADOXCreateDatabaseDlg.cpp : implementation file // #include "stdafx.h" #include "ADOXCreateDatabase.h" #include "ADOXCreateDatabaseDlg.h" #include "Shlwapi.h" #pragma comment(lib,"shlwapi.lib") // Download by http://www.codefans.net #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CAboutDlg dialog used for App About class CAboutDlg : public CDialog { public: CAboutDlg(); // Dialog Data //{{AFX_DATA(CAboutDlg) enum { IDD = IDD_ABOUTBOX }; //}}AFX_DATA // ClassWizard generated virtual function overrides //{{AFX_VIRTUAL(CAboutDlg) protected: virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support //}}AFX_VIRTUAL // Implementation protected: //{{AFX_MSG(CAboutDlg) //}}AFX_MSG DECLARE_MESSAGE_MAP() }; CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD) { //{{AFX_DATA_INIT(CAboutDlg) //}}AFX_DATA_INIT } void CAboutDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CAboutDlg) //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CAboutDlg, CDialog) //{{AFX_MSG_MAP(CAboutDlg) // No message handlers //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CADOXCreateDatabaseDlg dialog CADOXCreateDatabaseDlg::CADOXCreateDatabaseDlg(CWnd* pParent /*=NULL*/) : CDialog(CADOXCreateDatabaseDlg::IDD, pParent) { //{{AFX_DATA_INIT(CADOXCreateDatabaseDlg) m_dbName = _T(""); //}}AFX_DATA_INIT // Note that LoadIcon does not require a subsequent DestroyIcon in Win32 m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME); } void CADOXCreateDatabaseDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CADOXCreateDatabaseDlg) DDX_Text(pDX, IDC_DBNAME, m_dbName); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CADOXCreateDatabaseDlg, CDialog) //{{AFX_MSG_MAP(CADOXCreateDatabaseDlg) ON_WM_SYSCOMMAND() ON_WM_PAINT() ON_WM_QUERYDRAGICON() ON_BN_CLICKED(IDC_BTN_CREATE, OnBtnCreate) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CADOXCreateDatabaseDlg message handlers BOOL CADOXCreateDatabaseDlg::OnInitDialog() { CDialog::OnInitDialog(); // Add "About..." menu item to system menu. // IDM_ABOUTBOX must be in the system command range. ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX); ASSERT(IDM_ABOUTBOX < 0xF000); CMenu* pSysMenu = GetSystemMenu(FALSE); if (pSysMenu != NULL) { CString strAboutMenu; strAboutMenu.LoadString(IDS_ABOUTBOX); if (!strAboutMenu.IsEmpty()) { pSysMenu->AppendMenu(MF_SEPARATOR); pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu); } } // Set the icon for this dialog. The framework does this automatically // when the application's main window is not a dialog SetIcon(m_hIcon, TRUE); // Set big icon SetIcon(m_hIcon, FALSE); // Set small icon // TODO: Add extra initialization here return TRUE; // return TRUE unless you set the focus to a control } void CADOXCreateDatabaseDlg::OnSysCommand(UINT nID, LPARAM lParam) { if ((nID & 0xFFF0) == IDM_ABOUTBOX) { CAboutDlg dlgAbout; dlgAbout.DoModal(); } else { CDialog::OnSysCommand(nID, lParam); } } // If you add a minimize button to your dialog, you will need the code below // to draw the icon. For MFC applications using the document/view model, // this is automatically done for you by the framework. void CADOXCreateDatabaseDlg::OnPaint() { if (IsIconic()) { CPaintDC dc(this); // device context for painting SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0); // Center icon in client rectangle int cxIcon = GetSystemMetrics(SM_CXICON); int cyIcon = GetSystemMetrics(SM_CYICON); CRect rect; GetClientRect(▭); int x = (rect.Width() - cxIcon + 1) / 2; int y = (rect.Height() - cyIcon + 1) / 2; // Draw the icon dc.DrawIcon(x, y, m_hIcon); } else { CDialog::OnPaint(); } } // The system calls this to obtain the cursor to display while the user drags // the minimized window. HCURSOR CADOXCreateDatabaseDlg::OnQueryDragIcon() { return (HCURSOR) m_hIcon; } void CADOXCreateDatabaseDlg::OnBtnCreate() { //使输入到编辑框IDC_DBNAME的内容更新到m_dbName变量中 UpdateData(TRUE); CString str; str="d:\\\\"+m_dbName+".mdb"; //检查该数据库是否已经存在,如果该数据库已经存在,弹出消息框,返回 //使用API函数PathFileExists()检查路径文件是否存在 //请注意:为了使用API函数PathFileExists(),需要加入 //#include "Shlwapi.h" //#pragma comment(lib,"shlwapi.lib") if(PathFileExists(str)) { CString strTemp; strTemp.Format("%s已存在!",str); AfxMessageBox(strTemp); return ; } //定义ADOX对象指针并初始化为NULL //用ADOX创建access数据库方法很简单, //只需要新建一个Catalog对象,然后调用它的Create方法就可以了。 //Catalog是 ADOX 的一个对象,它包含描述数据源模式目录的集合。 //在这里,您只需知道创建数据库时使用这个对象就可以了。 //注意用try...catch组合捕捉错误 _CatalogPtr m_pCatalog = NULL; CString DBName="Provider=Microsoft.JET.OLEDB.4.0;Data source="; DBName=DBName+str; try { m_pCatalog.CreateInstance(__uuidof(Catalog)); m_pCatalog->Create(_bstr_t((LPCTSTR)DBName)); } catch(_com_error &e) { AfxMessageBox(e.ErrorMessage()); return ; } }

文件下载

资源详情

[{"title":"( 21 个子文件 13.59MB ) vc++ADOX创建数据库","children":[{"title":"ADOXCreateDatabase","children":[{"title":"ADOXCreateDatabase.h <span style='color:#111;'> 1.46KB </span>","children":null,"spread":false},{"title":"ADOXCreateDatabaseDlg.h <span style='color:#111;'> 1.47KB </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.dsp <span style='color:#111;'> 4.27KB </span>","children":null,"spread":false},{"title":"res","children":[{"title":"ADOXCreateDatabase.ico <span style='color:#111;'> 1.05KB </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.rc2 <span style='color:#111;'> 410B </span>","children":null,"spread":false}],"spread":true},{"title":"ADOXCreateDatabase.vcxproj.user <span style='color:#111;'> 143B </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.cpp <span style='color:#111;'> 2.26KB </span>","children":null,"spread":false},{"title":"msadox.tlh <span style='color:#111;'> 37.04KB </span>","children":null,"spread":false},{"title":"msadox.tli <span style='color:#111;'> 30.17KB </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.sdf <span style='color:#111;'> 48.71MB </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.dsw <span style='color:#111;'> 561B </span>","children":null,"spread":false},{"title":"ADOXCreateDatabaseDlg.cpp <span style='color:#111;'> 5.43KB </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.vcxproj.filters <span style='color:#111;'> 1.94KB </span>","children":null,"spread":false},{"title":"StdAfx.cpp <span style='color:#111;'> 220B </span>","children":null,"spread":false},{"title":"resource.h <span style='color:#111;'> 742B </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.rc <span style='color:#111;'> 5.55KB </span>","children":null,"spread":false},{"title":"StdAfx.h <span style='color:#111;'> 1.20KB </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.suo <span style='color:#111;'> 15.50KB </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.sln <span style='color:#111;'> 902B </span>","children":null,"spread":false},{"title":"ADOXCreateDatabase.vcxproj <span style='color:#111;'> 7.72KB </span>","children":null,"spread":false},{"title":"ReadMe.txt <span style='color:#111;'> 3.71KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明