ciao a tutti...
sn new di qst form..
premessa..
nn ho mai usato asp.net ma mi tocca x lavoro.

vengo al dunque qst e il my problema:

ho un database col nome traning con tabella AnagraficaUtenti con campi:

Idutente,user,password,nome,citta,cognome,data nascita

sto realizzando un applicazione in asp.net

devo connettermi al database tramite login...
successivamente registrarmi..

x ade ho scritto qst:
nel web config:

<configuration>
<appSettings>
<add key="CnnStr" value="server=.\sqlexpress;uid=SA;pwd=BLACKBOX;dat abase=training"/>
</appSettings>
</configuration>

nel form login.aspx.css:
string connectionString =System.Configuration.ConfigurationSettings.AppSet tings["CnnStr"].ToString();
SqlConnection cn = new SqlConnection(connectionString);
cn.Open();

string sql = "SELECT UserName,Password FROM AnagraficaUtenti WHERE UserName='qwerty' and Password='qwerty";
DataTable dataTable = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(sql, cn);

int recordsAffected = da.Fill(dataTable);
SqlCommand cmd = new SqlCommand(sql);

cmd.ExecuteNonQuery();
if (recordsAffected > 0)
{
}

nel form login.aspx:

<%@ Page Title="Log In" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeBehind="Login.aspx.cs" Inherits="WebAmici.Account.Login" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Log In
</h2>



Please enter your username and password.
<asp:HyperLink ID="RegisterHyperLink" runat="server" EnableViewState="false">Register</asp:HyperLink> if you don't have an account.
</p>
<asp:Login ID="LoginUser" runat="server" EnableViewState="false" RenderOuterTable="false">
<LayoutTemplate>
<span class="failureNotification">
<asp:Literal ID="FailureText" runat="server"></asp:Literal>
</span>
<asp:ValidationSummary ID="LoginUserValidationSummary" runat="server" CssClass="failureNotification"
ValidationGroup="LoginUserValidationGroup"/>
<div class="accountInfo">
<fieldset class="login">
<legend>Account Information</legend>



<asp:Label ID="UserNameLabel" runat="server" AssociatedControlID="UserName">Username:</asp:Label>
<asp:TextBox ID="UserName" runat="server" CssClass="textEntry"></asp:TextBox>
<asp:RequiredFieldValidator ID="UserNameRequired" runat="server" ControlToValidate="UserName"
CssClass="failureNotification" ErrorMessage="User Name is required." ToolTip="User Name is required."
ValidationGroup="LoginUserValidationGroup">*</asp:RequiredFieldValidator>
</p>



<asp:Label ID="PasswordLabel" runat="server" AssociatedControlID="Password">Password:</asp:Label>
<asp:TextBox ID="Password" runat="server" CssClass="passwordEntry" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="PasswordRequired" runat="server" ControlToValidate="Password"
CssClass="failureNotification" ErrorMessage="Password is required." ToolTip="Password is required."
ValidationGroup="LoginUserValidationGroup">*</asp:RequiredFieldValidator>
</p>



<asp:CheckBox ID="RememberMe" runat="server"/>
<asp:Label ID="RememberMeLabel" runat="server" AssociatedControlID="RememberMe" CssClass="inline">Keep me logged in</asp:Label>
</p>
</fieldset>
<p class="submitButton">
<asp:Button ID="LoginButton" runat="server" CommandName="Login" Text="Log In"
ValidationGroup="LoginUserValidationGroup" onclick="LoginButton_Click"/>



</p>
</div>
</LayoutTemplate>
</asp:Login>
</asp:Content>





mi da qst errore:ExecuteNonQuery: Connection property has not been initialized.
cm risolvo??
qlc mi puo dare una mano a completarlo??
grazie in anticipo