Click here to Skip to main content
15,914,488 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionHow to pop up a web form as a modal dialog box?? Pin
kvPriya20-Jun-06 19:46
kvPriya20-Jun-06 19:46 
AnswerRe: How to pop up a web form as a modal dialog box?? Pin
varshavmane20-Jun-06 20:33
varshavmane20-Jun-06 20:33 
GeneralRe: How to pop up a web form as a modal dialog box?? Pin
Vasudevan Deepak Kumar21-Jun-06 0:20
Vasudevan Deepak Kumar21-Jun-06 0:20 
QuestionDisplay info in a process Pin
miftha20-Jun-06 19:35
miftha20-Jun-06 19:35 
QuestionAre You Stored Procedure Savvy.......... Pin
Nagraj Naik20-Jun-06 19:27
Nagraj Naik20-Jun-06 19:27 
AnswerRe: Are You Stored Procedure Savvy.......... Pin
Edbert P20-Jun-06 20:01
Edbert P20-Jun-06 20:01 
GeneralRe: Are You Stored Procedure Savvy.......... Pin
Nagraj Naik20-Jun-06 20:20
Nagraj Naik20-Jun-06 20:20 
GeneralRe: Are You Stored Procedure Savvy.......... Pin
Edbert P20-Jun-06 20:31
Edbert P20-Jun-06 20:31 
Oh! If you're going to use the sp_executesql you do not need the single quote between the @KeySkills.
And you're missing the WHERE clause after your SELECT statement.
Try this instead:
set @Where = ''
set @Select ='SELECT KeySkills FROM Jobseeker WHERE 1 = 1 '

if(@KeySkills is not NULL )
begin
<code>set @Where = ' AND KeySkills = @KeySkills '</code>
set @Select = @Select + @Where              /* Resulting in SELECT KeySkills FROM Jobseeker WHERE 1 = 1 AND KeySkills = @KeySkills */

SET @paramlist = '@KeySkills nvarchar(50)'  /* You need to specify all the parameters you use */

<code>EXEC sp_executesql @Select, @paramlist, @Keyskills</code>   /* You need to pass not only the sql statement, but the parameter list and the parameter value itself */


Hope that one works.

"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross

Edbert
Sydney, Australia
GeneralRe: Are You Stored Procedure Savvy.......... Pin
Nagraj Naik20-Jun-06 20:51
Nagraj Naik20-Jun-06 20:51 
AnswerRe: Are You Stored Procedure Savvy.......... Pin
Vasudevan Deepak Kumar21-Jun-06 0:22
Vasudevan Deepak Kumar21-Jun-06 0:22 
QuestionPopup window on button click and fetching the value back [modified] Pin
Varun Arora20-Jun-06 19:15
Varun Arora20-Jun-06 19:15 
AnswerRe: Popup window on button click and fetching the value back Pin
varshavmane20-Jun-06 20:35
varshavmane20-Jun-06 20:35 
GeneralRe: Popup window on button click and fetching the value back Pin
Varun Arora21-Jun-06 19:38
Varun Arora21-Jun-06 19:38 
GeneralRe: Popup window on button click and fetching the value back Pin
_AK_21-Jun-06 19:48
_AK_21-Jun-06 19:48 
QuestionUser Control Error Pin
dotnetquery20-Jun-06 18:49
dotnetquery20-Jun-06 18:49 
AnswerRe: User Control Error Pin
Edbert P20-Jun-06 20:37
Edbert P20-Jun-06 20:37 
GeneralRe: User Control Error Pin
dotnetquery20-Jun-06 20:53
dotnetquery20-Jun-06 20:53 
Questioncapturing RAISERROR message in the front end Pin
sishya20-Jun-06 18:12
sishya20-Jun-06 18:12 
AnswerRe: capturing RAISERROR message in the front end Pin
Nagraj Naik20-Jun-06 20:04
Nagraj Naik20-Jun-06 20:04 
Generalpls tell how to capture this Message from frontend interface Pin
sishya20-Jun-06 23:18
sishya20-Jun-06 23:18 
GeneralRe: pls tell how to capture this Message from frontend interface Pin
Nagraj Naik21-Jun-06 2:56
Nagraj Naik21-Jun-06 2:56 
Questionstop pop up Authentication window in asp.net Pin
R_raghu20-Jun-06 17:58
R_raghu20-Jun-06 17:58 
AnswerRe: stop pop up Authentication window in asp.net [modified] Pin
Edbert P20-Jun-06 19:49
Edbert P20-Jun-06 19:49 
Questionhaving flash menu button in asp Pin
campbells20-Jun-06 16:53
campbells20-Jun-06 16:53 
QuestionPoll : average ASP.NET form dev time? Pin
Tillman Erb20-Jun-06 10:37
Tillman Erb20-Jun-06 10:37 

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.