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;//設(shè)定sql連接
????????????cmd.CommandText?=?“getAllData“;//設(shè)置調(diào)用存儲過程的名字
????????????cmd.CommandType?=?CommandType.StoredProcedure;//指定執(zhí)行語句為存儲過程
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（cmd）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds）;//填充dataset
????????????this.dgv_StoreView.DataSource?=?ds.Tables[0];
????????????//dgv_StoreView.DataBind（）;?這個是asp.net才需要添加這句，winform設(shè)置數(shù)據(jù)源后就行了，不用再進行綁定
????????}

????????private?void?btn_StoreNoInOutParam_Click（object?sender?EventArgs?e）
????????{
????????????string?conn?=?“server=.;database=TESTSD;uid=sa;pwd=j6394126“;
????????????SqlConnection?SqlConn?=?new?SqlConnection（conn）;
????????????SqlCommand?cmd?=?new?SqlCommand（）;
????????????cmd.Connection?=?SqlConn;
????????????cmd.CommandText?=?“InsertInfo“;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
????????????SqlConn.Open（）;
????????????this.txt_StoreNoInOut.Text?=?“執(zhí)行存儲過程影響了：“+cmd.ExecuteNonQuery（）.ToString（）+“行“;
????????????SqlConn.Close（）;

????????}

????????private?void?btn_Test3_Click（object?sender?EventArgs?e）
????????{
????????????string?conn?=?“server=.;database=TESTSD;uid=sa;pwd=j6394126“;
????????????SqlConnection?SqlConn?=?new?SqlConnection（conn）;
????????????SqlCommand?cmd?=?new?SqlCommand（）;
????????????cmd.Connection?=?SqlConn;
????????????cmd.CommandText?=?“InOutTest“;
????????????cmd.CommandType?=?CommandType.StoredProcedure;//設(shè)置使用存儲過程

????????????cmd.Parameters.Add（“@studentId“?SqlDbType.VarChar）;//設(shè)置默認的輸入?yún)?shù)值
????????????cmd.Parameters.Add（“@studentName“?SqlDbType.VarChar?50）;//設(shè)置默認的輸出參數(shù)，否則默認的Size為0
????????????cmd.Parameters.Add（“@studentClass“?SqlDbType.VarChar?50）;//設(shè)置默認的輸出參數(shù)，否則默認的Size為0
????????????cmd.Parameters.Add（“@studentScores“?SqlDbType.Int）;//設(shè)置默認的輸出參數(shù)，否則默認的Size為0
????????????cmd.Parameters.Add（“@rowCount“?SqlDbType.Int）;//設(shè)置默認的輸出參數(shù)，否則默認的Size為0

????????????cmd.Parameters[“@studentId“].Value?=?2;//為默認參數(shù)賦值
????????????cmd.Parameters[“@studentName“].Direction?=?ParameterDirection.Output;//設(shè)置參數(shù)為輸出參數(shù)，否則默認情況為輸入?yún)?shù)
????????????cmd.Parameters[“@studentClass“].Direction?=?ParameterDirection.Output;//設(shè)置參數(shù)為輸出參數(shù)，否則默認情況為輸入?yún)?shù)
????????????cmd.Parameters[“@studentScores“].Direction?=?ParameterDirection.Output;//設(shè)置參數(shù)為輸出參數(shù)，否則默認情況為輸入?yún)?shù)
????????????cmd.Parameters[“@rowCount“].Di

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????1593856??2013-06-13?15:38??C#存儲過程簡單實例\Database\TESTSD

?????文件??????15360??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\StoreTest.exe

?????文件??????26112??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\StoreTest.pdb

?????文件??????11600??2013-06-13?15:37??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug\StoreTest.vshost.exe

?????文件????????490??2009-08-31?00:40??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

?????文件???????5817??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\Form1.resx

?????文件???????2152??2013-06-13?10:53??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6302??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????252??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\GenerateResource.read.1.tlog

?????文件????????610??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\GenerateResource.write.1.tlog

?????文件????????718??2013-06-13?15:37??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\StoreTest.csproj.FileListAbsolute.txt

?????文件??????15360??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\StoreTest.exe

?????文件????????180??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\StoreTest.Form1.resources

?????文件??????26112??2013-06-13?15:36??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\StoreTest.pdb

?????文件????????180??2013-06-13?11:20??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\StoreTest.Properties.Resources.resources

?????文件????????490??2013-06-13?10:53??C#存儲過程簡單實例\StoreTest\StoreTest\Program.cs

?????文件???????1410??2013-06-13?10:52??C#存儲過程簡單實例\StoreTest\StoreTest\Properties\AssemblyInfo.cs

?????文件???????2868??2013-06-13?10:53??C#存儲過程簡單實例\StoreTest\StoreTest\Properties\Resources.Designer.cs

?????文件???????5612??2013-06-13?10:52??C#存儲過程簡單實例\StoreTest\StoreTest\Properties\Resources.resx

?????文件???????1094??2013-06-13?10:53??C#存儲過程簡單實例\StoreTest\StoreTest\Properties\Settings.Designer.cs

?????文件????????249??2013-06-13?10:52??C#存儲過程簡單實例\StoreTest\StoreTest\Properties\Settings.settings

?????文件???????3827??2013-06-13?10:58??C#存儲過程簡單實例\StoreTest\StoreTest\StoreTest.csproj

?????文件????????869??2013-06-13?10:53??C#存儲過程簡單實例\StoreTest\StoreTest.sln

????..A..H.?????22016??2013-06-13?15:38??C#存儲過程簡單實例\StoreTest\StoreTest.suo

?????文件?????????97??2013-06-13?15:41??C#存儲過程簡單實例\使用說明.txt

?????目錄??????????0??2013-06-13?15:39??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug\TempPE

?????目錄??????????0??2013-06-13?15:39??C#存儲過程簡單實例\StoreTest\StoreTest\obj\x86\Debug

?????目錄??????????0??2013-06-13?15:39??C#存儲過程簡單實例\StoreTest\StoreTest\bin\Debug

............此處省略11個文件信息