Posted by sharmin.sdconsultant on 04/24/07 19:02

HI,
Can anyone tell me abt the following error while i was running my
ASP.net project and codes were in vb.net?
Line 1: Incorrect syntax near 'Number'.
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 'Number'.

Source Error:


Line 118: MyCommand.Connection.Open()
Line 119:
Line 120: myDR = MyCommand.ExecuteReader
Line 121:
Line 122: If myDR.Read() Then


Source File: E:\iConnect\Emp_Basic.aspx.vb Line: 120

Stack Trace:


[SqlException: Line 1: Incorrect syntax near 'Number'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteReader()
iconnect.Emp_Basic.Getvalue() in E:\iConnect\Emp_Basic.aspx.vb:120
iconnect.Emp_Basic.Page_Load(Object sender, EventArgs e) in E:
\iConnect\Emp_Basic.aspx.vb:89
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()


Thanks in advance.
senij

• Next in forum: How to Generate all grants to a user role? (SQL Server 2000)
• Prev in forum: Populate table with stored proc
• Thread view: Regarding sql error

[Reply to this message]