الفريق العربي للبرمجةأرشيف المنتديات · 2000 – 2023
نسخة أرشيفية للقراءة فقط — التسجيل والمشاركة مغلقان، والمحتوى محفوظ كما كان.

Incorrect syntax near '-'. الحل؟؟؟؟؟؟

بدأه ابن إنسان في 26 مايو 2010 · 2 رد · 805 مشاهدة · في ASP.NET
مشاركة: واتساب X فيسبوك تيليجرام
#1 صاحب الموضوع

السلام عليكم ورحمة الله, الرجاء حل هذه المشكلة ولكم جزيل الشكر ,,, :wacko:

تظهر لي هذه الصفحة اذا سويت اختبار للصفحة اللي سويتها , ما الحل؟؟؟؟

.Server Error in '/WebSite15' Application.

Incorrect syntax near '-'.

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 '-'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[sqlException (0x80131904): Incorrect syntax near '-'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +394 System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +697 System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +95 System.Web.UI.WebControls.DetailsView.HandleUpdate(String commandArg, Boolean causesValidation) +1105 System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +407 System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source, EventArgs e) +95 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source, EventArgs e) +112 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +125 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +169 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +9 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +176 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

#2

طبيعة الخطأ توحي بان لديك خطأ في الكود الذي قمت بكنابته والمتعلق بالاتصال بقاعدة البيانات اتمنى ان تضع الكود الذي كتبته حتى نتمكن من مساعدتك اكثر

#3

هذا الكود ......

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="cars-info.aspx.cs" Inherits="Default6" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register TagName="uc1" TagPrefix="header" Src="~/WebUserControl2.ascx" %>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<header:uc1 ID="Uc1" runat="server" />

<title></title>

</head>

<body>

<p>

<a href="cars-info.aspx">cars</a>

<a href="owners-info.aspx">owners</a>

<a href="sold cars.aspx">sold cars</a>

<a href="المعرض.aspx">المعرض</a></p>

<form id="form1" runat="server">

<p>

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"

AutoGenerateColumns="False" CellPadding="4" DataKeyNames="car-ID"

DataSourceID="SqlDataSource3" ForeColor="#333333" GridLines="None">

<AlternatingRowStyle BackColor="White" />

<Columns>

<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />

<asp:BoundField DataField="car-ID" HeaderText="car-ID"

SortExpression="car-ID" />

<asp:BoundField DataField="Car" HeaderText="Car" SortExpression="Car" />

<asp:BoundField DataField="Model" HeaderText="Model" SortExpression="Model" />

<asp:BoundField DataField="Color" HeaderText="Color" SortExpression="Color" />

<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />

<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />

</Columns>

<EditRowStyle BackColor="#2461BF" />

<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

<RowStyle BackColor="#EFF3FB" />

<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

<SortedAscendingCellStyle BackColor="#F5F7FB" />

<SortedAscendingHeaderStyle BackColor="#6D95E1" />

<SortedDescendingCellStyle BackColor="#E9EBEF" />

<SortedDescendingHeaderStyle BackColor="#4870BE" />

</asp:GridView>

<br />

</p>

<p>

<asp:SqlDataSource ID="SqlDataSource3" runat="server"

ConnectionString="Data Source=localhost\sqlexpress;Initial Catalog=Cars;Integrated Security=True"

ProviderName="System.Data.SqlClient"

SelectCommand="SELECT * FROM [Cars-Info]" ConflictDetection="CompareAllValues"

DeleteCommand="DELETE FROM [Cars-Info] WHERE [car-ID] = @original_column1 AND (([Car] = @original_Car) OR ([Car] IS NULL AND @original_Car IS NULL)) AND (([Model] = @original_Model) OR ([Model] IS NULL AND @original_Model IS NULL)) AND (( = @original_Color) OR ( IS NULL AND @original_Color IS NULL)) AND (([state] = @original_State) OR ([state] IS NULL AND @original_State IS NULL)) AND (([Price] = @original_Price) OR ([Price] IS NULL AND @original_Price IS NULL))"

InsertCommand="INSERT INTO [Cars-Info] ([car-ID], [Car], [Model], , [state], [Price]) VALUES (@column1, @Car, @Model, @Color, @State, @Price)"

OldValuesParameterFormatString="original_{0}"

UpdateCommand="UPDATE [Cars-Info] SET [Car] = @Car, [Model] = @Model, = @Color, [state] = @State, [Price] = @Price WHERE [car-ID] = @original_column1 AND (([Car] = @original_Car) OR ([Car] IS NULL AND @original_Car IS NULL)) AND (([Model] = @original_Model) OR ([Model] IS NULL AND @original_Model IS NULL)) AND (( = @original_Color) OR ( IS NULL AND @original_Color IS NULL)) AND (([state] = @original_State) OR ([state] IS NULL AND @original_State IS NULL)) AND (([Price] = @original_Price) OR ([Price] IS NULL AND @original_Price IS NULL))">

<DeleteParameters>

<asp:Parameter Name="original_column1" Type="Int32" />

<asp:Parameter Name="original_Car" Type="String" />

<asp:Parameter Name="original_Model" Type="Int32" />

<asp:Parameter Name="original_Color" Type="String" />

<asp:Parameter Name="original_State" Type="String" />

<asp:Parameter Name="original_Price" Type="Int32" />

</DeleteParameters>

<InsertParameters>

<asp:Parameter Name="column1" Type="Int32" />

<asp:Parameter Name="Car" Type="String" />

<asp:Parameter Name="Model" Type="Int32" />

<asp:Parameter Name="Color" Type="String" />

<asp:Parameter Name="State" Type="String" />

<asp:Parameter Name="Price" Type="Int32" />

</InsertParameters>

<UpdateParameters>

<asp:Parameter Name="Car" Type="String" />

<asp:Parameter Name="Model" Type="Int32" />

<asp:Parameter Name="Color" Type="String" />

<asp:Parameter Name="State" Type="String" />

<asp:Parameter Name="Price" Type="Int32" />

<asp:Parameter Name="original_column1" Type="Int32" />

<asp:Parameter Name="original_Car" Type="String" />

<asp:Parameter Name="original_Model" Type="Int32" />

<asp:Parameter Name="original_Color" Type="String" />

<asp:Parameter Name="original_State" Type="String" />

<asp:Parameter Name="original_Price" Type="Int32" />

</UpdateParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"

ConnectionString="Data Source=localhost\sqlexpress;Initial Catalog=Cars;Integrated Security=True"

ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Cars-Info]">

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="Data Source=xpsp3-wbb\sqlexpress;Initial Catalog=mybookstore;Integrated Security=True"

ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [authors]">

</asp:SqlDataSource>

</p>

<p>

 </p>

<p>

 </p>

<p>

 </p>

<div>

</div>

</form>

</body>

</html>

مواضيع مشابهة