Line 36:             SqlCommand Checkuser = new SqlCommand(cmdStr,con);
Line 37: 
Line 38:             int temp = Convert.ToInt32(Checkuser.ExecuteScalar().ToString());
Line 39:             
Line 40:             if (temp == 1)

HERE IS MY CODE FROM Login.aspx.cs:

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace zephyrAir2
{
    public partial class Login : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
             
            // Setting connection object
           // SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["useThisConnStringYOOOOO!"].ConnectionString);
           SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString);

            //Opening the connection
            con.Open();

            string cmdStr = "select Username from UserAccounts where Username = '" + TextBox1.Text + "'";

            SqlCommand Checkuser = new SqlCommand(cmdStr,con);

            int temp = Convert.ToInt32(Checkuser.ExecuteScalar().ToString());
            
            if (temp == 1)
            {
                string cmdStr2 = "select Password from UserAccounts where Password = '" + TextBox2.Text + "'";
                SqlCommand pass = new SqlCommand(cmdStr2, con);

               // string password = pass.ExecuteScalar().ToString();
                string password = pass.ToString();
                con.Close();
                
                if (password == TextBox2.Text)
                {
                    Session["New"] = TextBox1.Text;
                    Response.Redirect("ZephyrIndex.aspx");
                }
                else
                {
                    Label1.Visible = true;
                    Label1.Text = "Invalid Password. Try Again Please.";
                }
            }
                else
                {
                     Label1.Visible = true;
                    Label1.Text = "Invalid Username. Try Again Please.";
                }

            }
        }
    }