ito po ung error na nalabas sir bakit po ganyan?
Syntax error in string in query expression 'EmployeeIDNumber = ''.
ganito gwin mo..
Private Sub LoanApp_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim x As Integer
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source =" & My.Application.Info.DirectoryPath.ToString() & "\Database\Coop.mdb;"
sql = "SELECT EmployeeIDNumber, LastName, FirstName, MiddleName FROM Members"
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "Members")
max = ds.Tables("Members").Rows.Count
For x = 0 To max - 1
cboEmployeeIDNumber.Items.Add(ds.Tables("Members") .Rows(x).Item(0))
Next
con.Close()
MaxRows = ds.Tables("Members").Rows.Count
inc = -1
End Sub
Private Sub cboEmployeeIDNumber_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboEmployeeIDNumber.SelectedIndexChanged
GetData (cboEmployeeIDNumber.Text)
End Sub
Private Function GetData(IDNumber as String)
Dim x As Integer
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source =" & My.Application.Info.DirectoryPath.ToString() & "\Database\Coop.mdb;"
sql = "SELECT EmployeeIDNumber, LastName, FirstName, MiddleName FROM Members WHERE EmployeeIDNumber = "' & IDNumber & "'"
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "Members")
max = ds.Tables("Members").Rows.Count
Me.txtLastName.Text = ds.Tables("Members").Rows(0).Item("LastName")
Me.txtFirstName.Text = ds.Tables("Members").Rows(0).Item("FirstName")
Me.txtMiddleName.Text = ds.Tables("Members").Rows(0).Item("MiddleName")
con.Close()
MaxRows = ds.Tables("Members").Rows.Count
inc = -1
End Function
yan try mo.. nka auz n yan.. hnd q n natest wla n q tyme eh.. w n bahala jan.
dun nga pla s id.. nka string un s query.. make sure n match ung datatype s codes at DB mo.
Last edited: