删除dublicates问题 [英] Remove dublicates issue

问题描述

SqlConnection con = Tools.Baglanti; 
            SqlDataAdapter adapt = new SqlDataAdapter("WITH CTE (Name,SurName,Tckn,Email, DuplicateCount) AS ( SELECT Name, SurName, Tckn, Email, ROW_NUMBER() OVER(PARTITION BY Name, SurName, Tckn, Email ORDER BY Id) AS DuplicateCount FROM Employees ) DELETE FROM CTE WHERE DuplicateCount > 1", con);

我尝试过：



我的代码有问题我无法找到它的位置？

命令文本正在处理sql而不是c＃

What I have tried:

there is a problem with my code that I cant find where it is ?
command text is working on sql but not in c#

推荐答案

此类代码应写为存储过程 [ ^ ]。然后你就可以从客户端调用它了。使用 SqlCommand.ExecuteNonQuery Method（System.Data） .SqlClient） [ CRUD 的_blanktitle =New Window> ^ ] [ ^ ]操作。



详情请见：

演练：使用ADO.NET创建一个简单的数据应用程序 [ ^ ]

如何调用存储过程 [ ^ ]

如何：执行返回行的存储过程 [< a href =https://msdn.microsoft.com/en-us/library/d7125bke.aspxtarget =_ blanktitle =New Window> ^ ]

Such of code should be writen as a stored procedure[^]. Then you'll be able to call it from client side. Use SqlCommand.ExecuteNonQuery Method (System.Data.SqlClient)[^] for CRUD[^] operation.

For further details, please see:
Walkthrough: Creating a simple data application by using ADO.NET[^]
How to call stored procedure[^]
How to: Execute a Stored Procedure that Returns Rows[^]

这篇关于删除dublicates问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！