WEB CONFIG and user auth. HELP plz

xssxss · Apr 28, 2012

Hi before all I must warn you that I'm actually a newbye in all related to ASP.NET. I've followed a wonderfull article from Scott Mitchell called "Specifying configuration Settings in Web.config. Well I'm using the Web Matrix prog. to develop my own web app. while learning ASP.NET. I've got a User control for the users to sign, well the connection string I use to connect to the database is like this: Dim connectionString As String = ConfigurationSettings.AppSettings("sap4all") My Web.config configuration is: <configuration> <appSettings>  <add key="sap4all" value=http://aspmessageboard.com/archive/index.php/"server='localhost'; trusted_connection=true; Database='SAP4all'" /> </appSettings> <system.web> <authentication mode="Forms"> <forms name=".ASPXAUTH" loginUrl="main.aspx" /> </authentication> <authorization> <deny users="?" /> </authorization> <compilation debug="true"/> </system.web> </configuration> When I run the main.aspx page with the Web Matrix it only works the firs time, I mean if I test another page such a register.aspx page or whatever, and then I run the main.aspx again I get the following error message: No se ha inicializado la propiedad ConnectionString. This could be something like: --The ConnectionString property was not initialized... Detalles de la excepción: System.InvalidOperationException: No se ha inicializado la propiedad ConnectionString. --Exception details: System.InvalidOperationException: The connectionString property was not initialized Error de código fuente: --source code Error L?nea 20: Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand) L?nea 21: Dim dataSet As System.Data.DataSet = New System.Data.DataSet L?nea 22: dataAdapter.Fill(dataSet) L?nea 23: L?nea 24: Return dataSet Below is the three pages involved with it's entire source code. The actual situation of the files in the wwwroot is the following: /wwwroot: web.config /sap4all/ main.asp /userControls/ log.ascx a).............WEB.CONFIG <?xml version="1.0" encoding="UTF-8" ?> <configuration> <appSettings> <add key="sap4all" value="server='localhost'; trusted_connection=true; Database='SAP4all'" /> </appSettings> <system.web> <authentication mode="Forms"> <forms name=".ASPXAUTH" loginUrl="main.aspx" /> </authentication> <authorization> <deny users="?" /> </authorization> <compilation debug="true"/> </system.web> </configuration> b)............ MAIN.ASPX <%@ Page Language="VB" Debug="true" %> <%@ Register TagPrefix="rubs" TagName="Log" Src="/UserControls/Log.ascx" %> <%@ import Namespace="System.Configuration" %> <script runat="server"> Sub Page_Load(Sender as object, e as eventArgs) end sub </script> <html> <head> <title>SAP4all --- Bienvenido ----</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body leftmargin="0" topmargin="0"> <form runat="server"> <table cellspacing="0" cellpadding="0" width="100%"> <tbody> <tr> <td> </td> </tr> </tbody> </table> <table id="cont_ppal" cellspacing="0" cellpadding="0" width="100%"> <tbody> <tr> <td> <rubs:Log id="UserControl1" runat="server"></rubs:Log> </td> <td> </td> </tr> </tbody> </table> </form> </body> </html> c)........... LOG.ASCX <%@ Control Language="VB" Debug="true" %> <%@ import Namespace="System.Configuration" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <script runat="server"> Function GetUsers(ByVal user_id As String, ByVal password As String) As System.Data.DataSet 'Dim connectionString As String = "server='localhost'; trusted_connection=true; Database='SAP4all'" 'Dim connectionString As String = ConfigurationSettings.GetConfig("Sap4allAppSettings")("connString") Dim connectionString As String = ConfigurationSettings.AppSettings("sap4all") Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionStri ng) Dim queryString As String = "SELECT [Users].* FROM [Users] WHERE (([Users].[User_id] = @User_id) AND ([Users]."& _ "[Password] = @Password))" Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection) sqlCommand.Parameters.Add("@User_id", System.Data.SqlDbType.Char).Value = user_id sqlCommand.Parameters.Add("@Password", System.Data.SqlDbType.Char).Value = password Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand) Dim dataSet As System.Data.DataSet = New System.Data.DataSet sqlConnection.open() dataAdapter.Fill(dataSet) Return dataSet End Function Sub LoginBtn_Click(Sender As Object, E As EventArgs) If Page.IsValid Then Dim Users as New system.Data.Dataset Users = GetUsers(Username.text, UserPass.Text) If Users.Tables(0).Rows.Count = 1 Then 'FormsAuthentication.RedirectFromLoginPage(UserNam e.Text, true) Msg.Text = "Usuario aceptado"' & Users.Tables(0).Columns(1).ToString() Else Msg.Text = "Usuario o Password incorrectos" Creausuario.Visible = true End If End If End Sub </script> <h2>Login Page </h2> <hr size="1" /> <table> <tbody> <tr> <td> Username:</td> <td> <asp:TextBox id="UserName" runat="server"></asp:TextBox> </td> <td> <asp:RequiredFieldValidator id="Requiredfieldvalidator1" runat="server" ControlToValidate="UserName" Display="Static" ErrorMessage="*"></asp:RequiredFieldValidator> </td> </tr> <tr> <td> Password:</td> <td> <asp:TextBox id="UserPass" runat="server" TextMode="Password"></asp:TextBox> </td> <td> <asp:RequiredFieldValidator id="Requiredfieldvalidator2" runat="server" ControlToValidate="UserPass" Display="Static" ErrorMessage="*"></asp:RequiredFieldValidator> </td> </tr> </tbody> </table> <asp:button id="LoginBtn" onclick="LoginBtn_Click" runat="server" text="Login"></asp:button> <asp:Label id="Msg" runat="server" ForeColor="red"></asp:Label> <asp:HyperLink id="CreaUsuario" runat="server" Visible="False">Crear Usuario</asp:HyperLink> Hope I don`t forget anything Thanks for your coolaboration

WEB CONFIG and user auth. HELP plz

xssxss

New Member