資源簡介
C#連接SQL Server 2008數據庫,執行存儲過程的實例,用到了:devcomponents 是破解版
請先還原數據,還原文件在DataBase文件夾中。
數據庫版本:SQL Server 2008 r2
VS版本:VS 2013
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?StoreTest
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
????????}
????????private?void?btn_StoreInvoke_Click(object?sender?EventArgs?e)
????????{
????????????string?conn?=?“server=.;database=TESTSD;uid=sa;pwd=j6394126“;
????????????SqlConnection?SqlConnection?=?new?SqlConnection(conn);
????????????SqlCommand?cmd?=?new?SqlCommand();
????????????cmd.Connection?=?SqlConnection;//設定sql連接
????????????cmd.CommandText?=?“getAllData“;//設置調用存儲過程的名字
????????????cmd.CommandType?=?Comman
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-02-15?13:54??C#存儲過程簡單實例\
?????目錄???????????0??2017-02-15?13:54??C#存儲過程簡單實例\Databa
?????文件?????1593856??2013-06-13?15:38??C#存儲過程簡單實例\Databa
?????目錄???????????0??2017-02-26?12:00??C#存儲過程簡單實例\StoreTest\
?????目錄???????????0??2017-02-15?13:54??C#存儲過程簡單實例\StoreTest\.vs\
?????目錄???????????0??2017-02-15?13:54??C#存儲過程簡單實例\StoreTest\.vs\StoreTest\
?????目錄???????????0??2017-02-15?13:54??C#存儲過程簡單實例\StoreTest\.vs\StoreTest\v14\
?????文件???????43520??2017-02-14?16:35??C#存儲過程簡單實例\StoreTest\.vs\StoreTest\v14\.suo
?????目錄???????????0??2017-02-15?13:54??C#存儲過程簡單實例\StoreTest\StoreTest\
?????文件?????????869??2017-02-26?11:59??C#存儲過程簡單實例\StoreTest\StoreTest.sln
?????文件???????22016??2013-06-13?15:38??C#存儲過程簡單實例\StoreTest\StoreTest.suo
?????文件???????50176??2017-02-26?12:08??C#存儲過程簡單實例\StoreTest\StoreTest.v12.suo
?????目錄???????????0??2017-02-15?13:54??C#存儲過程簡單實例\StoreTest\StoreTest\bin\
?????目錄???????????0??2017-02-26?12:03??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\
?????文件??????442368??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.DotNetBar.Design.dll
?????文件???????69120??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.DotNetBar.Keyboard.dll
?????文件???????53248??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.DotNetBar.Layout.Design.dll
?????文件??????245760??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.DotNetBar.Layout.dll
?????文件??????557056??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.DotNetBar.Schedule.dll
?????文件?????1286144??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.DotNetBar.SuperGrid.dll
?????文件?????5201920??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.DotNetBar2.dll
?????文件??????192512??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.Instrumentation.Design.dll
?????文件??????331776??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.Instrumentation.dll
?????文件???????45056??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.SuperGrid.Design.dll
?????文件??????434176??2015-02-03?22:12??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\DevComponents.TreeGX.dll
?????文件???????15872??2017-02-26?12:04??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\StoreTest.exe
?????文件???????32256??2017-02-26?12:04??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\StoreTest.pdb
?????文件???????23168??2017-02-26?12:01??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\StoreTest.vshost.exe
?????文件?????????490??2012-06-02?22:34??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\StoreTest.vshost.exe.manifest
?????文件????????5909??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\Form1.cs
?????文件???????19151??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\Form1.Designer.cs
............此處省略25個文件信息
- 上一篇:將excel文件上傳至sql2005數據庫
- 下一篇:醫院管理信息系統后臺管理
評論
共有 條評論