Re: datagrid error
- From: "S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate.com>
- Date: Fri, 13 Jan 2006 15:13:35 -0600
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
"rogo" <goinsr@xxxxxxxx> wrote in message
news:1137178024.175658.271390@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>
.
- References:
- datagrid error
- From: rogo
- datagrid error
- Prev by Date: What is better for a web page????
- Next by Date: Re: C++ 6.0 dll work with asp.net
- Previous by thread: datagrid error
- Next by thread: Creating new directory on the server
- Index(es):
Relevant Pages
|
