I strated building a site in HTML and SQL.Here is the code:Login.aspx:\[code\]<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Default2" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"><title>login</title><link href="http://stackoverflow.com/questions/15595267/main.css" rel="Stylesheet" type="text/css" /></head><body dir="ltr"><iframe src="http://stackoverflow.com/questions/15595267/menu.html" width="670px" height="170px" frameBorder="0" style="position:absolute;right:23em"></iframe><img src="http://stackoverflow.com/questions/15595267/design/login2.jpg" height="300px" id="frc"><form id="lgin" runat="server"><table class="regtext"> <tr class="sec"> <td>username</td> <td><input type="text" id="userName" name="userName" class="filld" </td> </tr> <tr> <td>password</td> <td><input type="password" id="pass" name="pass" class="filld" </td> </tr> <input type="submit" class="btn btn-large btn-warning" id="legbtn" value="http://stackoverflow.com/questions/15595267/login" /></table> <%=status %></form></body></html>\[/code\]the code for server side (C#):Login.aspx.cs\[code\]using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class login : System.Web.UI.Page{public string status = "";protected void Page_Load(object sender, EventArgs e){ if (IsPostBack) { string userName = Request.Form["userName"]; string password = Request.Form["pass"]; string sql = string.Format("SELECT * FROM Users WHERE userName='{0}' ", userName); sql += string.Format("AND password='{0}'", password); if (MyAdoHelper.IsExist("Database.mdf", sql)) { Session["userName"] = userName; sql = string.Format("SELECT * FROM Users WHERE userName='{0}' ", userName); sql += string.Format("AND admin='{0}'", true); if (MyAdoHelper.IsExist("Database.mdf", sql)) { Session["admin"] = "admin"; Response.Redirect("Admin.aspx"); } else Response.Redirect("ForRegistered.aspx"); } else status = "error!"; } }}\[/code\]The error is "status does not exist in current context". Where is the problem?
finding mistake in SQL
- Thread starter Jezza
- Start date