top.ascx是头部控件,里面有个label控件,显示注册的总人数,是从数据库中读取的。可是把top.ascx放到default.aspx页面中调试运行时,label未显示任何数据,visible为true,后来直接设置Label1.Text = "123",调试也没反应
代码如下:
Partial Class top
Inherits System.Web.UI.UserControl
Dim Label1 As System.Web.UI.WebControls.Label
‘Dim label2 As System.Web.UI.WebControls.Label
‘Dim Label3 As System.Web.UI.WebControls.Label
‘Dim Label4 As System.Web.UI.WebControls.Label
‘Dim label5 As System.Web.UI.WebControls.Label
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sqlstr As String = "select count(*) from CustomerInfo"
Dim constr As String = "server=’(local)’;database=’zl’;uid=’sa’;pwd=’123′"
Dim con As SqlConnection = New SqlConnection(constr)
con.Open()
Dim cmd As SqlCommand = New SqlCommand(sqlstr, con)
‘ CType(Me.FindControl("Label1"), Label).Text = cmd.ExecuteScalar.ToString
Label1.Text = cmd.ExecuteScalar().ToString() ”以对象的形式返回查询结果的第一行第一列
‘label1.Text = "123"
con.Close()
