access login complete
-
<%@ Page Language="C#" Debug="True" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.OleDb" %> // Insert page code here OleDbConnection oledbCon; void Page_Load(Object sender, EventArgs e) { OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0; DataSource = d:\\access1.mdb"); //oledbCon.Open(); } void login_check(Object sender, EventArgs e) { string uid = txtuser.Text; string upass = txtpass.Text; string strCon = @"Data Source='D:\access1.mdb';Provider='Microsoft.Jet.OLEDB.4.0'"; //"Provider = Microsoft.Jet.OleDb.4.0; Data Source = d:\\access1.mdb" OleDbConnection oledbCon = new OleDbConnection(strCon); OleDbCommand oledbCom = new OleDbCommand("Select fname from users where username = '"+uid+"' and upassword = '"+upass+"' ", oledbCon); oledbCon.Open(); OleDbDataReader dr = oledbCom.ExecuteReader(); if(dr.Read()) { Response.Write("You are logged in"); oledbCon.Close(); string url = Request.QueryString["ReturnUrl"]; if(url==null) url = "main.aspx"; Response.Redirect(url); } else { Response.Write("Your Login Faild Try to Register and then login"); } }
Access Login
Username:
Password:
Mazhar Hussain
-
<%@ Page Language="C#" Debug="True" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.OleDb" %> // Insert page code here OleDbConnection oledbCon; void Page_Load(Object sender, EventArgs e) { OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0; DataSource = d:\\access1.mdb"); //oledbCon.Open(); } void login_check(Object sender, EventArgs e) { string uid = txtuser.Text; string upass = txtpass.Text; string strCon = @"Data Source='D:\access1.mdb';Provider='Microsoft.Jet.OLEDB.4.0'"; //"Provider = Microsoft.Jet.OleDb.4.0; Data Source = d:\\access1.mdb" OleDbConnection oledbCon = new OleDbConnection(strCon); OleDbCommand oledbCom = new OleDbCommand("Select fname from users where username = '"+uid+"' and upassword = '"+upass+"' ", oledbCon); oledbCon.Open(); OleDbDataReader dr = oledbCom.ExecuteReader(); if(dr.Read()) { Response.Write("You are logged in"); oledbCon.Close(); string url = Request.QueryString["ReturnUrl"]; if(url==null) url = "main.aspx"; Response.Redirect(url); } else { Response.Write("Your Login Faild Try to Register and then login"); } }
Access Login
Username:
Password:
Mazhar Hussain
And your question is...?
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar The Second EuroCPian Event will be in Brussels on the 4th of September Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!