Friday, March 23, 2012

incorrect syntax

some one can help me about this error..i always get the error like this..but stilll dun know exactly what the error..pls help me..
here the message

Incorrect syntax near the keyword 'user'.
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: Incorrect syntax near the keyword 'user'.

Source Error:

Line 51: Dim objdr As SqlDataReader
Line 52: conn.Open()
Line 53: objdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Line 54: List1.DataSource = objdr
Line 55: List1.DataValueField = "user_id"

Source File: c:\inetpub\wwwroot\register\update.aspx.vb Line: 53

Stack Trace:

[SqlException: Incorrect syntax near the keyword 'user'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
register.update.binddata() in c:\inetpub\wwwroot\register\update.aspx.vb:53
register.update.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\register\update.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

------------------------Hi,

What's your CommandText look like? Is it because the conflict of "reserved words"?

Colt

No comments:

Post a Comment