[Hazem1]

بسم الله الرحمن الرحيم

إخواني الكِرام ظهر لدي خطأ لم يسبق لي أن رأيته في المشروع خلال الفترة الماضية، كما في الصورة التالية :

حاولت البحث عن حل فوجدت أن بعض الآراء طُرحت فيما يخص #C ووجدت مايخص الفيجوال بيسك في موضوع وكان الحل الأخير هو قول أحد المُرمجين: تتمثل النقطة الكاملة لطرق DB Direct في أنك تعمل مباشرةً مع قاعدة البيانات ، بمعنى عدم وجود DataTable وسيطة. إذا كنت تستخدم Datatable ، فلا تستخدم DB Direct.


وهذا رابط الموضوع

وهناك موضوع آخر يتحدث عن حل المشكلة لكن بالتعامل مع ال SQL 

https://techbrij.com/concurrency-violati...-1-records


بصدق لم أفهم الرد جيداً لذا أحببت أطرح المُشكلة على حضراتكم لعلي أجد الجواب إن شاء الله خاصةً أنني أعمل على قاعدة بيانات ACCESS، وجزاكم الله خيراً.

---

(26-10-18, 10:37 PM)rnmr كتب : جرب هذا


إضغط زر Details لعرض تفاصيل المشكلة كاملة

مع وضع كود التحديث الذي استخدمته

أهلاً بك أخي الكريم rnmr تفضل 

كود :

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.DBConcurrencyException: Concurrency violation: the DeleteCommand affected 0 of the expected 1 records.
  at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
  at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
  at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
  at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
  at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
  at WindowsApplication1.a18DataSetTableAdapters.Table15TableAdapter.Update(Table15DataTable dataTable) in D:\Nor v1.0\WindowsApplication1\a18DataSet.Designer.vb:line 997
  at WindowsApplication1.Form2.Button18_Click_1(Object sender, EventArgs e) in D:\Nor v1.0\WindowsApplication1\Form2.vb:line 918
  at System.Windows.Forms.Control.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.ButtonBase.WndProc(Message& m)
  at System.Windows.Forms.Button.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
WindowsApplication1
   Assembly Version: 1.0.0.0
   Win32 Version: 1.0.0.0
   CodeBase: file:///D:/Nor%20v1.0/WindowsApplication1/bin/Debug/WindowsApplication1.exe
----------------------------------------
Microsoft.VisualBasic
   Assembly Version: 10.0.0.0
   Win32 Version: 14.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Remoting
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Management
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
System.Data
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Data.DataSetExtensions
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
System.Numerics
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
Accessibility
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Transactions
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
   Assembly Version: 4.0.0.0
   Win32 Version: 4.7.3062.0 built by: NET472REL1
   CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
   <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

بالنسبة لكود التحديث : 

كود :

Table15BindingSource.EndEdit()
           Table15TableAdapter.Update(A18DataSet.Table15)