运行Linq Quary删除重复项,直到sum值等于我在C#,Windows Forms,Asp.net中的愿望值 [英] Run Linq Quary to remove duplicate until sum value equal to my wish value in C#, Windows Forms, Asp.net
问题描述
大家好,
$
我正在尝试删除副本,直到总和值等于 文本框值
我的表名A_table
我写了Linq Quiry
DataClasses1DataContext DB = new DataClasses1DataContext();
$
var f1 =(来自DB中的k.A_表
; 选择k.Amount).Sum();
$
*** //这里我要写一些东西用于" ; F1" sum值等于文本框值
*** // run" f2" quary,直到
var f2 = DB.A_table
    .GroupBy(g => g.S_Number)
    .Where(s => s.Count()> 1)
    .Select(R => R.First());
$
foreach(f2中的var l)
  ;       {
        DB.A_table.DeleteOnSubmit(l);
      }
          DB.SubmitChanges();
$
注意:使用此quary我可以删除所有重复值但我需要
$
textbox等于表金额总和.. ..
例如:如果文本框值为900,那么在数据表中应删除100 amout仅为1000重复数量的总和删除。 ..
pls。帮助我
wenkket
你好wenkket,
>> 例如:如果文本框值为900,那么在数据表中应删除100 amout仅为1000重复数量的总和删除...
为此目的,您要删除哪条记录?
也许您可以删除第一个 重复记录:
var f2 = DB.A_table
.GroupBy(g => g.S_Number)
.Where(s => s.Count()> 1)
。选择(R => R .FirstOrDefault())FirstOrDefault();
DB.A_table.Remove(f2);问候,
Frankie
Hi to all,
i am trying to remove duplicate until sum value equal to textbox value
My Table Name A_table
I wrote Linq Quiry
DataClasses1DataContext DB = new DataClasses1DataContext();
var f1 = (from k in DB.A_table
select k.Amount).Sum();
***// Here i have to write something for "f1" sum value equal to textbox value
***// run "f2" quary untill
var f2 = DB.A_table
.GroupBy(g => g.S_Number)
.Where(s => s.Count() > 1)
.Select(R => R.First());
foreach (var l in f2)
{
DB.A_table.DeleteOnSubmit(l);
}
DB.SubmitChanges();
Note: using this quary i can remove the all duplicates values but i need
textbox equal to table Amount sum value..
Ex: if text box value is 900 then in data table should be delete 100 amout only sum of 1000 amount for duplicates delete ...
pls. help me
wenkket
Hi wenkket,
>>Ex: if text box value is 900 then in data table should be delete 100 amout only sum of 1000 amount for duplicates delete ...
For this purpose, which record do you want to remove?
Maybe you can remove the first duplicate record:
var f2 = DB.A_table .GroupBy(g => g.S_Number) .Where(s => s.Count() > 1) .Select(R => R.FirstOrDefault()).FirstOrDefault(); DB.A_table.Remove(f2);Regards,
Frankie
这篇关于运行Linq Quary删除重复项,直到sum值等于我在C#,Windows Forms,Asp.net中的愿望值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!