A further note - the generator routines contain a section like:
-- Set @SET_DB to name of SP to set permissions or to blank
SELECT @SET_DB = 'asp_dbPermissions'
SELECT @ObPrefix = 'x' -- Prefix for object variables
SELECT @DefLanguage = 'VB' -- Default language C# or VB
SELECT @Separator2 = '' -- Separator between Tablename and action
-- Configuration end
Change @SET_DB to your routine for setting stored procedure permissions or blank it out if wish to do it your self. A small system can easily have hundreds of stored procedures or more, setting them by hand can take hours, but a permissions routine can
do it very reliably (why send a human to do a machines job!)
Change obPrefix if you prefer another prefix to x for object variables
Change DefLanguge to C# if you want the wrapper code to default to C#
Put a value in separator2 if you TableYOURVALUEInsert to TableInsert
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: filling the textbox,dropdownlist from the database??
Mar 29, 2008 09:39 PM|LINK
A further note - the generator routines contain a section like:
-- Set @SET_DB to name of SP to set permissions or to blank
SELECT @SET_DB = 'asp_dbPermissions'
SELECT @ObPrefix = 'x' -- Prefix for object variables
SELECT @DefLanguage = 'VB' -- Default language C# or VB
SELECT @Separator2 = '' -- Separator between Tablename and action
-- Configuration end
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239