using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?System.Data.SqlClient;
using?System.IO;
using?System.Drawing.Drawing2D;?

namespace?HH
{
????class?ab
????{???//1?public?static?readonly?string?conString?=?ConfigurationManager.ConnectionStrings[“sqlcon“].ConnectionString;
????????//2?
????????public?static?readonly?String?conString?=?@“Data?Source=.;Initial?Catalog=E:\A組項目\動態登陸\DSAD\USER.MDF;Integrated?Security=True“;
????????//打開數據庫
????????public?static?SqlConnection?getCon（）
????????{
????????????SqlConnection?con?=?new?SqlConnection（conString）;
????????????if?（con.State?!=?ConnectionState.Open）//con.State==ConnectionState.Closed
????????????{
????????????????con.Open（）;//打開數據庫
????????????}
????????????return?con;
????????}
????????//關閉數據庫
????????public?static?void?CloseCon（SqlConnection?con）
????????{
????????????if?（con?!=?null?&&?con.State?==?ConnectionState.Open）
????????????{
????????????????con.Close（）;//關閉數據庫
????????????}
????????}
????????//查詢
????????public?static?DataTable?getTable（string?sql）
????????{
????????????//??getCon（）;//打開數據庫
????????????SqlCommand?cmd?=?new?SqlCommand（sql?getCon（））;
????????????SqlDataAdapter?apt?=?new?SqlDataAdapter（cmd）;//適配器
????????????DataTable?dt?=?new?DataTable（）;
????????????apt.Fill（dt）;//填充數據
????????????return?dt;
????????}
????????//增，刪，改
????????public?static?bool?ExecuteNonQuery（string?sql）
????????{
????????????bool?flag?=?false;
????????????using?（SqlConnection?con?=?new?SqlConnection（conString））
????????????{
????????????????if?（con.State?==?ConnectionState.Closed）
????????????????{
????????????????????con.Open（）;
????????????????}
????????????????try
????????????????{
????????????????????SqlCommand?cmd?=?new?SqlCommand（sql?con）;
????????????????????int?rust?=?cmd.ExecuteNonQuery（）;
????????????????????if?（rust?>?0）
????????????????????{
????????????????????????flag?=?true;
????????????????????}
????????????????}
????????????????catch
????????????????{
????????????????????;
????????????????}
????????????????finally
????????????????{
????????????????????CloseCon（con）;
????????????????}
????????????????return?flag;
????????????}
????????}
????}
????class?db
????{
????????public?static?SqlConnection?Camcon（）
????????{
????????????return?new?SqlConnection
????????????????（@“Data?Source=.;Initial?Catalog=E:\A組項目\動態登陸\DSAD\USER.MDF;Integrated?Security=True“）;
????????}
????}
????class?DBHelper
????{
????????private?const?string?strMyConText?=?@“Data?Source=.;Initial?Catalog=E:\A組項目\動態登陸\DSAD\USER.MDF;Integrated?Security=True“;
????????#region?保存數據
????????///?

????????///?執行查詢語句并且返回受影響的行數
????????///?

????????///?執行的查詢語句
????????///?返回受影響的行數
????????public?static?int?SaveData（string?strSQL）
????????{
????????????SqlConnection?objMyCon?=?new?Sq

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????123904??2018-01-22?13:34??HH.v11.suo
?????文件??????557056??2010-09-12?13:09??IrisSkin4.dll
?????目錄???????????0??2018-01-12?22:03??DB_51aspx\
?????文件??????????43??2017-06-19?11:33??DB_51aspx\SQLQuery1.sql
?????文件?????????206??2017-06-19?11:33??DB_51aspx\SQLQuery2.sql
?????文件?????5242880??2017-06-22?18:55??DB_51aspx\User.mdf
?????文件?????1048576??2017-06-22?18:55??DB_51aspx\User_log.ldf
?????目錄???????????0??2018-01-12?22:03??HH\
?????文件???????67646??2017-06-04?12:11??HH\111.ico
?????文件????????6864??2017-06-25?14:12??HH\ab.cs
?????文件?????????187??2017-06-02?12:25??HH\App.config
?????目錄???????????0??2018-01-12?22:03??HH\bin\
?????目錄???????????0??2018-01-22?13:31??HH\bin\Debug\
?????文件?????2170368??2018-01-22?13:31??HH\bin\Debug\HH.exe
?????文件?????????187??2017-06-02?12:25??HH\bin\Debug\HH.exe.config
?????文件??????210432??2018-01-22?13:31??HH\bin\Debug\HH.pdb
?????文件???????22984??2018-01-22?13:30??HH\bin\Debug\HH.vshost.exe
?????文件?????????187??2017-06-02?12:25??HH\bin\Debug\HH.vshost.exe.config
?????文件??????557056??2010-09-12?13:09??HH\bin\Debug\IrisSkin4.dll
?????文件??????712192??2014-12-10?13:17??HH\bin\Debug\layeredSkin.dll
?????文件?????1628800??2017-05-26?13:40??HH\bin\Debug\Microsoft.Office.Interop.Excel.dll
?????目錄???????????0??2018-01-12?22:03??HH\bin\Debug\Skins\
?????文件???????20139??2010-04-04?21:03??HH\bin\Debug\Skins\CALMNESS.SSK
?????文件???????20271??2010-04-04?21:03??HH\bin\Debug\Skins\CalmnessColor1.ssk
?????文件???????20208??2010-04-04?21:03??HH\bin\Debug\Skins\CalmnessColor2.ssk
?????文件????????5032??2010-04-04?21:03??HH\bin\Debug\Skins\DEEPCYAN.SSK
?????文件????????5037??2010-04-04?21:03??HH\bin\Debug\Skins\DeepGreen.ssk
?????文件????????4908??2010-04-04?21:03??HH\bin\Debug\Skins\DeepOrange.ssk
?????文件???????16021??2010-04-04?21:03??HH\bin\Debug\Skins\DiamondBlue.ssk
?????文件???????16669??2010-04-04?21:03??HH\bin\Debug\Skins\DiamondGreen.ssk
?????文件???????16211??2010-04-04?21:03??HH\bin\Debug\Skins\DiamondOlive.ssk
............此處省略501個文件信息