Click here to Skip to main content
15,898,968 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: How To Call C# Function From JavaScript Pin
YeHtut11-Dec-07 21:13
YeHtut11-Dec-07 21:13 
GeneralRe: How To Call C# Function From JavaScript Pin
Michael Sync11-Dec-07 21:24
Michael Sync11-Dec-07 21:24 
GeneralPanel Hide Show Issue Pin
mpavas11-Dec-07 2:23
mpavas11-Dec-07 2:23 
GeneralRe: Panel Hide Show Issue Pin
Sun Rays11-Dec-07 18:56
Sun Rays11-Dec-07 18:56 
Generalhi how to send a null value through .net into a stored procedure Pin
jagan12311-Dec-07 1:11
jagan12311-Dec-07 1:11 
GeneralRe: hi how to send a null value through .net into a stored procedure Pin
J4amieC11-Dec-07 1:31
J4amieC11-Dec-07 1:31 
Questionhow to write a stored procedure to check the users sending parameter value Pin
jagan12311-Dec-07 0:00
jagan12311-Dec-07 0:00 
AnswerRe: how to write a stored procedure to check the users sending parameter value Pin
J4amieC11-Dec-07 1:36
J4amieC11-Dec-07 1:36 
CREATE PROC FindEmployee
   @RefNo VARCHAR(100) = NULL,
   @EmpId INT = NULL
AS

IF @RefNo IS NOT NULL
   SELECT * FROM Employees WHEERE RefNo = @RefNo
ELSE
   SELECT * FROM Employees WHEERE EmpId = @EmpId


EXEC FindEmployee @RefNo = 'ABC123'<br />
EXEC FindEmployee @EmpId = 999


By specifying a default for each param in the SP (the = NULL bit) you do not have to pass that parameter to the stored procedure. Therefore by checking the default ( IS NOT NULL bit) you can determine which param was passed in. It should be obvious from the code above that if both are passed in it still uses @RefNo - this could be switched around to favour EmpId.
Questionhow to make a queue of jobs for moderators of a web-site Pin
hurrem10-Dec-07 23:47
hurrem10-Dec-07 23:47 
AnswerRe: how to make a queue of jobs for moderators of a web-site Pin
RichardGrimmer11-Dec-07 5:20
RichardGrimmer11-Dec-07 5:20 
GeneralDynamic loading of Webusercontrol..... Pin
zareee10-Dec-07 23:24
zareee10-Dec-07 23:24 
GeneralRe: Dynamic loading of Webusercontrol..... Pin
ltom10-Dec-07 23:59
ltom10-Dec-07 23:59 
GeneralProblem with UpdatePanel and PlaceHolder Pin
amin_behzadi10-Dec-07 23:15
professionalamin_behzadi10-Dec-07 23:15 
Questionhow to populate a DropDownList from a self joined table? Pin
Rocky#10-Dec-07 23:01
Rocky#10-Dec-07 23:01 
Generalshowing data in crystal report using dataset dynamically Pin
pavankumarchakilam10-Dec-07 22:50
pavankumarchakilam10-Dec-07 22:50 
GeneralList of controls Pin
Mazdak10-Dec-07 22:36
Mazdak10-Dec-07 22:36 
GeneralRe: List of controls Pin
Karthic M11-Dec-07 0:42
Karthic M11-Dec-07 0:42 
GeneralRe: List of controls Pin
Mazdak11-Dec-07 1:08
Mazdak11-Dec-07 1:08 
Generalshowing of data in Crstal report Pin
wasimsharp10-Dec-07 21:58
wasimsharp10-Dec-07 21:58 
GeneralSmallest Unit in .NET [modified] Pin
.NET- India 10-Dec-07 21:48
.NET- India 10-Dec-07 21:48 
GeneralRe: Smallest Unit in .NET Pin
Vasudevan Deepak Kumar10-Dec-07 21:56
Vasudevan Deepak Kumar10-Dec-07 21:56 
GeneralRe: Smallest Unit in .NET Pin
.NET- India 10-Dec-07 21:58
.NET- India 10-Dec-07 21:58 
GeneralRe: Smallest Unit in .NET Pin
Colin Angus Mackay10-Dec-07 22:55
Colin Angus Mackay10-Dec-07 22:55 
GeneralRe: Smallest Unit in .NET Pin
Christian Graus10-Dec-07 22:08
protectorChristian Graus10-Dec-07 22:08 
GeneralRe: Smallest Unit in .NET Pin
.NET- India 10-Dec-07 22:31
.NET- India 10-Dec-07 22:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.