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

5 Jan 2006 7:59 PM

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\ShowAngio4Patient.aspx.vb
Line: 87

5 Jan 2006 8:05 PM

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.

Show quoteHide quote

"david" <da***@discussions.microsoft.com> wrote in message
news:82E2E673-4170-4F68-BB91-B6A567F03F76@microsoft.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\ShowAngio4Patient.aspx.vb
> Line: 87
>
>
>

5 Jan 2006 8:17 PM

david

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

David

Show quoteHide quote

"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:82E2E673-4170-4F68-BB91-B6A567F03F76@microsoft.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\ShowAngio4Patient.aspx.vb
> > Line: 87
> >
> >
> >
>
>
>