CODEWITHSUNDEEP
c#asp.net.netms-access
kay
kay

Reputation: 33

asp.net database connection with Access

I want to make a login page with an Access database for a school project with asp.net. I dont have really experience with C# so im doing different tutorials.

protected void Login1_Click(object sender, EventArgs e)
{
    string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=http://tmti-16.ict-lab.nl/database/ek2012.mdb";
    string query = "Select Count(*) From users Where username = ? And userpassword = ?";
    int result = 0;
    using (OleDbConnection conn = new OleDbConnection(connect))
    {
        using (OleDbCommand cmd = new OleDbCommand(query, conn))
        {
            cmd.Parameters.AddWithValue("", UserName.Text);
            cmd.Parameters.AddWithValue("", Password.Text);
            conn.Open();
            Session["User"] = UserName.Text;
            result = (int)cmd.ExecuteScalar();
        }
    }
    if (result > 0)
    {
        Response.Redirect("index.aspx");
    }
    else
    {
        Literal1.Text = "Invalid credentials";
    }
}

In Access I have the table 'users' with the 'username' and 'userpassword' rows.

Upvotes: 2

Views: 7101

Answers (1)

dash
dash

Reputation: 91462

The problem you are encountering is almost certainly to do with the data source segment of your connection string:

string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=http://tmti-16.ict-lab.nl/database/ek2012.mdb"

The Access mdb file should be on a local path. This can be anywhere on your local file system that the account your web application is running as has permission to access, but, usefully, ASP.Net actually has a better place to put these files, the App_Data folder.

If you place your mdb file in this folder, your connection string would then become:

string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|ek2012.mdb"

The contents of the App_Data folder will not be served to clients so this is a secure place to put your data. It's also a good idea to use it as it keeps the data with the project; often, people will put data related files in a file system folder outside of the web root, which means you then have to remember this dependency when moving the site to another computer.

A common issue you might have with accessing files in App_Data is usually related to permissioning; the user you are running the code as will need read and write permissions in this directory in order to modify the mdb file. This is covered in the section "Configuring Permissions for an Access Database" in this MSDN Article.

Upvotes: 4

Related Questions