how to sum tow field of table then insert into next row ?

Question

hi ... i want sum field (Sum) and field (Add value) ... then save in Sum from next Row : http://s5.picofile.com/file/8166315884/Untitled.png

Jitendra Kumar · Answer

hello, Please check this code. may this help you. if any problem plz reply. // For create a table CREATE TABLE [tbl_DemoCsharp]( [Id] [int] IDENTITY(1,1) NOT NULL, [SumV] [int] NOT NULL, [AddValue] [int] NULL, CONSTRAINT [PK_tbl_DemoCsharp] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] and this is a query //i think Addvalue is a value that provide by you. Update tbl_DemoCsharp Set Addvalue=200 where id= (Select top 1 id from tbl_DemoCsharp Order by id Desc) Insert into tbl_DemoCsharp(sumv) Select top 1 Sumv + 200 as Sumval from tbl_DemoCsharp Order by id Desc Select * from tbl_DemoCsharp

Jitendra Kumar · Answer

Hello Ghasem, what you want? i means add column values and insert into new row in the table?

Akhil Garg · Answer

for(int i=0;i { if(i>0) { dataTableName[i]["Sum"]=Convert.ToInt32(dataTableName[i-1]["Sum"].ToString())+Convert.ToInt32(dataTableName[i-1]["Addvalue"].ToString()); } } try this

ghasem deh · Answer

Help Me ...

ghasem deh · Answer

hi dear Jitendra ... yes !

how to sum tow field of table then insert into next row ?

Answers (5)