Help - error vsro NPC

[kaubebu0n]

When I edit any value it gives the same error. I want to fix this. Have a nice day. Thanks very much!


help me

thank you very much. TY <3

Help me

[Exner.]

Try to edit manually

[kaubebu0n]

I mean how to fix the error. I don't know anything about sql

Help me. Up top

[OKeks]

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.

[Legend-R]

open a (SQL Duzenle) tab and let a program make fixes for sql

[kaubebu0n]

Originally Posted by OKeks

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

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.

Originally Posted by Legend-R

open a (SQL Duzenle) tab and let a program make fixes for sql

You can say more details. thank you

[haiitsystem]

Originally Posted by kaubebu0n

When I edit any value it gives the same error. I want to fix this. Have a nice day. Thanks very much!


help me

thank you very much. TY <3

Help me

Inbox me, i can help you fix it, fb.com/junghyukhae

[OKeks]

If you browse the error on google you can find things like that:


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!

[kaubebu0n]

Originally Posted by haiitsystem

Inbox me, i can help you fix it, fb.com/junghyukhae

pls check notification