文件名称:QueryExporterAndPoster
- 所属分类：
- SQL Server数据库
- 资源属性：
- [Windows] [Visual.Net] [源码]
- 上传时间：
- 2015-04-26
- 文件大小：
- 1.93mb
- 下载次数：
- 0次
- 提 供 者：
- 张**
- 相关连接：
- 无
- 下载说明：
- 别用迅雷下载，失败请重下，重下不扣分！
介绍说明－－下载内容均来自于网络，请自行研究使用
SQL Server数据库查询自动导出发送工具,该工具可以在SQL Server数据库中执行SQL查询文件获取数据，并将结果自动保存为Excel 2007格式的文件，同时判断其大小是否大于邮件添加附件的最大容量。如果附件过大，则自动压缩为7z格式，否则立即发送附件给指定邮箱。并再次判断7z压缩包大小是否大于邮件添加附件的最大容量，如附件仍然过大，则发送共享文件路径，否则立即发送7z压缩包，从而省去了等待查询结果的时间。
-SQL Server query is sent automatically export tool that can SQL query file in the SQL Server to obtain data, and the results are automatically saved as Excel 2007 file format, while the message to determine its size is greater than the maximum capacity to add attachments. If the attachment is too large, it is automatically compressed 7z format, or attachments sent immediately to the specified mailbox. And judge again 7z archive size is greater than the maximum capacity of the message to add accessories such as accessories is still too large, it sends a shared file path, or sent immediately 7z archive, thus eliminating the need to wait for the results of the query time.
-SQL Server query is sent automatically export tool that can SQL query file in the SQL Server to obtain data, and the results are automatically saved as Excel 2007 file format, while the message to determine its size is greater than the maximum capacity to add attachments. If the attachment is too large, it is automatically compressed 7z format, or attachments sent immediately to the specified mailbox. And judge again 7z archive size is greater than the maximum capacity of the message to add accessories such as accessories is still too large, it sends a shared file path, or sent immediately 7z archive, thus eliminating the need to wait for the results of the query time.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
QueryExporterAndPoster\QueryExporterAndPoster\App.config
......................\......................\frmConnect.cs
......................\......................\frmConnect.designer.cs
......................\......................\frmConnect.resx
......................\......................\frmMain.cs
......................\......................\frmMain.Designer.cs
......................\......................\frmMain.resx
......................\......................\frmProperty.cs
......................\......................\frmProperty.designer.cs
......................\......................\frmProperty.resx
......................\......................\lib-npoi\ICSharpCode.SharpZipLib.dll
......................\......................\........\NPOI.dll
......................\......................\........\NPOI.OOXML.dll
......................\......................\........\NPOI.OOXML.XML
......................\......................\........\NPOI.OpenXml4Net.dll
......................\......................\........\NPOI.OpenXml4Net.XML
......................\......................\........\NPOI.OpenXmlFormats.dll
......................\......................\........\NPOI.XML
......................\......................\....SevenZipSharp\7z.dll
......................\......................\.................\SevenZipSharp.dll
......................\......................\Program.cs
......................\......................\...perties\AssemblyInfo.cs
......................\......................\..........\Resources.Designer.cs
......................\......................\..........\Resources.resx
......................\......................\..........\Settings.Designer.cs
......................\......................\..........\Settings.settings
......................\......................\QueryExporterAndPoster.csproj
......................\......................\SMO.cs
......................\QueryExporterAndPoster.sln
......................\QueryExporterAndPoster.v12.suo
......................\......................\bin
......................\......................\lib-npoi
......................\......................\lib-SevenZipSharp
......................\......................\obj
......................\......................\Properties
......................\QueryExporterAndPoster
QueryExporterAndPoster