问题:ConnectionString 属性尚未初始化!!
Imports System.Data
Imports System.Data.SqlClient
Public Class WebForm1
Inherits System.Web.UI.Page
Private Sub Button1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ServerClick
Dim StrUser As String, StrPass As String
Dim BValid As Boolean
Dim ConVM As SqlConnection
Dim CmdCoInfo As SqlCommand
Dim DrCoInfo As Sqldatareader
Dim StrSQL As String
StrUser = Txtname.Text
StrPass = Txtpassword.Text
BValid = False
ConVM = New Sqlconnection("Server=KITTY;UID=sa;PWD=;Database=study")
StrSQL = "SELECT * FROM student WHERE id='" & StrUser & "'"
CmdCoInfo = New SqlCommand(StrSQL, ConVM)
ConVM.Open()
DrCoInfo = CmdCoInfo.ExecuteReader()
While DrCoInfo.Read()
If DrCoInfo("UserName") <> "" And DrCoInfo("Password") <> "" Then
Response.Cookies("ValidUser").Value = DrCoInfo("UserName")
Response.Cookies("ValidUser").Expires = DateTime.Now.AddMonths(1)
BValid = True
Else
End If
End While
ConVM.Close()
If BValid = True Then
Response.Redirect("index.aspx")
ElseIf BValid = False Then
Lb1message.Text = "Login Error: Please try again."
End If
End Sub
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
SqlConnection1.Open()
SqlDataAdapter1.Fill(DataSet11, "course")
DataGrid1.DataBind()
SqlConnection1.Close()
End Sub
报错:ConnectionString 属性尚未初始化。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.InvalidOperationException: ConnectionString 属性尚未初始化。
源错误:
行 185:
行 186:
行 187: SqlConnection1.Open()
行 188: SqlDataAdapter1.Fill(DataSet11, "course")
行 189: DataGrid1.DataBind()
源文件: c:\inetpub\wwwroot\WebApplication2\index.aspx.vb 行: 187
堆栈跟踪:
[InvalidOperationException: ConnectionString 属性尚未初始化。]
System.Data.SqlClient.SqlConnection.Open() +809
WebApplication2.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication2\index.aspx.vb:187
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724
是怎么回事?应该怎么改呢?帮忙!