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(Com mandBehavior
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

(sharmin.sdconsultant (AT) gmail (DOT) com) writes:
The error means that there was a syntax error in your SQL command. As you
did not include the text of this command, I cannot say what you need to
do to correct the error.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx