Incorrect syntax near the keyword 'user'

[karenkksh]

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

Source Error:


Line 35: MyAdapter1 = new SqlDataAdapter( MyCommand1);
Line 36: MyDataSet1 = new DataSet();
Line 37: MyAdapter1.Fill (MyDataSet1);
Line 38:
Line 39: if (MyDataSet1.Tab les[0].Rows.Count == 1)


Source File: c:\Documents and Settings\karen\ My Documents\Visua l Studio 2005\WebSites\W ebSite1\login.a spx.cs Line: 37

Stack Trace:


[SqlException (0x80131904): Incorrect syntax near the keyword 'user'.]
System.Data.Sql Client.SqlConne ction.OnError(S qlException exception, Boolean breakConnection ) +177
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion exception, Boolean breakConnection ) +68
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct stateObj) +199
System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject stateObj) +2305
System.Data.Sql Client.SqlDataR eader.ConsumeMe taData() +31
System.Data.Sql Client.SqlDataR eader.get_MetaD ata() +62
System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader ds, RunBehavior runBehavior, String resetOptionsStr ing) +294
System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1021
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +314
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +20
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or behavior, String method) +107
System.Data.Sql Client.SqlComma nd.ExecuteDbDat aReader(Command Behavior behavior) +10
System.Data.Com mon.DbCommand.S ystem.Data.IDbC ommand.ExecuteR eader(CommandBe havior behavior) +7
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +82
login.btnLogin_ Click(Object sender, EventArgs e) in c:\Documents and Settings\karen\ My Documents\Visua l Studio 2005\WebSites\W ebSite1\login.a spx.cs:37
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +75
System.Web.UI.W ebControls.Butt on.RaisePostBac kEvent(String eventArgument) +97
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring eventArgument) +7
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler sourceControl, String eventArgument) +11
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain(Boolean includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +4921

Anything wrong with the code? Or any code that I need to add?

[kunal pawar]

I think Error is in ur sql Command, which u passed to sqlcomand object.