91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

注意事項(xiàng)：

1.修改Database設(shè)置
alter database set enable_broker with rollback immediate;

2.SQL的查詢語法中不能使用 [*] 的方式
[錯(cuò)誤的：] select * From [dbo].[alarm_table]

[正確的] select sn,address,create_time From [dbo].[alarm_table]

資源截圖

代碼片段和文件信息 

using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.SqlClient;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?System.Configuration;

namespace?SqlDependency_Test?{
????public?partial?class?Form1?:?Form?{

????????/*?確認(rèn)DB有執(zhí)行?[alter?database??set?enable_broker?with?rollback?immediate;]?*/

????????SqlConnection?connection?=?new?SqlConnection（）;
????????private?static?string?ConnectionString;

????????public?Form1（）?{
????????????InitializeComponent（）;
????????}


????????/*?啟動(dòng)SQL監(jiān)控?*/
????????private?void?btn_Start_Click（object?sender?EventArgs?e）?{
????????????try?{
????????????????ConnectionString?=?“Data?Source=“?+?txt_dbSource.Text?+?“;Initia

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????2518??2018-01-04?16:34??.gitattributes
?????文件????????2806??2018-01-04?16:34??.gitignore
?????目錄???????????0??2018-07-30?12:51??.vs\
?????目錄???????????0??2018-07-30?12:51??.vs\SqlDependency_Test\
?????目錄???????????0??2018-07-30?12:55??.vs\SqlDependency_Test\v15\
?????文件???????47616??2018-07-30?13:10??.vs\SqlDependency_Test\v15\.suo
?????目錄???????????0??2018-07-30?12:54??.vs\SqlDependency_Test\v15\Server\
?????目錄???????????0??2018-07-30?12:54??.vs\SqlDependency_Test\v15\Server\sqlite3\
?????文件???????????0??2018-07-30?12:54??.vs\SqlDependency_Test\v15\Server\sqlite3\db.lock
?????文件????????4096??2018-07-30?12:54??.vs\SqlDependency_Test\v15\Server\sqlite3\storage.ide
?????文件???????32768??2018-07-30?13:01??.vs\SqlDependency_Test\v15\Server\sqlite3\storage.ide-shm
?????文件??????671592??2018-07-30?12:54??.vs\SqlDependency_Test\v15\Server\sqlite3\storage.ide-wal
?????文件?????????315??2018-01-04?16:34??README.md
?????文件?????3260416??2018-01-04?16:34??SqlDependency.bak
?????文件????????2769??2018-01-04?16:34??SqlDependency[DB].sql
?????文件????????1788??2018-01-04?16:34??SqlDependency[Table].sql
?????目錄???????????0??2018-07-30?12:53??SqlDependency_Test\
?????文件?????????358??2018-07-30?12:53??SqlDependency_Test\App.config
?????文件????????9388??2018-01-04?16:34??SqlDependency_Test\Form1.Designer.cs
?????文件????????3040??2018-01-04?16:34??SqlDependency_Test\Form1.cs
?????文件??????554929??2018-01-04?16:34??SqlDependency_Test\Form1.resx
?????文件?????????499??2018-01-04?16:34??SqlDependency_Test\Program.cs
?????目錄???????????0??2018-07-30?12:49??SqlDependency_Test\Properties\
?????文件????????1338??2018-01-04?16:34??SqlDependency_Test\Properties\AssemblyInfo.cs
?????文件????????2772??2018-01-04?16:34??SqlDependency_Test\Properties\Resources.Designer.cs
?????文件????????5496??2018-01-04?16:34??SqlDependency_Test\Properties\Resources.resx
?????文件????????1051??2018-01-04?16:34??SqlDependency_Test\Properties\Settings.Designer.cs
?????文件?????????242??2018-01-04?16:34??SqlDependency_Test\Properties\Settings.settings
?????文件????????3778??2018-01-04?16:34??SqlDependency_Test\SqlDependency_Test.csproj
?????目錄???????????0??2018-07-30?12:51??SqlDependency_Test\bin\
?????目錄???????????0??2018-07-30?12:55??SqlDependency_Test\bin\Debug\
............此處省略19個(gè)文件信息

評論

共有 條評論

相關(guān)資源