读书人

新手上路恳请帮忙!ConnectionStrin

发布时间: 2012-01-09 21:05:42 作者: rapoo

新手上路,恳请帮忙!ConnectionString 属性尚未初始化
从另外一个项目转移的代码,只是修改了数据库名及表名,出现错误:
“/text”应用程序中的服务器错误。
--------------------------------------------

ConnectionString 属性尚未初始化。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.InvalidOperationException: ConnectionString 属性尚未初始化。

代码如下:
Imports System.Data.SqlClient
Imports Microsoft.Web.UI.WebControls
Public Class bumen
Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

End Sub
Protected WithEvents TreeView1 As Microsoft.Web.UI.WebControls.TreeView
Protected WithEvents FONT1 As System.Web.UI.HtmlControls.HtmlGenericControl
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Protected WithEvents Button2 As System.Web.UI.WebControls.Button

'注意: 以下占位符声明是 Web 窗体设计器所必需的。
'不要删除或移动它。
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
If Not IsPostBack Then
Dim conn As New SqlConnection
Dim cmd As New SqlCommand

' TreeView1.Attributes.Add( "onclick ", "tree_onclick() ; ")
conn.ConnectionString = ConfigurationSettings.AppSettings( "DBConnstr ")


cmd.Connection = conn
cmd.CommandType = CommandType.Text
cmd.CommandText = "select * from bumen where sjbmbh=0 "
conn.Open()
Dim dataread As SqlDataReader
dataread = cmd.ExecuteReader()
While (dataread.Read)
Dim bubh As String = dataread( "bmbh ")
Dim rootnode As New TreeNode


rootnode.ImageUrl = "images/folder.gif "
rootnode.SelectedImageUrl = "images/folder.gif "
rootnode.ExpandedImageUrl = "images/folderopen.gif "
rootnode.NavigateUrl = "bumenread.aspx?bmdm= " & dataread( "bmbh ")
rootnode.Target = "display "
rootnode.NodeData = bubh
rootnode.Text = " <span style= 'cursor:hand ' id= ' " & bubh & " ' oncontextmenu= " & " " " " & "ShowPopupMenu( ' " & dataread( "bmqcbh ") & " ') " & " " " " & " > " & dataread( "bumenname ") & " </span> "
' rootnode.ID = rootnode.Text
TreeView1.Nodes.Add(rootnode)
AddChildNode(rootnode, bubh)
End While


End If
Response.Write( "请登录! ")
End Sub
Private Sub AddChildNode(ByRef parentnode As TreeNode, ByVal parentid As Integer)
Dim conn As New SqlConnection
Dim cmd As New SqlCommand
conn.ConnectionString = ConfigurationSettings.AppSettings( "DBConnstr ")
cmd.CommandType = CommandType.Text
cmd.CommandText = "select * from bumen where sjbmbh= " & parentid
cmd.Connection = conn
conn.Open()
Dim dataread As SqlDataReader
dataread = cmd.ExecuteReader()
While dataread.Read
Dim bubh As String = dataread( "bmbh ")
Dim childnode As New TreeNode

childnode.ImageUrl = "images/folder.gif "
childnode.SelectedImageUrl = "images/folder.gif "
childnode.ExpandedImageUrl = "images/folderopen.gif "
childnode.NavigateUrl = "bumenread.aspx?bmdm= " & dataread( "bmbh ")
childnode.Target = "display "
childnode.NodeData = bubh
' childnode.Text = " <span style= 'cursor:hand ' id= ' " & bubh & " ' oncontextmenu= " & " " " " & "ShowPopupMenu( ' " & dataread( "bmqcbh ") & " ') " & " " " " & "onclick= " & " " " " & "SetNode( ' " & bubh & " ') " & " " " " & " > " & dataread( "bmmc ") & " </span> "


childnode.Text = " <span style= 'cursor:hand ' id= ' " & bubh & " ' oncontextmenu= " & " " " " & "ShowPopupMenu( ' " & dataread( "bmqcbh ") & " ') " & " " " " & " > " & dataread( "bmmc ") & " </span> "

parentnode.Nodes.Add(childnode)
AddChildNode(childnode, bubh)
End While

End Sub

Private Sub TreeView1_SelectedIndexChange(ByVal sender As System.Object, ByVal e As Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs)
Response.Write( " <script> alert( 'OK '); </script> ")
End Sub
End Class


[解决办法]
ConfigurationSettings.AppSettings( "DBConnstr ")

这个地方没有获取到值
[解决办法]
察看 Web.config文件看DBConnstr是否写的正确
[解决办法]
webconfig中看看你的数据库连接是正确的吗?

读书人网 >asp.net

热点推荐