Help on database connection required.. please

[apachex]

I need help for connecting my 'Access' database to asp.net website. Coding is in C# .
I was working on making a registration page, but since i was unable to connect, I tried a test code for login and it ain't working :icon_cry:

I am using the following code for showing form :

<asp:Literal ID="Literal1" runat="server" /><br />
    User Name: <asp:TextBox ID="uname" runat="server" /><br />
    Password:  <asp:TextBox ID="upassword" runat="server" TextMode="Password" /><br />
    <asp:Button ID="Login" runat="server"  Text="Log In" onclick="Login_Click" />

I am using following code in .cs file :

string connect = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=C:|Users|Apache|Documents|jerry.mdb; User Id=Admin; Password=";
        string query = "Select Count(*) From registration Where uname = ? And upassword = ?";
        int result = 0;
        using (OleDbConnection conn = new OleDbConnection(connect))
        {
            using (OleDbCommand cmd = new OleDbCommand(query, conn))
            {
                cmd.Parameters.AddWithValue("", uname.Text);
                cmd.Parameters.AddWithValue("", upassword.Text);
                conn.Open();
                Session["registration"] = uname.Text;
                result = (int)cmd.ExecuteScalar();
            }
        }
        if (result > 0)
        {
            Response.Redirect("LoggedIn.aspx");
        }
        else
        {
            Literal1.Text = "Invalid credentials";
        }

I have also included 'using System.Data.OleDb;' in starting.. and on running this test page, I get the following errors :

Source Error:

Line 30:                 cmd.Parameters.AddWithValue("", uname.Text);
Line 31:                 cmd.Parameters.AddWithValue("", upassword.Text);
Line 32:                 conn.Open();
Line 33:                 Session["registration"] = uname.Text;
Line 34:                 result = (int)cmd.ExecuteScalar();


Source File: c:\Users\Apache\Documents\Visual Studio 2008\WebSites\onlineshoppingplace\test.aspx.cs    Line: 32

I even included the database 'jerry.mdb' to my database connection, started it from Control Panel > ODBC too.. I would be thankful if someone can teach me about it from 0 level (I mean that maybe I am doing something wrong with database :icon_mad: :confused:)

[abhi1625]

class1.cs
---------
using System.Data;
using System.Data.SqlClient;
public class Class1

{
SqlConnection cnn;
SqlCommand cmd;
SqlDataAdapter da;
DataSet ds;
DataTable dt;

public Class1()
{
//
// TODO: Add constructor logic here
//
}
public DataTable getdata(string query)
{
cnn = new SqlConnection();

cnn.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True";

cmd = new SqlCommand();

cmd.Connection = cnn;

cmd.CommandText = query;

da = new SqlDataAdapter();

da.SelectCommand = cmd;

ds = new DataSet();

da.Fill(ds);

dt = new DataTable();

dt = ds.Tables[0];

return dt;

}

-------------
default.aspx.cs
---------------
Class1 a = new Class1();
protected void Page_Load(object sender, EventArgs e)
{

GridView1.DataSource = a.getdata("select * from student");
GridView1.DataBind();
}

[apachex]

Thank you very much for taking time to reply to my query :D,

But my dear friend, I need to understand for "MS ACCESS", I am using the above code and getting errors... I need help with "log in" form with ACCESS :D

Sighh.. Further help will be appreciated
Thanks in advance

[Sodabread]

I could be wrong, but shouldn't the connection path have "\\" between the folders instead of "|"?

[rohand]

Yes, Your connection string seems wrong. You need to use "\\" instead of pipe sign "|". Also I believe below portion is also wrong.

cmd.Parameters.AddWithValue("", uname.Text);
cmd.Parameters.AddWithValue("", upassword.Text);

In above both lines you need to give either "?" or any valuable name like "@uname" and so on. You can't leave it blank.

Try by this and let us know.

[apachex]

Err.. I tried the above suggestion by you :
to use '@uname' and with '?'

But still I am having problem connecting with the database, btw, it will be great if someone can write the code for access here and i can test that one against mine.. ?

I am not having problems with SQL connection though :((

[plusplus]

I give you my code, but it's in vb, but I'm sure you can translate it

Public Shared Function check_UserCredentials(ByVal username As String, ByVal pass As String) As Boolean

Dim userID As Long
Dim sqlstring As String
sqlstring = "SELECT UserID from tblUsers WHERE Username=? AND Pass=? "
Try
Using cn As New OleDbConnection(WebConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString)

Using dbcomm As New OleDbCommand(sqlstring, cn)
dbcomm.Parameters.AddWithValue("Userername", username)
dbcomm.Parameters.AddWithValue("Pass", pass)
cn.Open()
userID = dbcomm.ExecuteScalar
cn.Close()
End Using

End Using
If userID <> Nothing And userID > 0 Then
Return True
Else
Return False
End If

Catch ex As Exception

Return False
End Try

End Function

And in your web.config file have

<connectionStrings>
<add name="MyConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Mydb.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>

[dnanetwork]

http://www.connectionstrings.com/access
http://www.webcheatsheet.com/ASP/access_connection_strings.php

hope that helps