need help in access database
-
i have some problem in to check loging in access database. i am getting this error as under ------------------- Exception Details: System.Data.OleDb.OleDbException: Could not find installable ISAM. -------------------- the line of error is this ---------------- oledbCon.Open(); ---------------- my all code is as under ------------------------- <%@ 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; OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0; DataSource = d:\\access1.mdb"); 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"); 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:
-
i have some problem in to check loging in access database. i am getting this error as under ------------------- Exception Details: System.Data.OleDb.OleDbException: Could not find installable ISAM. -------------------- the line of error is this ---------------- oledbCon.Open(); ---------------- my all code is as under ------------------------- <%@ 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; OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0; DataSource = d:\\access1.mdb"); 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"); 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: