在与 SQL Server 建立连接时出现与网络相关的或特定于实例的异常 error 26
在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误 error 26
我想用asp.net做一个修改密码的界面,但是出现上述问题
这是配置文件 <add name="kailuanConnectionString" connectionString="data source=WIN-74QO3B8KQU8;initial catalog= kailuan;uid=sa;pwd=Cumtb4404404400;integrated security=sspi;" providerName="System.Data.SqlClient" />
请问我需要改一改哪里?
------解决思路----------------------
http://www.xuebuyuan.com/35535.html
我想用asp.net做一个修改密码的界面,但是出现上述问题
Protected Sub ChangePasswordPushButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)这是代码
Dim pw As String, pnw1 As String, pnw2 As String, sql As String
pw = ChangePassword1.CurrentPassword.Replace("'", "''")
pnw1 = ChangePassword1.NewPassword.Replace("'", "''")
pnw2 = ChangePassword1.ConfirmNewPassword.Replace("'", "''")
sql = ("update 用户 set 密码='" & pnw1 & "' where 用户='") + Session("用户名") & "'"
If pw = Session("密码").ToString() AndAlso pnw1 <> pnw2 Then
Me.Response.Write("<script>alert('原密码输入错误或者两次输入的新密码不一致!');</script>")
Return
else
Dim connstring As String = ConfigurationManager.ConnectionStrings("kailuanConnectionString").ConnectionString
Dim con As New SqlConnection(connstring)
con.Open()
Dim cm As New SqlCommand(sql, con)
Try
Dim resultrow As Integer = cm.ExecuteNonQuery()
'返回数据库被影响的行
con.Close()
If (resultrow > 0) Then
Me.Response.Write("<script>alert('操作已成功!');</script>")
Else
Me.Response.Write("<script>alert('操作已失败!');</script>")
End If
Catch
con.Close()
End Try
End If
End Sub
这是配置文件 <add name="kailuanConnectionString" connectionString="data source=WIN-74QO3B8KQU8;initial catalog= kailuan;uid=sa;pwd=Cumtb4404404400;integrated security=sspi;" providerName="System.Data.SqlClient" />
请问我需要改一改哪里?
------解决思路----------------------
http://www.xuebuyuan.com/35535.html