主题:关于datalist连接数据库问题
大家好我是用vb编写asp.net的我想问一下datalist怎么连server数据库呀用代码
这是我不对的代码
Dim sqlcmd As New SqlCommand
Dim sqlcon As New SqlConnection
sqlcon.ConnectionString = "data source=ADMIN;database=xulong;user id=sa;pwd=sa;"
sqlcmd.Connection = sqlcon
Dim sql As String = "SELECT * FROM xl "
sqlcmd.CommandText = sql
sqlcon.Open()
Dim rdstu As SqlDataReader
rdstu = sqlcmd.ExecuteReader
DataList1.DataSource = rdstu
DataList1.DataBind()
sqlcon.Close()
运行时说DataList1.DataSource = rdstu错误为什么谢谢各位高手了,还有要是不对怎么连呀
这是我不对的代码
Dim sqlcmd As New SqlCommand
Dim sqlcon As New SqlConnection
sqlcon.ConnectionString = "data source=ADMIN;database=xulong;user id=sa;pwd=sa;"
sqlcmd.Connection = sqlcon
Dim sql As String = "SELECT * FROM xl "
sqlcmd.CommandText = sql
sqlcon.Open()
Dim rdstu As SqlDataReader
rdstu = sqlcmd.ExecuteReader
DataList1.DataSource = rdstu
DataList1.DataBind()
sqlcon.Close()
运行时说DataList1.DataSource = rdstu错误为什么谢谢各位高手了,还有要是不对怎么连呀