codebehind error: With block variable not set.

boomefalo · Apr 28, 2012

i moved to codebehind and i am currently getting this error when i invoke my button(s). the string is coming null from my web.config. web.config ---------- <configuration> <appSettings> <add key="sConnection" value=http://aspmessageboard.com/archive/index.php/"data source=;initial catalog=;password=;persist security info=True;user id=;packet size=4096" /> </appSettings> <system.web> the rest of the web.config..bla bla bla the codebehind line failing --------------------------- Public Sub btnLogin_click(ByVal src As System.Object, ByVal e As System.EventArgs) ----------> Dim sConnString = ConfigurationSettings.appSettings("sConnection") Dim sConn As New SqlConnection(sConnString) the error is ------------ System.NullReferenceException: Object variable or With block variable not set ..basically sConnection is being returned as null and i cant figure out why. any ideas?Dim ConfigurationSettings which basically takes that string and makes it null string again. only reason is i get a not declared when i try and build.did you import the System.Web.Configuration Namespace???Imports System.Data.SqlClient Imports System.Web.Mail Imports System.Web.Security Imports System.Web.Configuration Imports System.Text Imports System.Data Public Class login Inherits System.Web.UI.Page Dim sError, sEmpID, sWelcome, empID, ssnum, ConfigurationSettings Public Sub btnLogin_click(ByVal src As System.Object, ByVal e As System.EventArgs) Dim sConnString = ConfigurationSettings.appSettings("sConnection") Dim sConn As New SqlConnection(sConnString) dies on that line. if i take out the ConfigurationSettings in the above dim i get build errors, do i need to change the sConnString & sConn?do not Dim ConfigurationSettings! just do: Dim sConnString As String = ConfigurationSettings.appSettings("sConnection") Also, you should strongly type your variables; you are declaring all of your global varaibles as objects. Try something like: Public Class login Inherits System.Web.UI.Page private sError As String private sEmpID As String private sWelcome As String private empID As Integer private ssnum As String Imports System.Text Imports System.Web.Mail Imports System.Web.Security Imports System.Web.Configuration Imports System.Data Imports System.Data.SqlClient Public Class login Inherits System.Web.UI.Page Private sError As Object Private sEmpID As Object Private sWelcome As Object Private empID As Object Private ssnum As Object Private ConfigurationSettings As Object Public Sub btnLogin_click(ByVal src As System.Object, ByVal e As System.EventArgs) Dim sConnString As String = ConfigurationSettings.appSettings("sConnection") that produces the same error. should i do public? this is freakin pissing me off. thanks for the help so far

Is there a reason you are declaring ConfigurationSettings? I am guessing you are trying to get a value from your web config...so all you should have to do is have that Dim sConnString As String = ConfigurationSettings.appSettings("sConnection") line in your code. You should not need to declare ConfigurationSettings. I had a working example and once I added that Private ConfigurationSettings As Object line in my code, I got the same exact error you did. Hope that helps. Timthe only reason i am doing that is everytime i try and build i get the error saying that is not declared.your right, i am trying to get the connection string out of web.config. even if i do not declare ConfigurationSettings ...i still get the same error. Imports System.Text Imports System.Web.Mail Imports System.Web.Security Imports System.Web.Configuration Imports System.Data Imports System.Data.SqlClient Public Class login Inherits System.Web.UI.Page Private sError As Object Private sEmpID As Object Private sWelcome As Object Private empID As Object Private ssnum As Object Public Sub btnLogin_click(ByVal src As System.Object, ByVal e As System.EventArgs) Dim sConnString As String = ConfigurationSettings.appSettings("sConnection")Imports System.Text Imports System.Web.Mail Imports System.Web.Security Imports System.Web.Configuration Imports System.Data Imports System.Data.SqlClient Public Class login Inherits System.Web.UI.Page Protected WithEvents sError As System.Web.UI.WebControls.Label Protected WithEvents sEmpID As System.Web.UI.WebControls.Label Protected WithEvents sWelcome As System.Web.UI.WebControls.Label Protected WithEvents empID As System.Web.UI.WebControls.TextBox Protected WithEvents ssnum As System.Web.UI.WebControls.TextBox Protected WithEvents valSum As System.Web.UI.WebControls.ValidationSummary Protected WithEvents empIDRegexVal As System.Web.UI.WebControls.RegularExpressionValidat or Protected WithEvents ssnumReqVal As System.Web.UI.WebControls.RequiredFieldValidator Protected WithEvents passwdRegexBal As System.Web.UI.WebControls.RegularExpressionValidat or Protected WithEvents ssnum2 As System.Web.UI.WebControls.TextBox Protected WithEvents ssnum2ReqVal As System.Web.UI.WebControls.RequiredFieldValidator Protected WithEvents CompareValidator1 As System.Web.UI.WebControls.CompareValidator Protected WithEvents btnLogin As System.Web.UI.WebControls.Button Protected WithEvents btnID As System.Web.UI.WebControls.Button 'those above are events that i have in the page..disregard. Public Sub btnLogin_click(ByVal src As System.Object, ByVal e As System.EventArgs) Dim sConnString As String = ConfigurationSettings.appSettings("sConnection") Dim sConn As New SqlConnection(sConnString) and still get the same same.I can't figure out what the problem is, but try to evaluate this step by step. Add a new form to your project and simply put the following code in there: Imports System.Configuration Public Class test Inherits System.Web.UI.Page Dim strConn as string Public Sub btnLogin_click(ByVal src As System.Object, ByVal e As System.EventArgs) strConn = ConfigurationSettings.appSettings("sConnection") Dim myConn As New SqlConnection(strConn) Compile your app and now it probably works. ;-) Good luck!!!Imports System.Text Imports System.Web.Mail Imports System.Web.Security Imports System.Web.Configuration Imports System.Data Imports System.Data.SqlClient Imports System.Collections.Specialized <-- needed Public Class login Public Sub btnLogin_click(ByVal src As System.Object, ByVal e As System.EventArgs) Dim appSetting As NameValueCollection Dim sConnString As String appSetting = CType(Context.GetConfig("appSettings"), NameValueCollection) sConnSTring = appSetting("sConnection").ToString() Dim sConn As New SqlConnection(sConnString) -------------------------------------------------- <appSettings> <add key="sConnection" value="data source=;initial catalog=;password=;persist security info=True;user id=benefits;packet size=4096" /> </appSettings>

codebehind error: With block variable not set.

boomefalo

New Member