Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- 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.OleDb;
- public partial class _Default : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- OleDbConnection dbConnection = new OleDbConnection(ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString);
- dbConnection.Open();
- string SQL = "select * from members where username ='" + TextBox1.Text + "'";
- OleDbCommand dbCmd = new OleDbCommand(SQL, dbConnection);
- OleDbDataReader dbReader = dbCmd.ExecuteReader();
- string username = "", password = "", studentid = "";
- if (dbReader.Read())
- {
- username = (dbReader["username"]).ToString();
- password = (dbReader["password"]).ToString();
- studentid = (dbReader["studentid"]).ToString();
- }
- if (TextBox1.Text == username && TextBox2.Text == password)
- {
- Session["studentid"] = studentid;
- Response.Redirect("Default2.aspx");
- }
- else
- {
- Response.Write("Invalid Login Please Tryagain");
- }
- }
- }
Add Comment
Please, Sign In to add comment