Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Data.OleDb;
- namespace nex
- {
- public partial class WebForm1 : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- string db = "Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source=C:\\database\\next21.mdb";
- OleDbConnection con = new OleDbConnection(db);
- OleDbCommand cmd;
- OleDbDataReader dr;
- String sql;
- con.Open();
- sql = "SELECT * FROM gwapko WHERE uname = '"+ tbusernamehome.Text +"' AND password='"+ tbpasshome.Text +"'";
- cmd = new OleDbCommand(sql,con);
- dr=cmd.ExecuteReader();
- if(dr.Read()){
- Session["uname"] = dr.GetValue(1).ToString();
- Response.Redirect("useracnt.aspx");
- }else{
- Response.Write("<script language='Javascript'>alert('Failed!');</script>");
- }
- con.Close();
- }
- protected void Button2_Click(object sender, EventArgs e)
- {
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement