protected void btnLogin_Click(object sender, EventArgs e)
        {
            string CustUsername;
            string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("Select Count(*) From Login where Username ='" + txtUsername.Text +
                "' and Password ='" + txtPassword.Text + "'", conn);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            if(dt.Rows[0][0].ToString()=="1")
            {
                //Session["CustUsername"] = txtUsername.Text;
                CustUsername = txtUsername.Text;
                Session["CustUsername"] = CustUsername;
                Response.Redirect("CustomerPage.aspx");
            }
            else
            {
                txtPassword.Text = "";
                txtPassword.Text = "error";

            }

        }
    }
}