connecting ms access database with vb.net

[ash1802]

hello all
i have a big problem with my system, can anyone help me plz

there`s some kind of error, there are 2 text box on my interface, 1 for entering an account number and one for entering password, there is a login button also.

here is the code when clicking on the button but it does not work!!! plz

helpPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim connection As New OleDb.OleDbConnection
 
        Dim command As New OleDbCommand
        Dim DataReader1 As OleDbDataReader
        Dim selectall As String
        Dim Account_No As String = txtAccount.Text
        Dim Password As String = txtPassword.Text
        connection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Datasource=db1.mdb")
 
        selectall = "select * FROM Security WHERE A/c_number= " & Account_No & " and Password = " & Password & ""
        command = New OleDbCommand(selectall, connection)
        connection.Open()
        DataReader1 = command.ExecuteReader()
        If DataReader1.HasRows Then
            MessageBox.Show("ok")
        Else
            MessageBox.Show("incorrect Account_No or password")
        End If
 
    End Sub
End Class

[kenobewan]

Do you get an error? Which line number?

[Plater]

You would probably also have to give a better path to your mdb file then just "db1.mdb", if it errors there you should probably give a full path?

[kenobewan]

Maybe selectall = "select * FROM Security WHERE A/c_number= ' " & Account_No & " ' and Password = ' " & Password & " ' " will help also, if there is no error. HTH.

[bhar]

Hi,

Working with the OleDbConnection object is similar to using the SqlConnection object. However, because the OleDb.NET data provider can be used to connect to several types of databases, you must specify a provider name in the connection string. These provider names will be the same ones that were used with earlier versions of ADO. Here is an example of a connection string for a Microsoft Access database:

 
Dim myConn As OleDbConnection =New OleDbConnection()
 
myConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\data\northwind.mdb; User ID=guest; Password=p5n65"
 

If you are working in Visual studio.NET, a reference will automatically be set to the System.Data.dll for most project types. If not, you must add this reference manually. The System.Data.dll assembly supports both System.Data.SqlClient and System.Data.OleDb. If you install teh ODBC data provider or any other third-party providers, you will have to set references to teh appropriate assemblies.


hope this helps.<Advertising link removed>