Incorrect syntax near the keyword 'FROM'

I am a beginner at vb.net 2005 and i am getting the following error when i am filling my dataset:

"Incorrect syntax near the keyword 'FROM'."

I am getting the error at this lineobjDataAdapter.Fill(objDataSet,"Catogorie")

Can anyone advise me on what i am doing wrong?

Dim objConnectionAsNew SqlConnection("server=.\sqlexpress;uid=;pwd=;Trusted_Connection=yes;database=Helpdesk2")

Dim objDataAdapterAsNew SqlDataAdapter( _

"SELECT Catogorie_ID, Catogorie_Description, " & _

"FROM Catogorie " & _

"ORDER BY Catogorie_ID", objConnection)

Dim objDataSetAs DataSet

Dim objDataViewAs DataView

objDataSet =New DataSet()

objDataAdapter.Fill(objDataSet,"Catogorie")

objDataView =New DataView(objDataSet.Tables("Catogorie"))

[2099 byte] By [Blaoo] at [2007-12-28]

«« Image in DataGridView
»» VS2005 Prof and .NET Frameworks PropertyGrid component

# 1

Try yanking the extra comma in your query string so that the bit:

Catogorie_Description

Becomes:

Catogorie_Description,

BrendanGrant at 2007-9-4 >

top of Msdn Tech,Visual Basic,Visual Basic General...

# 2

thanks alot that was it

was already stuck on that for a couple of hours

Blaoo at 2007-9-4 >

# 3

The best way to debug such errors (you obviously have an SQL error) is to add a debug.Writeline after you have assembled your SQL statement and print it out: you will more than likely see your error straight away.

e.g. Something like:

Dim sqlStatement as String = "SELECT Catogorie_ID, " _
& "Catogorie_Description, " & _
"FROM Catogorie " & _
"ORDER BY Catogorie_ID"
Debug.WriteLine(sqlStatement)
Dim objDataAdapter As New SqlDataAdapter(sqlStatement, objConnection)

SJWhiteley at 2007-9-4 >

Visual Basic

Visual Basic General

Visual Basic Hot Topic

Visual Basic New Topic

Visual Basic

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech