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> |