datagrid error

[rogo]

I'm having a problem getting the dataset to fill the datagrid. Below
is the error page.

Thanks for any help.

--------------------------------------------------------------------------------

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]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.Odbc.OdbcException: ERROR [42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near '.'.

Source Error:


Line 86: Dim dsIData As New DataSet
Line 87: daIData.SelectCommand = New Odbc.OdbcCommand(GSQL,
conn.CN)
Line 88: daIData.Fill(dsIData, "IData")
Line 89: With grdIData
Line 90: .DataSource = dsIData.Tables("IData")


Source File: c:\inetpub\wwwroot\NAFCOMUser\IReport.aspx.vb Line: 88

Stack Trace:


[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL
Server]Line 1: Incorrect syntax near '.'.]
System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle,
SQL_HANDLE hType, RETCODE retcode)
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior
behavior, String method) +1189
System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
+47

System.Data.Odbc.OdbcCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable) +36
NAFCOMUser.IReport.GetGridFiles() in
c:\inetpub\wwwroot\NAFCOMUser\IReport.aspx.vb:88
NAFCOMUser.IReport.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\NAFCOMUser\IReport.aspx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

 

[S. Justin Gengo [MCP]]

Rogo,

The error means there is a problem with your select statement. Can you
successfully run the select statement or stored procedure on its own outside
of the project and get results returned? If not could you post the
statement?

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche