📄 稿件模板.htm
字号:
<head>
</head>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<p align="center"><b>读取SQL服务器的目录及文件列表<br>
</b><br><br>
作者：<a href="mailto:step.2000@163.com">河南：赵高建</a></p>
<p><br><br>
<font face="宋体" size="3">
编程时有时需要读取SQL服务器的目录及文件列表，特别作一些数据库备份程序的时候，本程序实现这个功能：</font></p>
<p><font face="宋体" size="3">
新建一对话框程序DbFile，添加CDbServerFileTree类，在对话框上添加一TreeCtrl，EditCtrl对应变量分别</font>
<p><font face="宋体" size="3">为CDbServerFileTree
m_tree;CString m_path;</font><p><font face="宋体" size="3">在<stafx.h>中加入</font><p><font COLOR="#0000ff"><font face="宋体" size="1">#import
</font></font><font face="宋体" size="1"><font COLOR="#000077">"C:\Program
Files\Common Files\system\ado\msado15.dll"</font> no_namespace rename
(<font COLOR="#000077">"EOF"</font>,<font COLOR="#000077">"adoEOF"</font>)</font>
<p><font face="宋体" size="1">BOOL CDbFileDlg::OnInitDialog()</font></p>
<p><font face="宋体" size="1">{CDialog::OnInitDialog();</font></p>
<p><font face="宋体" size="1"><font COLOR="#0000ff">if</font>(FAILED(::CoInitialize(NULL)))</font></p>
<p><font face="宋体" size="1"><font COLOR="#0000ff">return</font> FALSE;</font></p>
<p><font face="宋体" size="1">....</font></p>
<p><font face="宋体" size="1">m_tree.ConnectDB(<font COLOR="#000077">"XX.XX.XX.XX"</font>,
<font COLOR="#000077">"tempdb"</font>, <font COLOR="#000077">"name"</font>,
<font COLOR="#000077">"pass"</font>);</font></p>
<p><font face="宋体" size="1">m_tree.BuildTree();</font><font face="宋体" size="1">}</font></p>
<p><font face="宋体" size="3">添加消息函数</font><font COLOR="#0000ff">
<p><font face="宋体" size="1">void</font></font><font face="宋体" size="1">
CDbFileDlg::OnSelchangedTree1(NMHDR* pNMHDR, LRESULT* pResult)</font></p>
<p><font face="宋体" size="1">{</font><font COLOR="#009900"><font face="宋体" size="1">//
TODO: Add your control notification handler code here</font></p>
</font>
<p><font face="宋体" size="1">NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;</font></p>
<p><font face="宋体" size="1">HTREEITEM m_hTreeItem;</font></p>
<p><font face="宋体" size="1">m_hTreeItem=m_tree.GetSelectedItem();</font></p>
<p><font face="宋体" size="1">m_name=m_tree.GetPathFromHere(<font COLOR="#000077">""</font>,m_hTreeItem);</font></p>
<p><font face="宋体" size="1">UpdateData(<font COLOR="#0000ff">false</font>);</font></p>
<p><font face="宋体" size="1">*pResult = 0;</font></p>
<p><font face="宋体" size="1">}</font></p>
<p><font face="宋体" size="3">添加位图资源IDB_DIRECTORY，如下图所示</font></p>
<p><img border="0" src="稿件2.gif" width="66" height="16">
<br>
<img border="0" src="稿件3.jpg" width="441" height="405"><br>
上图是程序运行结果<br>
<br>
四、程序还有内存泄漏等bug，还望大家提出修改更正意见
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -