Hello, I get this error message when I try to do an update on my form. Can somebody help. Please see the my code below.

Imports System
Imports System.Data
Imports System.Data.OleDb
Imports System.Windows.Forms

Public Class Incilistfrm
Inherits System.Windows.Forms.Form
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\Desktop\Project\MyDatabasev1.mdb")
Dim cmd As OleDbCommand
Dim incidentDa As OleDbDataAdapter
Dim incidentDs As DataSet
Dim cb As OleDbCommandBuilder
Dim builder As OleDbCommandBuilder

Private Sub Incilistfrm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    conn.ConnectionString = _
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\Desktop\Project\MyDatabasev1.mdb"

    incidentDa = New OleDbDataAdapter

    incidentDa.SelectCommand = New OleDbCommand("Select * from [Password]", conn)

    'incidentDa.SelectCommand = New OleDbCommand("Select * from Incident", conn)

    builder = New OleDbCommandBuilder(incidentDa)

    incidentDs = New DataSet("Password")

    incidentDa.Fill(incidentDs)

    DataGrid1.DataSource = incidentDs.Tables(0)

End Sub

Private Sub DataGrid1_Navigate(ByVal sender As System.Object, ByVal ne As System.Windows.Forms.NavigateEventArgs)

End Sub

Private Sub buttonUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click

    builder.GetUpdateCommand()

    Dim s As String

    s = builder.GetUpdateCommand().CommandText

    incidentDa.Update(incidentDs)

End Sub

thanks alot

thanks

hello guys, I have an access database table with ten columns and I want to be to load all the data from my table into a vb.net form. can somebody please guide me how to do this.

thank you in advance.

Thanks.

hello, can somebody please help me. I need to create a clear button to delete all the data from my form. I don't know how to do this. can some body give an idea how to do this, I am using vb.net 2003.

Hello Guys,

I am getting this error message and I can't figure out why. can somebody please help. below is the code.

Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click

    Dim sql = "SELECT Username,Password FROM Password WHERE Username = "" & txtUsername.Text & "" AND Password = "" & txtPassword.Text & " '"

    cmd = New OleDbCommand(sql, conn)

    conn.Open()

    Dim dr As OleDbDataReader = cmd.ExecuteReader

    Try
        conn.Open()
    Catch ex As Exception
        MsgBox(ex.Message)

    End Try
    Try
        If dr.Read = False Then
            MessageBox.Show("Authentication Failed...")
        Else
            MessageBox.Show("Login Successful...")

        End If
    Catch ex As Exception
        MsgBox(ex.Message)

        If conn.State <> ConnectionState.Closed Then
            conn.Close()

        End If

        Dim form As New mainfrm
        form.Show()
    End Try
End Sub

Hi All,

I am getting the below error message when I try to degug my program.

The 'Migrosoft.Jet.OLEDB.4.0' provider is not registered on the local machine

Thanks in advance.

does anybody know how to create a login form in vb.net? I have an access database and I am trying to create a login form with a user name and password to have multiple users login.

Please help.

arjunsasidharan commented: Welcome to daniweb +3