对datalist进行数据绑定的代码如下,但是运行后为何页面无法显示datalist内容呢,求教。
以下为代码:
Dim dsn As String = System.Configuration.ConfigurationManager.AppSettings("DSN_oa")
Dim conn As New System.Data.SqlClient.SqlConnection
conn.ConnectionString = dsn
Dim cmd As New System.Data.SqlClient.SqlCommand
cmd.Connection = conn
Dim ds As New System.Data.DataSet
Dim dap As New System.Data.SqlClient.SqlDataAdapter
cmd.CommandText = "select top 10 * from oa_infor order by oa_date desc"
dap.SelectCommand = cmd
Try
conn.Open()
dap.Fill(ds, "notice")
DataList.DataSource = ds.Tables("notice")
DataList.DataBind()
Catch ex As Exception
Finally
conn.Close()
End Try
以下为代码:
Dim dsn As String = System.Configuration.ConfigurationManager.AppSettings("DSN_oa")
Dim conn As New System.Data.SqlClient.SqlConnection
conn.ConnectionString = dsn
Dim cmd As New System.Data.SqlClient.SqlCommand
cmd.Connection = conn
Dim ds As New System.Data.DataSet
Dim dap As New System.Data.SqlClient.SqlDataAdapter
cmd.CommandText = "select top 10 * from oa_infor order by oa_date desc"
dap.SelectCommand = cmd
Try
conn.Open()
dap.Fill(ds, "notice")
DataList.DataSource = ds.Tables("notice")
DataList.DataBind()
Catch ex As Exception
Finally
conn.Close()
End Try
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货