📄 readme.htm
字号:
<html><body><title>Stored Procedure Sample</title><h1>Stored Procedure Sample</h1><div id="mainSection"><div id="mainBody"><div id="allHistory" class="saveHistory" onsave="saveAll()" onload="loadAll()"></div><h1 class="heading" >Sample Files:</h1><div id="codeSampleToggle" class="section" name="collapseableSection" ><div id="syntaxCodeBlocks" class="code"><span codeLanguage="VisualBasic"><table border="0" cellpadding="0" cellspacing="0" width="99%"><tr><td colspan="4" height="7"></td></tr></table></span></div></div><font color="DarkGray">[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]</font><p /><p>This application demonstrates how to programmatically create and use stored procedures with ADO.NET and Microsoft SQL Server. </p><h1 class="heading">To run this sample</h1><div id="procedureSection0" class="section"><ol><li><content ><p xmlns="">Click the <b>Download Sample</b> button on this page. In the <b>File Download</b> dialog box, click <b>Open</b>.</p></content></li><li><content ><p xmlns="">Save the files to your computer.</p></content></li><li><content ><p xmlns="">On the <b>File</b> menu in Visual Studio, point to <b>Open</b>, and then click <b>Project/Solution</b>.</p></content></li><li><content ><p xmlns="">Browse to the folder where you saved the files and select the solution file. This opens the solution in Visual Studio.</p></content></li><li><content ><p xmlns="">Press F5.</p></content></li></ol></div><h1 class="heading">Requirements</h1><div id="requirementsSection" class="section"><content ><p xmlns="">This sample requires the Northwind sample database. For more information, see <a href="8b3cee2b-1bd8-4917-91ca-e90a6c557794.htm">Installing Database Components for Samples</a>.</p></content></div><h1 class="heading">Demonstrates</h1><div id="demonstratesSection" class="section"><content ><p xmlns="">The following tasks are demonstrated: </p><ul xmlns=""><li>
Create a new database using SQL commands. A table is added by copying data from the sample database.<br></br></li><li>
Create a stored procedure programmatically in the the database by executing SQL statements. This task uses classes in the <MSHelp:link keywords="N:System.Data.SqlClient" TABINDEX="0" >System.Data.SqlClient</MSHelp:link> namespace.<br></br></li><li>
Execute a stored procedure that does not require any parameters, using a <MSHelp:link keywords="T:System.Data.SqlClient.SqlDataReader" TABINDEX="0" >SqlDataReader</MSHelp:link> object. <br></br></li><li>
Execute a stored procedure that requires an input parameter and fill a <MSHelp:link keywords="T:System.Windows.Forms.DataGrid" TABINDEX="0" >DataGrid</MSHelp:link> with the results. <br></br></li><li>
Execute a stored procedure that requires both input and output parameters, and that makes use of a return value. <br></br></li></ul></content></div><tool:tip element="languageFilterToolTip" avoidmouse="false"/>
</div><div id="footer">
Send <a href="mailto:DevDocs@microsoft.com?subject=Documentation Feedback (Beta 2):Stored Procedure Sample">comments</a> about this topic to Microsoft. © Microsoft Corporation. All rights reserved.
</div></div></body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -