Server Error in '/' Application.

'AND' anahtar sözcüğü yakınındaki sözdizimi yanlış.

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: 'AND' anahtar sözcüğü yakınındaki sözdizimi yanlış.

Source Error:


Line 195:        SqlCommand cmd_altmenuvarmi = new SqlCommand("SELECT ID FROM sube_menu WHERE ParentID=0 AND subeID=" + subeID + " AND sira_no=1", cnn);
Line 196:        cmd_altmenuvarmi.CommandType = CommandType.Text;
Line 197:        varmi = cmd_altmenuvarmi.ExecuteScalar().ToString();
Line 198:        cnn.Close();
Line 199:        cmd_altmenuvarmi.Dispose();

Source File: d:\vhosts\toomad.net\httpdocs\Subeler\sube_MasterPage.master.cs    Line: 197

Stack Trace:


[SqlException (0x80131904): 'AND' anahtar sözcüğü yakınındaki sözdizimi yanlış.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1968714
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4907387
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2412
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +293
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteScalar() +139
   Subeler_sube_MasterPage.subemiz(String subeID) in d:\vhosts\toomad.net\httpdocs\Subeler\sube_MasterPage.master.cs:197
   Subeler_sube_MasterPage.Page_Load(Object sender, EventArgs e) in d:\vhosts\toomad.net\httpdocs\Subeler\sube_MasterPage.master.cs:47
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.9061; ASP.NET Version:2.0.50727.9062