刚学习用存储过程,以下问题请教~~~
我调用一个存储过程做一个datagrid的datasource,但是为什么会是空的呢?
我在数据库里调试的时候会有一张表出来的。
请各位大大指导下,谢~~~我建一个存储过程如下:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[Test]
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
/* SET NOCOUNT ON */
select top 100 * from table1 order by ConCd====================================================
我在页面调用存储过程:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim conn As String = Web.Configuration.WebConfigurationManager.ConnectionStrings("cn").ConnectionString
Dim cn As SqlConnection = New SqlConnection(conn)
Dim com As SqlCommand = New SqlCommand("Test", cn)
com.CommandType = CommandType.StoredProcedure
Dim da As New SqlDataAdapter(com)
Dim ds As New DataSet
da.Fill(ds)
Me.DataGrid1.DataSource = ds
End Sub运行,显示的是一个空白页面。
我调用一个存储过程做一个datagrid的datasource,但是为什么会是空的呢?
我在数据库里调试的时候会有一张表出来的。
请各位大大指导下,谢~~~我建一个存储过程如下:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[Test]
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
/* SET NOCOUNT ON */
select top 100 * from table1 order by ConCd====================================================
我在页面调用存储过程:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim conn As String = Web.Configuration.WebConfigurationManager.ConnectionStrings("cn").ConnectionString
Dim cn As SqlConnection = New SqlConnection(conn)
Dim com As SqlCommand = New SqlCommand("Test", cn)
com.CommandType = CommandType.StoredProcedure
Dim da As New SqlDataAdapter(com)
Dim ds As New DataSet
da.Fill(ds)
Me.DataGrid1.DataSource = ds
End Sub运行,显示的是一个空白页面。
是不是少了DataGrid1.DataBind();