- ToolTipWebSite.zip
- ToolTipWebSite
- ToolTipWebSiteCS
- StoredProcs.sql
- ToolTipInGridViewCS
- App_Code
- BusinessObject
- BusinessObjectBase
- BusinessObjectCollection
- DataLayer
- DataLayerBase
- Example
- Helper
- App_Themes
- Theme1
- SkinFile.skin
- Images
- ActivityIndicator.gif
- 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
- ToolTipWebSiteVB
- StoredProcs.sql
- ToolTipInGridViewVB
- App_Code
- BusinessObject
- BusinessObjectBase
- BusinessObjectCollection
- DataLayer
- DataLayerBase
- Example
- Helper
- App_Themes
- Theme1
- SkinFile.skin
- Images
- ActivityIndicator.gif
- 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
|
��
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 ] . [ C a t e g o r i e s _ S e l e c t B y P r i m a r y K e y ]
(
@ c a t e g o r y I D i n t
)
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
[ C a t e g o r y I D ] ,
[ C a t e g o r y N a m e ] ,
[ D e s c r i p t i o n ]
F R O M [ d b o ] . [ C a t e g o r i e s ]
W H E R E [ C a t e g o r y I D ] = @ c a t e g o r y I D
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 ] . [ S u p p l i e r s _ S e l e c t B y P r i m a r y K e y ]
(
@ s u p p l i e r I D i n t
)
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
[ S u p p l i e r I D ] ,
[ C o m p a n y N a m e ] ,
[ C o n t a c t N a m e ] ,
[ C o n t a c t T i t l e ] ,
[ A d d r e s s ] ,
[ C i t y ] ,
[ R e g i o n ] ,
[ P o s t a l C o d e ] ,
[ C o u n t r y ] ,
[ P h o n e ] ,
[ F a x ] ,
[ H o m e P a g e ]
F R O M [ d b o ] . [ S u p p l i e r s ]
W H E R E [ S u p p l i e r I D ] = @ s u p p l i e r I D
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 _ 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
|
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.