資源簡介
本項目屬于winform實例,其中使用了SQLServer數據庫,實現了基本的增刪改查功能

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?System.Data.SqlClient;
namespace?Exam
{
????class?DBHelper
????{
????????static?string?strconn?=?string.Format(“server=.;uid=sa;pwd=123456;database=TestDB“);
????????public?static?int?ExecuteNonQuery(string?sql)
????????{
????????????using?(SqlConnection?conn?=?new?SqlConnection(strconn))
????????????{
????????????????conn.Open();
????????????????SqlCommand?cmd?=?new?SqlCommand(sqlconn);
????????????????return?cmd.ExecuteNonQuery();
????????????}
????????}
????????public?static?DataTable?GetTable(string?sql)
????????{
????????????SqlConnection?conn?=?new?SqlConnection(strconn);
????????????DataTable?dt?=?new?DataTable();
????????????SqlDataAdapter?sda?=?new?SqlDataAdapter(sqlconn);
????????????sda.Fill(dt);
????????????return?dt;
????????}
????????public?static?object?ExecuteScalar(string?sql)
????????{
????????????using?(SqlConnection?conn?=?new?SqlConnection(strconn))
????????????{
????????????????conn.Open();
????????????????SqlCommand?cmd?=?new?SqlCommand(sqlconn);
????????????????return?cmd.ExecuteScalar();
????????????}
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????187??2017-05-11?08:05??Winform增刪改查小項目帶數據庫\Exam\App.config
?????文件??????54784??2018-12-14?09:56??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\Exam.exe
?????文件????????187??2017-05-11?08:05??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\Exam.exe.config
?????文件?????110080??2018-12-14?09:56??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\Exam.pdb
?????文件??????22984??2018-12-14?15:07??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\Exam.vshost.exe
?????文件????????187??2017-05-11?08:05??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\Exam.vshost.exe.config
?????文件????????490??2018-04-12?07:35??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\Exam.vshost.exe.manifest
?????文件???????6393??2016-08-25?12:25??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\image\c.png
?????文件???????5586??2017-05-10?09:23??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\image\exit.png
?????文件???????5055??2017-05-10?09:21??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\image\goods.png
?????文件???????7205??2016-08-25?12:25??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\image\o.png
?????文件???????3474??2017-05-10?09:24??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\image\type.png
?????文件???????9436??2017-05-10?09:20??Winform增刪改查小項目帶數據庫\Exam\bin\Debug\image\updata.png
?????文件???????1249??2017-05-14?22:48??Winform增刪改查小項目帶數據庫\Exam\DBHelper.cs
?????文件???????5780??2017-05-14?16:24??Winform增刪改查小項目帶數據庫\Exam\Exam.csproj
?????文件???????5251??2018-12-14?09:55??Winform增刪改查小項目帶數據庫\Exam\GoodsForm.cs
?????文件???????8514??2017-05-14?19:32??Winform增刪改查小項目帶數據庫\Exam\GoodsForm.Designer.cs
?????文件??????33601??2017-05-14?19:32??Winform增刪改查小項目帶數據庫\Exam\GoodsForm.resx
?????文件???????1578??2017-06-03?20:28??Winform增刪改查小項目帶數據庫\Exam\LoginForm.cs
?????文件???????7021??2017-06-03?20:28??Winform增刪改查小項目帶數據庫\Exam\LoginForm.Designer.cs
?????文件???????5817??2017-06-03?20:28??Winform增刪改查小項目帶數據庫\Exam\LoginForm.resx
?????文件???????2299??2017-05-12?08:39??Winform增刪改查小項目帶數據庫\Exam\MainForm.cs
?????文件???????3423??2017-05-11?10:03??Winform增刪改查小項目帶數據庫\Exam\MainForm.Designer.cs
?????文件???????6015??2017-05-11?10:03??Winform增刪改查小項目帶數據庫\Exam\MainForm.resx
?????文件?????????42??2017-06-03?20:27??Winform增刪改查小項目帶數據庫\Exam\obj\Debug\CoreCompileInputs.cache
?????文件???????1592??2018-12-14?15:07??Winform增刪改查小項目帶數據庫\Exam\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????6947??2018-12-14?09:38??Winform增刪改查小項目帶數據庫\Exam\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????5866??2018-12-14?15:07??Winform增刪改查小項目帶數據庫\Exam\obj\Debug\Exam.csproj.FileListAbsolute.txt
?????文件???????1349??2017-12-27?22:09??Winform增刪改查小項目帶數據庫\Exam\obj\Debug\Exam.csproj.GenerateResource.Cache
?????文件???????3785??2017-05-11?23:21??Winform增刪改查小項目帶數據庫\Exam\obj\Debug\Exam.csprojResolveAssemblyReference.cache
............此處省略46個文件信息
評論
共有 條評論