usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Linq;usingsystem.web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls; Public Partial classlogin:system.web.ui.page{protected voidPage_Load (Objectsender, EventArgs e) { } Public BOOLChecklogin (sysuser user,ref stringmessage) { stringSqlconstr ="Data Source=.;i Nitial catalog=example;integrated security=true"; stringsql ="SELECT * from systemuser where [email protected]"; SqlConnection Con=NewSqlConnection (SQLCONSTR); SqlCommand cmd=NewSqlCommand (sql, con); Sqlparameter[] Para= { NewSqlParameter ("@userid", user. Userid),//New SqlParameter ("@userpwd", user. PWD), }; Con. Open (); Cmd. Parameters.addrange (para); SqlDataReader SDR=cmd. ExecuteReader (); if(SDR). HasRows) {if(SDR). Read () &&sdr["userpwd"]. ToString () = =user. PWD) {con. Close (); Message="Success"; return true; } Else{message="Wrong password! "; return false; } } Else{message="no such user"; return false; } } protected voidBtnlogin_click1 (Objectsender, EventArgs e) { //get information entered by the userSysuser user =NewSysuser (); User. Userid=Txtuser. Text.trim (); User. PWD=txtpwd. Text.trim (); stringMessage =""; //Login to authenticate the user's input if(Checklogin (User,refmessage)) { //successfully jump to homepagesession["UserInfo"] =user; } Else { //failure prompts for failure informationLtl. Text ="Logon Failure"; } }}
aspx simple Login