Click here to Skip to main content
14,877,233 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 5:59
MemberRon Anders21-Oct-19 5:59 
GeneralRe: Are you still alive... Pin
obermd22-Oct-19 3:36
Memberobermd22-Oct-19 3:36 
GeneralWSO - CCC 21/10/2019 - Unthemed Pin
Abbas A. Ali20-Oct-19 22:06
professionalAbbas A. Ali20-Oct-19 22:06 
GeneralRe: WSO - CCC 21/10/2019 - Unthemed Pin
OriginalGriff20-Oct-19 22:13
mveOriginalGriff20-Oct-19 22:13 
GeneralRe: WSO - CCC 21/10/2019 - Solved Pin
Abbas A. Ali20-Oct-19 22:27
professionalAbbas A. Ali20-Oct-19 22:27 
GeneralRe: WSO - CCC 21/10/2019 - Unthemed Pin
super20-Oct-19 22:17
professionalsuper20-Oct-19 22:17 
GeneralRe: WSO - CCC 21/10/2019 - Unthemed Pin
Abbas A. Ali20-Oct-19 22:27
professionalAbbas A. Ali20-Oct-19 22:27 
GeneralSyntax error in FROM clause Pin
Member 1462940920-Oct-19 20:59
MemberMember 1462940920-Oct-19 20: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 21:28
mveOriginalGriff20-Oct-19 21:28 
GeneralRe: Syntax error in FROM clause Pin
Jörgen Andersson20-Oct-19 22:06
professionalJörgen Andersson20-Oct-19 22:06 
GeneralRe: Syntax error in FROM clause Pin
abmv20-Oct-19 22:06
professionalabmv20-Oct-19 22:06 
GeneralRe: Syntax error in FROM clause Pin
OriginalGriff20-Oct-19 22:14
mveOriginalGriff20-Oct-19 22:14 
GeneralRe: Syntax error in FROM clause Pin
PeejayAdams20-Oct-19 22:56
MemberPeejayAdams20-Oct-19 22:56 
GeneralRe: Syntax error in FROM clause Pin
Sander Rossel21-Oct-19 0:39
professionalSander Rossel21-Oct-19 0:39 
GeneralRe: Syntax error in FROM clause Pin
F-ES Sitecore20-Oct-19 22:55
mveF-ES Sitecore20-Oct-19 22:55 
GeneralRe: Syntax error in FROM clause Pin
PeejayAdams21-Oct-19 0:28
MemberPeejayAdams21-Oct-19 0:28 
GeneralRe: Syntax error in FROM clause Pin
OriginalGriff21-Oct-19 0:33
mveOriginalGriff21-Oct-19 0:33 
GeneralRe: Syntax error in FROM clause Pin
#realJSOP21-Oct-19 0:33
mva#realJSOP21-Oct-19 0:33 
GeneralRe: Syntax error in FROM clause Pin
F-ES Sitecore21-Oct-19 0:38
mveF-ES Sitecore21-Oct-19 0:38 
GeneralRe: Syntax error in FROM clause Pin
F-ES Sitecore21-Oct-19 0:37
mveF-ES Sitecore21-Oct-19 0:37 
GeneralRe: Syntax error in FROM clause Pin
Richard Deeming22-Oct-19 1:39
mveRichard Deeming22-Oct-19 1:39 
GeneralRe: Syntax error in FROM clause Pin
PeejayAdams22-Oct-19 1:41
MemberPeejayAdams22-Oct-19 1:41 
GeneralRe: Syntax error in FROM clause Pin
ZurdoDev21-Oct-19 1:00
professionalZurdoDev21-Oct-19 1:00 
GeneralRe: Syntax error in FROM clause Pin
DerekT-P21-Oct-19 1:48
professionalDerekT-P21-Oct-19 1:48 
GeneralRe: Syntax error in FROM clause Pin
Richard Deeming22-Oct-19 1:40
mveRichard Deeming22-Oct-19 1: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.