这是后码代码:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
Dim sqlConn As New SqlClient.SqlConnection()
Dim sqlSelectStr As String = "select top 5 id,zw_name,zw_date from human"
sqlConn.ConnectionString = "Server=你的服务器;Database=数据库;uid=用户;pwd=密码"
sqlConn.Open() ''打开数据库连接
'--------------------------------------------
Dim sqlDA As New SqlClient.SqlDataAdapter(sqlSelectStr, sqlConn)
''-----------------------------------------------
Dim produceDS As New DataSet()
sqlDA.Fill(produceDS, "human")
dl1.DataSource = produceDS.Tables("human").DefaultView
dl1.DataBind()
sqlConn.Close()
'---------------------------------------------------
End Sub