ASP.NET GridView Page + SqlDataSource + 執行 SQL Procedure

 

   test.aspx.vb
 
   Imports System.Data.SqlClient
 
   Partial Public Class test
      Inherits System.Web.UI.Page
 
      Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
         Dim csBuilder As New SqlConnectionStringBuilder()
         csBuilder.DataSource = "."
         csBuilder.InitialCatalog = "Sales"
         csBuilder.IntegratedSecurity = True
 
         Dim A As New StringBuilder
         A.Append("EXEC ChkSales")
 
         SqlDataSource1.ConnectionString = csBuilder.ConnectionString
         SqlDataSource1.SelectCommand = A.ToString
 
         GridView1.DataSourceID = SqlDataSource1.ID
         GridView1.DataBind()
 
         SqlDataSource1.Dispose()
      End Sub
   End Class
 

 

   test.aspx
 
   <form id="form1" runat="server">
   <div>
      <asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
      <asp:GridView ID="GridView1" runat="server" />
   </div>
   </form>