Help - error vsro NPC

05/05/2021 05:12 kaubebu0n#1
When I edit any value it gives the same error. I want to fix this. Have a nice day. Thanks very much!
[Only registered and activated users can see links. Click Here To Register...]

:feelsbadman: help me

thank you very much. TY <3

Help me
05/05/2021 05:45 Exner.#2
Try to edit manually
05/05/2021 13:04 kaubebu0n#3
I mean how to fix the error. I don't know anything about sql

Help me. Up top
05/05/2021 20:28 OKeks#4
Move the error window down and we will see the table you want to edit. Also please click on "details" to show us the error information.
05/05/2021 20:56 Legend-R#5
open a (SQL Duzenle) tab and let a program make fixes for sql
05/06/2021 03:54 kaubebu0n#6
Quote:
Originally Posted by OKeks View Post
Move the error window down and we will see the table you want to edit. Also please click on "details" to show us the error information.
this is error

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

************** Exception Text **************
System.InvalidOperationException: Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information.
at System.Data.Common.DbCommandBuilder.BuildWhereClau se(DataTableMapping mappings, DataRow dataRow, StringBuilder builder, DbCommand command, Int32 parameterCount, Boolean isUpdate)
at System.Data.Common.DbCommandBuilder.BuildDeleteCom mand(DataTableMapping mappings, DataRow dataRow)
at System.Data.Common.DbCommandBuilder.GetDeleteComma nd(DataRow dataRow, Boolean useColumnsForParameterNames)
at System.Data.SqlClient.SqlCommandBuilder.GetDeleteC ommand()
at Tablo.dataSet.Update(DataTable table)
at UserKontrol.itemm.islem()
at UserKontrol.itemm.itemm_Load(Object sender, EventArgs e)
at System.Windows.Forms.UserControl.OnLoad(EventArgs e)
at System.Windows.Forms.UserControl.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.ControlCollection.Add (Control value)
at System.Windows.Forms.Form.ControlCollection.Add(Co ntrol value)
at UserKontrol.Uyari1.gelen()
at UserKontrol.Bilgi1.btnEvet_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs 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.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(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.8.4010.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
vSRONPC
Assembly Version: 1.0.2.1
Win32 Version: 1.0.2.1
CodeBase: file:///C:/Program%20Files%20(x86)/vSroNPC/vSroNPC/vSroNpc/vSRONPC.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4001.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4001.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
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.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.8.4001.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
sql
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/vSroNPC/vSroNPC/vSroNpc/sql.DLL
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
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.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
UserKontrol
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/vSroNPC/vSroNPC/vSroNpc/UserKontrol.DLL
----------------------------------------
Tablo
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/vSroNPC/vSroNPC/vSroNpc/Tablo.DLL
----------------------------------------
ConfigOku
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/vSroNPC/vSroNPC/vSroNpc/ConfigOku.DLL
----------------------------------------
System.Runtime.Caching
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Caching/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.Caching.dll
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.8.3752.0 built by: NET48REL1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
TxTDosyaOlustur
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/vSroNPC/vSroNPC/vSroNpc/TxTDosyaOlustur.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.
Quote:
Originally Posted by Legend-R View Post
open a (SQL Duzenle) tab and let a program make fixes for sql
You can say more details. thank you
05/06/2021 10:56 haiitsystem#7
Quote:
Originally Posted by kaubebu0n View Post
When I edit any value it gives the same error. I want to fix this. Have a nice day. Thanks very much!
[Only registered and activated users can see links. Click Here To Register...]

:feelsbadman: help me

thank you very much. TY <3

Help me
Inbox me, i can help you fix it, fb.com/junghyukhae
05/06/2021 14:48 OKeks#8
If you browse the error on google you can find things like that:
[Only registered and activated users can see links. Click Here To Register...]

It looks like you can use that tool only, if you have a "non-edited" database. If the tool is trying to delete something from the DB-table that does not have a primary key, it will prompt and error.

Steps to check:
- finally move your error window down, to check what kind of table is modified (_refXYZ)
- open the database in MSSQL studio, right click the table that is used and go to "Design"
- check for primary key (a key symbol)
- if you do not have it, maybe download a clean database
- create a backup of your current shard DB and copy the backup file somewhere else to be sure
- rename the downloaded database file to something else that what you are using
- restore the backup and use a different shard DB name (to add it together with the shard you are using)
- open the design of the same table in the new DB and check for primary key

Certain ppl do not take care about things like that and remove the primary key values from their DB, causing funny issues afterwards.
Better keep the DB structure as it is!
05/07/2021 04:46 kaubebu0n#9
Quote:
Originally Posted by haiitsystem View Post
Inbox me, i can help you fix it, fb.com/junghyukhae
pls check notification :D