请教:我在页面上做 dropdownlist数据绑定测试时的代码
Imports System.Data.SqlClient
Public Class WebForm1
Inherits System.Web.UI.Page
Dim constr As String = "Data Source=localhost;initial catalog=学生成绩管理系统;integrated security=sspi"
Dim mycon As New SqlConnection(constr)
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim mycom As New SqlCommand("select banjimingcheng from 班级", mycon)
Dim myread As SqlDataReader
mycon.Open()
myread = mycom.ExecuteReader
While myread.Read
DropDownList1.Items.Add(myread(0))
End While
mycon.Close()
'在此处放置初始化页的用户代码
End Sub
End Class
提示错误是异常详细信息: System.Data.SqlClient.SqlException: SQL Server 不存在或访问被拒绝。
源错误:
行 30: Dim mycom As New SqlCommand("select banjimingcheng from 班级", mycon)
行 31: Dim myread As SqlDataReader
行 32: mycon.Open()
行 33: myread = mycom.ExecuteReader
行 34: While myread.Read
源文件: c:\inetpub\wwwroot\WebApplication5\WebForm1.aspx.vb 行: 32
我试着改了下Dim constr As String = "Data Source=CHINESE-4811B4B;initial catalog=学生成绩管理系统;uid=sa;pwd=sa
提示变为“System.Data.SqlClient.SqlException: 用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。”
不太懂原因。小弟还是个初学者 ,希望大家帮忙分析解决一下,感谢!