C#和数据库SQL

[A_persons_journey]

库存管理 入库时候 怎么能使货物数量自动相加啊

SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
cn.Open();

SqlDataAdapter da = new SqlDataAdapter("insert into goods values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')", cn);
DataSet ds=new DataSet ();
da.Fill(ds, "goods");

MessageBox.Show("OK");
cn.Close();

只有一个表 id name num 三个字段。。

[wzy_love_sly]

--这是触发器的方法，上帖发过了

create table goods (id int,name varchar(50),num int)

create trigger tri_goods
on goods 
instead of insert
as
begin
    update a set a.num=a.num+b.num
    from goods a join inserted b on a.id=b.id and a.name=b.name
    insert into goods(id,name,num) select id,name,num from inserted t where not exists(select 1 from goods with(nolock) where id=t.id and name=t.name)
end

insert into goods(id,name,num) select 1,'馒头',11
insert into goods(id,name,num) select 1,'馒头',20
insert into goods(id,name,num) select 1,'白菜',20

select * from goods

[SQL77]

SELECT ID,NAME,SUM(NUM) FROM TB GROUP BY ID,NAME

?
自动相加是什么意思

C#里面好像有COMPUTE方法可以实现SUM

[gao__910]

这样题要弄个存储过程，在存储过程里写
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'SP_AddSum')
BEGIN
DROP Procedure SP_AddSum
END

GO

CREATE Procedure SP_AddSum
(
@ID CHAR(10)
)

AS

SELECT [SUM] = [sum]+[sum]
FROM [TABLE]
WHERE [ID] = @ID
GO

[dawugui]

C#不懂,帮顶.