Syntax error about daAngio.Fill(dsAngio, "AngioInfo")

[david]

Anyone could give me a hand about this syntax error? Thank you.
David
Source Code:
Dim conn As New SqlConnection(strConn)
Dim daAngio As New SqlDataAdapter(strSelectStatement, conn)
'Create a dataset
Dim dsAngio As New DataSet
'fill in the dataset by adapter
daAngio.Fill(dsAngio, "AngioInfo")
Dim ok As Boolean = False

Error Message:
Line 1: Incorrect syntax near ','.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect
syntax near ','.

Source Error:
Line 85: Dim dsAngio As New DataSet
Line 86: 'fill in the dataset by adapter
Line 87: daAngio.Fill(dsAngio, "AngioInfo")
Line 88:
Line 89: Dim ok As Boolean = False
Source File: c:\inetpub\wwwroot\Demo\ShowImages\ShowAngio4Patie nt.aspx.vb
Line: 87

[Marina]

The syntax error is in your sql statement.

If it was a syntax error in your code, this wouldn't compile, meaning it
could never run.

"david" <da***@discussions.microsoft.com> wrote in message
news:82**********************************@microsof t.com...

Anyone could give me a hand about this syntax error? Thank you.
David
Source Code:
Dim conn As New SqlConnection(strConn)
Dim daAngio As New SqlDataAdapter(strSelectStatement, conn)
'Create a dataset
Dim dsAngio As New DataSet
'fill in the dataset by adapter
daAngio.Fill(dsAngio, "AngioInfo")
Dim ok As Boolean = False

Error Message:
Line 1: Incorrect syntax near ','.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect
syntax near ','.

Source Error:
Line 85: Dim dsAngio As New DataSet
Line 86: 'fill in the dataset by adapter
Line 87: daAngio.Fill(dsAngio, "AngioInfo")
Line 88:
Line 89: Dim ok As Boolean = False
Source File: c:\inetpub\wwwroot\Demo\ShowImages\ShowAngio4Patie nt.aspx.vb
Line: 87

[david]

Thanks. I found the error. When you make a copy/paste, it automatically adds
brakets ( ).

David
"Marina" wrote:

The syntax error is in your sql statement.

If it was a syntax error in your code, this wouldn't compile, meaning it
could never run.

"david" <da***@discussions.microsoft.com> wrote in message
news:82**********************************@microsof t.com...

Anyone could give me a hand about this syntax error? Thank you.
David
Source Code:
Dim conn As New SqlConnection(strConn)
Dim daAngio As New SqlDataAdapter(strSelectStatement, conn)
'Create a dataset
Dim dsAngio As New DataSet
'fill in the dataset by adapter
daAngio.Fill(dsAngio, "AngioInfo")
Dim ok As Boolean = False

Error Message:
Line 1: Incorrect syntax near ','.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect
syntax near ','.

Source Error:
Line 85: Dim dsAngio As New DataSet
Line 86: 'fill in the dataset by adapter
Line 87: daAngio.Fill(dsAngio, "AngioInfo")
Line 88:
Line 89: Dim ok As Boolean = False
Source File: c:\inetpub\wwwroot\Demo\ShowImages\ShowAngio4Patie nt.aspx.vb
Line: 87