|
|
I have a process to be run at the end of year in a leave management system. The process is started when the start process button is pressed, I need to show the employee number currently been processed in a label or a text box. What i did was i gave (Ex : text1.text = tabel(0).row(0).item(0)) when the record is bean read in the for loop. but it shoes only the last record in the process because the processing bar in the page was activated while the process is on. Is there another way to show the record that is being processed in the text box.
Thanx 
AMIF
|
|
|
|
|
Hi All,
I am creating dynamic stored procedure,means quuery condition is depending runtime supplied parameter values.
stored procedure is given below.
ALTER PROCEDURE GetSearchCriteria
@KeySkills nvarchar(50),
AS
Declare @Select nvarchar(2000)
declare @Where nvarchar(2000)
set @Where = ''
set @Select ='Select KeySkills from Jobseeker'
/*set @Select ='Select * from jobseeker'*/
if(@KeySkills is not NULL )
begin
set @Where = ' KeySkills = ' + @KeySkills end
set @Select = @Select + @Where
EXEC (@Select)
It gives error at statement in bold
Incorrect syntax near '='.
Regards,
|
|
|
|
|
KeySkills expects nvarchar, so the code should be
set @Where = ' KeySkills = ''' + @KeySkills + ''''
The '' above are two single quotes.
However, after saying that, you should use sp_executesql instead which to execute your dynamic sql, which accepts the following parameter:
EXEC sp_executesql @sqlString, @paramlist, [@param1], [@param2], ...
@sqlString example is 'SELECT * FROM tblA WHERE KeySkills = @KeySkills'
@paramlist is a list of parameters your sqlString requires, e.g.
SET @paramlist = '@KeySkills nvarchar(50), @Param2 nvarchar(50)'
@param1 to @paramN are your parameter values, it has to correspond to the exact ordering in @paramlist (e.g. @KeySkills have to be passed as first parameter).
Hope that helps.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
Hi Edbert,
As you suggest I made changes But Error is still coming on same line.
If possible please run this query at your end and correct it accordingly.
ALTER PROCEDURE GetSearchCriteria
@KeySkills nvarchar(50)
AS
Declare @Select nvarchar(2000)
declare @Where nvarchar(2000)
set @Where = ''
set @Select ='Select KeySkills from Jobseeker'
if(@KeySkills is not NULL )
begin
/* set @Where = ' KeySkills = ' + @KeySkills */
set @Where = ' KeySkills = ''' + @KeySkills + ''''
end
set @Select = @Select + @Where
EXEC sp_executesql @Select
RETURN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
|
|
|
|
|
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
SET @paramlist = '@KeySkills nvarchar(50)'
<code>EXEC sp_executesql @Select, @paramlist, @Keyskills</code>
Hope that one works.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
Hi,
Thanks A lot.
I hope we will meet again with new discussion.
Regards,
Nagraj
Let's Teach Life To Laugh........
|
|
|
|
|
|
Urgent
Hi all,
I have a textbox and a button with it. I want on clicking the button , a popup window should open. And after selecting record from popup window it should fill the value in the textbox of previous page.
Suggestions and links are welcome.
Regaruds,
Varun Arora,
Software Engineer,
Knowledge Calls,
Gurgaon, India
-- modified at 1:40 Thursday 22nd June, 2006
|
|
|
|
|
Can u please tell me u want popup on Button click or textbox click???
|
|
|
|
|
Button Click
Varun Arora,
Software Engineer,
Knowledge Calls,
Gurgaon, India
|
|
|
|
|
You can do like this.
this will be there in codebehind page.
Button1.Attributes.Add( "onclick", "popWin()" );
and this in the html part.
<script><br />
function popWin(){<br />
window.open('http://msdn.microsoft.com', '', '');");<br />
}<br />
</script>
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have a created a user control which on compilation gives no error. BNut when I try to use this control on my web page gives me an error which sayd "Error creating user control" When I try to get the details of the error it says "Parse Error: Type "'System.Web.UI.UserControl' does not have a property named 'Title'". But I do have a property named Title in my user control. So what is the error. Can anyone help me out.
|
|
|
|
|
UserControl class already has a property named Title.
Make sure you don't override it with a new property in your custom user control that is private or protected, as it is probably called in the designer code.
Hope that helps.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
Well 'Title' was just an example. It is giving me an error for all of my properties like 'TitleBarLeft' and 'TitleBarRight' etc.
|
|
|
|
|
Hi ,
I have created a logic in stored procedure and in it i look if a variable satisfies certain condition ,if it doesn't i want to raiseerror with appropriate message.Pls tell me how to know if the error has occurred and capture the msg in the frontend.Pls let me know also the right syntax for
writing msgs in RAISERROR .
thnks in advance
|
|
|
|
|
Hi Sishya,
I am explaining RAISERROR syntax by simple example.Modify it as your need.
ALTER procedure sp_AddUsers
@UserID varchar(20)
as
if @UserID=''
Begin
Raiserror('Missing User ID.',16,1)
return(0)
End
Begin Transaction
insert into Users (UserID)
values(@UserID)
Commit Transaction
Regards,
Nagraj
Let's Teach Life To Laugh........
|
|
|
|
|
hi ,
pls tell how to capture this Message in raise error from frontend interface and what about the 16,1 in Raiserror('Missing User ID.',16,1)
|
|
|
|
|
Hi sishya,
16,1 are savirity,status parameters for RAISERROR procedure.Don't think much about then you can get details on net regrading this.
As your core problem To access this RAISEERROR return value....here is code.
private void someMethod()
{
try
{
// Do a RAISERROR inside of a SQL block like
// RAISERROR('You did something wrong with the value "%s"', 16, 1, @param1)
}
catch (SqlException sqle)
{
lblMessage.Text = sqle.Message;
}
catch (Exception err)
{
// Do something else with the exception
}
}
I hope this will help you.
Regards,
Nagraj
Let's Teach Life To Laugh........
|
|
|
|
|
Hi
I have one Web application where I have used window authentication, so every time when user access application popup window will come for userid/password.
Till now there is no problem. Now within same application I have some new page which needs no authentication means Anonymous user can access.
i do not want to use IIS 'Anonymous Access' for whole application.
is it possible we can pass authentication credential by page .
Plz advice me what code I have to write in new page so any one can access these page
Raghvendra Raghuwanshi
|
|
|
|
|
You can simply put your pages in a different web folder and place a web.config file on that particular folder which allows anonymous access (see below). Also if I'm not wrong you can set specific permission to folders from IIS.
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</configuration>
Odd...the pre tag didn't preserve the < and >
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
-- modified at 1:51 Wednesday 21st June, 2006
|
|
|
|
|
i planning to put the flash button menu for my site.
but normaly i use frame so the button will have some effect like show submenu. but i found out many asp website dont really use frame because when user trying to scoll down the side frame will always fix there.
but if i use the global thing to fix all my page same as the first page... then my button will always at the beginning part... which i mean in 1 page the user click on the Product button then submenu come out then when user click another time will bring to other page, which the button will not show the submenu of product... user have to reclick again~??
1st page: product->submenu
2rd page:Product (i want to remain wat the user have done in 1st page which is product->submenu...)
|
|
|
|
|
Does this sound familiar to anyone: You're faced with reviewing a spec for a large project and you're trying to come up with a ball park estimate. A common approach (usually combined with others) is to count the number of screens or forms that the project requires. Multiply that by some average number of hours you think it takes to do an ASP.NET form and you've got some starting point for your ball park estimate.
Remember the goal is a superficial review and estimate with the understanding that there may be a large margin of error after a closer analysis of the spec.
So what number do you use for the average number of hours to code an ASP.NET form (1.x or 2.0)? Assume both page and code-behind programming, but not design/CSS, etc.
Just curious...
|
|
|
|
|
because i like to build whole apps in one page(lots of panels).
|
|
|
|
|
What I usually do when estimating is think of a project as similar as posibile with the one I need to estimate. And depending on the complexity add or remove hours to the estimation.
If there's no comparison type, depending of the complexity of the pages: between 1 and 5 hours.
Don't also forget to add some extra hours if your building a n-tier architecture. You need time for BLL, DAL also database design and implementation.
What I usually do is add another 30% extra hours over the estimation. This gives you a good advantage in case you estimated incorectly some tasks.
Well, this is me. If anyone has any recomendations, let me know. There's room for improvement for me too.
regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
