ADO记录中为分类结构,即比如某一商品大类下有一小类,小类下又有一小类...依此类推
那么我现在如何用ADO进行操作,这些操作包括增删改,请给个代码,范例,谢谢
那么我现在如何用ADO进行操作,这些操作包括增删改,请给个代码,范例,谢谢
解决方案 »
- VB如何实现向USB接口发送数据和接受数据?
- vb的非平均随机数算法
- vb中OpenKeySet是什么意思?
- 如何让RS有edit属性啊~~~~~~:( 急~~
- 关于遍历控件的问题,在线等,马上送分。。。
- 运行时说FROM字句语法错误,请问如何修改
- 哪位高手帮忙编写一个程序,使局域网各用户之间能传送文件!谢谢!
- 请教Unicode转换为中文的问题
- 大家可以讨论一下查杀病毒的算法原理么?
- ActiveX 工程的编译错误。
- 软件开发完成,为了与大家共同提高,把软件拿出来与大家分享,希望大家找出不足!
- 请教MSHFlexDrid的动态改变dataenvironment1的command1中sql语句?
http://expert.csdn.net/Expert/topic/2569/2569905.xml?temp=.2151453
http://www.microsoft.com/china/community/Columns/Lihonggen/1.mspx
一个管理VB源码的数据库吐血推荐
可以任意添加删除
as
declare @level int
declare @SQLString nvarchar(500)
set @SQLString=N'select vID from '+@Table +' where vID = '''+ltrim(rtrim(@vSourceID))+''''
exec(@SQLString)
if @@rowcount > 0
begin
set @level=0
select @vSourceID as vID,@level as level into #t
set @SQLString=N'insert #t select vID,@level from '+@Table +' where vParentID in (select vID from #t where level=@level-1) '
while @@rowcount > 0
begin
set @level=@level+1
exec sp_executesql @SQLString,N'@level int',@level
end
set @SQLString=N'delete from '+@Table +' where vID in (select vID from #t) '
begin tran
exec sp_executesql @SQLString
if @@error<>0 goto Err
commit
select @iOK=0
return
Err:
rollback
select @iOK=1
end
else
begin
select @iOK=1
end
CREATE procedure prcDelete(@vSourceID varchar(30),@Table varchar(20), @iOK int output)
as
declare @iDepth int
declare @SQLString nvarchar(500)
set @SQLString=N'select vID from '+@Table +' where vID = '''+ltrim(rtrim(@vSourceID))+''''
exec(@SQLString)
if @@rowcount > 0
begin
set @SQLString=N'select @iDepth=iDepth from '+@table+ ' where vID = '''+ltrim(rtrim(@vSourceID))+''''
exec sp_executesql @SQLString,N'@iDepth int output',@iDepth output
select @vSourceID as vID,@iDepth as iDepth into #t
set @SQLString=N'insert #t select vID,iDepth from '+@Table +' where vParentID in (select vID from #t where iDepth=@iDepth-1)'
while @@rowcount > 0
begin
set @iDepth=@iDepth+1
exec sp_executesql @SQLString,N'@iDepth int',@iDepth
end
set @SQLString=N'delete from '+@Table +' where vID in (select vID from #t) '
begin tran
exec sp_executesql @SQLString
if @@error<>0 goto Err
commit
select @iOK=0
return
Err:
rollback
select @iOK=1
end
else
begin
select @iOK=1
end