Problem updating multi-row

Question

table:ProductComapny

field:NameProduct

NameProduct

1

4

5

i want update fields NameProduct where NameProduct= 1 to(NameProduct=1,NameProduct=2,NameProduct=3

how can this work??

result

NameProduct

1

2

3

4

5

Post what you have tried so far.

Jeroen
– Jeroen

2011-08-18 14:10:52 +00:00
Commented Aug 18, 2011 at 14:10 — Jeroen
– Jeroen, Commented Aug 18, 2011 at 14:10

Aleksey Bieneman · Accepted Answer · 2011-08-18 14:31:09Z

1

var source = new int[] {1,1,1,4,5};
var result = source.Select( (val,i) => val==1 ? i : val );

answered Aug 18, 2011 at 14:31

Aleksey Bieneman

1651 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DooDoo · Accepted Answer · 2011-08-19 20:40:48Z

0

Try This:

using (DataClassesDataContext dc=new DataClassesDataContext())
    {
        var my = from a in dc.ProductComapny
                 where a.NameProduct== 1
                 select a;

        int i=1;
        foreach (var item in my)
        {
            item.NameProduct= i;
            dc.SubmitChanges();
            i++;
        }
    }

answered Aug 19, 2011 at 20:40

DooDoo

13.1k70 gold badges193 silver badges320 bronze badges

Collectives™ on Stack Overflow

Problem updating multi-row

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related