ASP.NET

siddisagar wrote:

What is the Difference between Unit Testing and UserAcceptanceTesting.

siddisagar wrote:

Tell me Briefly what we have to do in UserAcceptanceTesting

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);<br />
        SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);<br />
        conn.Open();<br />
        string result = command.ExecuteScalar().ToString();<br />
        Label2.Text = result;<br />
        conn.Close();

neodeaths wrote:

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"));

 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"]);<br />
<br />
        SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);<br />
        conn.Open();<br />
        string result = command.ExecuteScalar().ToString();<br />
        Label2.Text = result;<br />
        conn.Close();

<?xml version="1.0" encoding="utf-8"?><br />
<configuration xmlns=<br />
"http://schemas.microsoft.com/.NetConfiguration/v2.0"><br />
  <connectionStrings><br />
    <add name="HASDBConnectionString1" connectionString="Data Source=------\SQLEXPRESS;Initial Catalog=HASDB;Persist Security Info=True;User ID=sa;Password=---"<br />
     providerName="System.Data.SqlClient" /><br />
  </connectionStrings><br />
  <system.web><br />
    <authorization><br />
      <allow roles="Registrator" /><br />
      <deny users="*" /><br />
    </authorization><br />
  </system.web><br />
</configuration>

<?xml version="1.0"?><br />
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"><br />
	<connectionStrings><br />
  <add name="HASDBConnectionString1" connectionString="Data Source=---\SQLEXPRESS;Initial Catalog=HASDB;Persist Security Info=True;User ID=sa;Password=---"<br />
   providerName="System.Data.SqlClient" /><br />
 </connectionStrings><br />
 <system.web><br />
<br />
   <membership defaultProvider="MyMembershipProvider"><br />
     <providers><br />
       <add name="MyMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="HASDBConnectionString1" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" /><br />
     </providers><br />
   </membership><br />
   <br />
<br />
     <br />
     <br />
		<roleManager enabled="true" defaultProvider="MyMembershipProvider"><br />
     <providers><br />
       <add name="MyMembershipProvider" connectionStringName="HASDBConnectionString1" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /><br />
       <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /><br />
     </providers><br />
   </roleManager><br />
		<authentication mode="Forms" /><br />
		<compilation debug="true"/><br />
    <authorization><br />
<br />
      <deny users="?" /><br />
    </authorization><br />
   <br />
  </system.web>  <br />
  <system.net><br />
<br />
    <mailSettings><br />
<br />
      <smtp><br />
        <network host="my.mail.server" /><br />
      </smtp><br />
    </mailSettings><br />
  </system.net><br />
</configuration>

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionStrings"]);<br />
        SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);<br />
        conn.Open();<br />
        string result = command.ExecuteScalar().ToString();<br />
        Label2.Text = result;<br />
        conn.Close();

neodeaths wrote:

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connectionStrings"]);

neodeaths wrote:

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionStrings"]);

after i change it to<br />
 SqlConnection conn = new SqlConnection("HASDBConnectionString1 ");<br />
        SqlCommand command = new SqlCommand("Select CurrentNo From LookUpID Where TypeID = 'AuctionSessionID'",conn);

neodeaths wrote:

SqlConnection conn = new SqlConnection("HASDBConnectionString1 ");