现在表中加一个字段用以存放sum的数据, 可以用在数据库中定义一个触发器,把这个总数存储在表中 create trigger tr_stuc表 on stuc表 for insert as BEGIN update set SUM(SGH) as SGH的总数 from stuc表 insert stuc表 select SGH的总数 from INSERTED go 如果是在vb中的话可以用ADODC控件 Private Sub Adodc1_WillMove(ByVal adReason As ADODB.EventReasonEnum, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)Text1.Text = pRecordset("SGH的总数")End SubADODC控件中的ConnectionString中Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=suta在记录源里面选者stuc表就可以了
对不起触发器弄错了 改为: create trigger tr_stuc表 on stuc表 for insert as BEGIN declare @allcount int select SUM(SGH) as 总数 from stuc表
set @allcount = 总数
insert stuc表 values(@allcount) end 应该是可以的 ,呵呵
对不起 触发器刚随便写的,错了 呵呵 改正如下 应该是可以的 create trigger tr_stuc表 on stuc表 for insert as BEGIN declare @allcount int select SUM(SGH) as 总数 from stuc表
set @allcount = 总数
insert stuc表 values(@allcount) end
简单一点的,比较笨!adodc1.RecordSource="select * from stuc where SGH=A" adodc1.Refershtext1.text=Cstr(adodc1.Recordset.RecordCount)
可以用在数据库中定义一个触发器,把这个总数存储在表中
create trigger tr_stuc表
on stuc表
for insert
as
BEGIN
update set SUM(SGH) as SGH的总数
from stuc表
insert stuc表 select SGH的总数 from INSERTED
go
如果是在vb中的话可以用ADODC控件
Private Sub Adodc1_WillMove(ByVal adReason As ADODB.EventReasonEnum, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)Text1.Text = pRecordset("SGH的总数")End SubADODC控件中的ConnectionString中Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=suta在记录源里面选者stuc表就可以了
create trigger tr_stuc表
on stuc表
for insert
as
BEGIN
declare @allcount int
select
SUM(SGH) as 总数 from stuc表
set @allcount = 总数
insert stuc表
values(@allcount)
end
应该是可以的 ,呵呵
create trigger tr_stuc表
on stuc表
for insert
as
BEGIN
declare @allcount int
select
SUM(SGH) as 总数 from stuc表
set @allcount = 总数
insert stuc表
values(@allcount)
end
adodc1.Refershtext1.text=Cstr(adodc1.Recordset.RecordCount)