Click here to Skip to main content
14,366,083 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: Are you still alive... Pin
Ron Anders21-Oct-19 6:59
memberRon Anders21-Oct-19 6:59 
GeneralRe: Are you still alive... Pin
obermd22-Oct-19 4:36
memberobermd22-Oct-19 4:36 
GeneralWSO - CCC 21/10/2019 - Unthemed Pin
Abbas A. Ali20-Oct-19 23:06
professionalAbbas A. Ali20-Oct-19 23:06 
GeneralRe: WSO - CCC 21/10/2019 - Unthemed Pin
OriginalGriff20-Oct-19 23:13
protectorOriginalGriff20-Oct-19 23:13 
GeneralRe: WSO - CCC 21/10/2019 - Solved Pin
Abbas A. Ali20-Oct-19 23:27
professionalAbbas A. Ali20-Oct-19 23:27 
GeneralRe: WSO - CCC 21/10/2019 - Unthemed Pin
super20-Oct-19 23:17
professionalsuper20-Oct-19 23:17 
GeneralRe: WSO - CCC 21/10/2019 - Unthemed Pin
Abbas A. Ali20-Oct-19 23:27
professionalAbbas A. Ali20-Oct-19 23:27 
GeneralSyntax error in FROM clause Pin
Member 1462940920-Oct-19 21:59
memberMember 1462940920-Oct-19 21:59 
Please help why "Syntax error in FROM clause"

here my code in visual basic 2008...

Imports System.Data
Imports System.Data.OleDb
Imports System.Data.DataTable

Public Class Form3

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

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Database4.accdb")
        Dim cmd As New OleDbCommand("select* from Table where [name]=@user and [address]=@pass", conn)
        cmd.Parameters.Add("@user", OleDbType.VarChar).Value = TextBox1.Text
        cmd.Parameters.Add("@pass", OleDbType.VarChar).Value = TextBox1.Text
        Dim adapter1 As New OleDbDataAdapter(cmd)
        Dim table As New DataTable
        adapter1.Fill(table)
        If table.Rows.Count <= 0 Then
            MsgBox("Error username or password")
        Else
            MsgBox("Login Successfully")
        End If

    End Sub
End Class

GeneralRe: Syntax error in FROM clause Pin
OriginalGriff20-Oct-19 22:28
protectorOriginalGriff20-Oct-19 22:28 
GeneralRe: Syntax error in FROM clause Pin
Jörgen Andersson20-Oct-19 23:06
protectorJörgen Andersson20-Oct-19 23:06 
GeneralRe: Syntax error in FROM clause Pin
abmv20-Oct-19 23:06
professionalabmv20-Oct-19 23:06 
GeneralRe: Syntax error in FROM clause Pin
OriginalGriff20-Oct-19 23:14
protectorOriginalGriff20-Oct-19 23:14 
GeneralRe: Syntax error in FROM clause Pin
PeejayAdams20-Oct-19 23:56
memberPeejayAdams20-Oct-19 23:56 
GeneralRe: Syntax error in FROM clause Pin
Sander Rossel21-Oct-19 1:39
professionalSander Rossel21-Oct-19 1:39 
GeneralRe: Syntax error in FROM clause Pin
F-ES Sitecore20-Oct-19 23:55
mveF-ES Sitecore20-Oct-19 23:55 
GeneralRe: Syntax error in FROM clause Pin
PeejayAdams21-Oct-19 1:28
memberPeejayAdams21-Oct-19 1:28 
GeneralRe: Syntax error in FROM clause Pin
OriginalGriff21-Oct-19 1:33
protectorOriginalGriff21-Oct-19 1:33 
GeneralRe: Syntax error in FROM clause Pin
#realJSOP21-Oct-19 1:33
mve#realJSOP21-Oct-19 1:33 
GeneralRe: Syntax error in FROM clause Pin
F-ES Sitecore21-Oct-19 1:38
mveF-ES Sitecore21-Oct-19 1:38 
GeneralRe: Syntax error in FROM clause Pin
F-ES Sitecore21-Oct-19 1:37
mveF-ES Sitecore21-Oct-19 1:37 
GeneralRe: Syntax error in FROM clause Pin
Richard Deeming22-Oct-19 2:39
mveRichard Deeming22-Oct-19 2:39 
GeneralRe: Syntax error in FROM clause Pin
PeejayAdams22-Oct-19 2:41
memberPeejayAdams22-Oct-19 2:41 
GeneralRe: Syntax error in FROM clause Pin
ZurdoDev21-Oct-19 2:00
professionalZurdoDev21-Oct-19 2:00 
GeneralRe: Syntax error in FROM clause Pin
DerekT-P21-Oct-19 2:48
professionalDerekT-P21-Oct-19 2:48 
GeneralRe: Syntax error in FROM clause Pin
Richard Deeming22-Oct-19 2:40
mveRichard Deeming22-Oct-19 2:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.