DeleteConfirmation.zip
DeleteConfirmation
DeleteConfirmationCS
DeleteInGridView
App_Code
BusinessObject
BusinessObjectBase
BusinessObjectCollection
DataLayer
DataLayerBase
Example
Helper
App_Themes
Theme1
SkinFile.skin
Images
ActivityIndicator.gif
Delete.png
Spacer.gif
JQueryThemes
redmond
images
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_55_fbec88_40x100.png
ui-bg_glass_75_d0e5f5_1x400.png
ui-bg_glass_85_dfeffc_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_gloss-wave_55_5c9ccc_500x100.png
ui-bg_inset-hard_100_f5f8f9_1x100.png
ui-bg_inset-hard_100_fcfdfd_1x100.png
ui-icons_217bc0_256x240.png
ui-icons_2e83ff_256x240.png
ui-icons_469bdd_256x240.png
ui-icons_6da8d5_256x240.png
ui-icons_cd0a0a_256x240.png
ui-icons_d8e7f3_256x240.png
ui-icons_f9bd01_256x240.png
jquery-ui-1.8.11.custom.css
MasterPage.master
MasterPage.master.cs
Scripts
Styles
web.config
Web_Products.aspx
Web_Products.aspx.cs
SQLScripts.sql
DeleteConfirmationVB
DeleteInGridViewVB
App_Code
BusinessObject
BusinessObjectBase
BusinessObjectCollection
DataLayer
DataLayerBase
Example
Helper
App_Themes
Theme1
SkinFile.skin
Images
ActivityIndicator.gif
Delete.png
Spacer.gif
JQueryThemes
redmond
images
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_55_fbec88_40x100.png
ui-bg_glass_75_d0e5f5_1x400.png
ui-bg_glass_85_dfeffc_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_gloss-wave_55_5c9ccc_500x100.png
ui-bg_inset-hard_100_f5f8f9_1x100.png
ui-bg_inset-hard_100_fcfdfd_1x100.png
ui-icons_217bc0_256x240.png
ui-icons_2e83ff_256x240.png
ui-icons_469bdd_256x240.png
ui-icons_6da8d5_256x240.png
ui-icons_cd0a0a_256x240.png
ui-icons_d8e7f3_256x240.png
ui-icons_f9bd01_256x240.png
jquery-ui-1.8.11.custom.css
MasterPage.master
MasterPage.master.vb
Scripts
Styles
web.config
Web_Products.aspx
Web_Products.aspx.vb
SQLScripts.sql
|
��
S E T A N S I _ N U L L S O N
G O
S E T Q U O T E D _ I D E N T I F I E R O N
G O
C R E A T E P R O C E D U R E [ d b o ] . [ P r o d u c t s _ S e l e c t A l l ]
A S
B E G I N
S E T N O C O U N T O N ;
S E L E C T
[ P r o d u c t I D ] ,
[ P r o d u c t N a m e ] ,
[ S u p p l i e r I D ] ,
[ C a t e g o r y I D ] ,
[ Q u a n t i t y P e r U n i t ] ,
[ U n i t P r i c e ] ,
[ U n i t s I n S t o c k ] ,
[ U n i t s O n O r d e r ] ,
[ R e o r d e r L e v e l ] ,
[ D i s c o n t i n u e d ]
F R O M [ d b o ] . [ P r o d u c t s ]
E N D
G O
S E T A N S I _ N U L L S O N
G O
S E T Q U O T E D _ I D E N T I F I E R O N
G O
C R E A T E P R O C E D U R E [ d b o ] . [ P r o d u c t s _ D e l e t e ]
(
@ p r o d u c t I D i n t
)
A S
B E G I N
S E T N O C O U N T O N ;
D E L E T E F R O M [ d b o ] . [ P r o d u c t s ]
W H E R E [ P r o d u c t I D ] = @ p r o d u c t I D
E N D
G O
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.