ASP.NET

About asp.net system slowdown

15-Dec-09 9:32

Good thinking...

The way we all do in your scenario is we put a variable in session,and try to call the Variable. Say:
Session.Add("IsAuthenticated", true)

Now for every call to the server we validate this using
if(Session["IsAuthenticated"])

If Session cant be retrieved, we will see if the current request url is Login page. If not we pass it to Login using

login.aspx?RetUrl=yourcurrentpage.aspx

Thus if the user successfully logs in again, it will be redirected to original page.
And regarding Session Timeout exception, we just ignore it using try/catch.

This is our way of doing this, as we handle all of them in Server.

Well, if you like to handle this is client, It is better to keep a variable variable in Javascript which will hold the time when the last call is made. You might use this javascript in OnLoad event of Body.

var responsetime = new Date();

Now whenever any call to the server is made, you just use

var thisTime = new Date();
var difftime= new Date();
difftime.setTime(thisTime.getTime() - responsetime.getTime());
if(difftime.getMinutes() > 20){
  alert('Session Expired');
  location.href='login.aspx';
  return false;
}
else
  return true;

I hope this would seem to be a better approach to you.

Cheers.
Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

leone15-Dec-09 6:06

leone

15-Dec-09 6:06

Hello. I am uploading a video file to a remote server. After that i am converting it to flv file. This process may last upto 10 minutes depending on file size. If i show such label " Preview file is being prepared. Please wait." , there is no problem. But i dont want such an unneccesary delay, and to process it at background. So i wanted to place a link "Click to return to homepage." or auto redirect to homepage. But page didnt load until the process finished. How can i deal with this problem.

Re: About asp.net system slowdown

Abhijit Jana15-Dec-09 6:22

Abhijit Jana

15-Dec-09 6:22

How you are uploading file on server ? Are you using AJAX any where for it ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: About asp.net system slowdown

Abhishek Sur15-Dec-09 7:17

Question about writing a conditional SQL statement

15-Dec-09 7:17

Create an IFrame and upload the file from there. This will not affect the page to full postback. Show the message there.

And also if possible make an ajax call to the server, form the mail application, to detect how much data is been uploaded to the server till now and detect appropriate message.

Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

James Shao15-Dec-09 4:28

James Shao

15-Dec-09 4:28

I have a time series data in which a numerical indicator fluctuates over time. If I want to find out for which given day, this indicator has crossed above 30 in the past 3 days. Is it possible to write a SQL query that retrieve this information?

The logic to check for the crossing movement is:

IF indicator(day x) > 30 AND indicator(3 days ago from day x) <30 THEN
Return "YES WE HAVE AN UPWARD CROSSING MOVEMENT THROUGH 30 FOR PAST 3 DAYS!"
END IF

Can this be accomplished using a SQL CASE statement with a HAVING clause or something else?

I'd greatly appreciate any help! If possible please provide a sample code Poke tongue | ;-P

By the way I really want to thank you guys for helping me recently... Smile | :)

Re: Question about writing a conditional SQL statement [modified]

dan!sh 15-Dec-09 5:00

Re: Question about writing a conditional SQL statement

15-Dec-09 5:00

~~This question will be best suited in the General database forum. Please make sure to post in correct forum from now on.~~
Just saw you have posted it there as well. Do not cross post. It is considered rude.

Assuming, your database fields are called indicator and date, try this:

select indicator from yourTable where indicator > 30 and datediff(date, getdate(),date) <= 3

if(@@rowcount > 0)
select 1
select 0

(not sure about order of getdate and date in datediff, you can check that through the query though)

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

modified on Tuesday, December 15, 2009 11:08 AM

James Shao15-Dec-09 12:43

James Shao

15-Dec-09 12:43

Thanks a lot for your help D@nish, sorry about cross-posting.

Re: Question about writing a conditional SQL statement

James Shao15-Dec-09 15:50

James Shao

15-Dec-09 15:50

Hi D@nish, the above query doesn't seem to take the condition of [indicator from 3 days ago which is less than 30] into account....

For instance, my table contains two columns:

Date-------------Indicator Value
12/16/2009-------45
12/15/2009-------33
12/14/2009-------29
12/13/2009-------23
12/12/2009-------27
12/11/2009-------35
12/10/2009-------29
12/9/2009--------24
...
...

I want to find out for which date, the indicator value had crossed from below 30 three days before to above 30. The answers are: "12/16/2009" and "12/11/2009". How should I contruct the query to do so?

Many thanks again.

Re: Question about writing a conditional SQL statement

dan!sh 15-Dec-09 17:06

15-Dec-09 17:06

James Shao wrote:
The answers are: "12/16/2009" and "12/11/2009".

12/15 should also come. Right? 12/13 is less than 30 and 12/15 is more.

I hope this should work.

select tbl1.date as fromDate,tbl2.date as toDate, tbl1.indicator as fromValue, tbl2.indicator as toValue from yourtable tbl1, yourtable tbl2 where tbl1.indicator < 30 and tb12.indicator > 30 and datediff(date,tbl1.date,tbl2.date) = 2

(I have not tested the query so it may give some error)

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

XPATH problem

Rohit16db15-Dec-09 3:22

Rohit16db

15-Dec-09 3:22

Hi guys,

I have a xml document as below and in Xslt I need to get the person name on the basis of email id as in below xml file , contributor node contain email id and associated name is included in Epic node can any body help me to get the name for each contributor through xpath?

<ONIXMessage>
<Product>
   <Contributor>
   <Email>Rohit@gmail.com</Email>
</Contributor>

</Product>
<Product>
   <Contributor>
   <Email>Rohit@gmail.com</Email>
</Contributor>

</Product>
<Epic>
<Person>
   <Name>Rohit</Name>
   <Email>Rohit@gmail.com</Email>
</Person>
</Epic>

</ONIXMessage>

Re: XPATH problem

Abhishek Sur15-Dec-09 10:30

15-Dec-09 10:30

Rohit16db wrote:
person name on the basis of email id as in below xml

Why Duplicate entry for Product->contributor->Email

XSLT is used to transform your xml into XHTML. You can easily move into some node decendant to the current one using XPath.

Tell me what exactly you require.

See
http://www.w3schools.com/xsl/[^]

for reference.

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Page updating

#realJSOP15-Dec-09 0:59

15-Dec-09 0:59

I have some controls (placeholders) that I'm trying hide/show, and a button that I want to enable/disable when the button is clicked, but none of that stuff is happening. What am I not doing?

I'm doing this (both panels are hidden by default, and the button is enabled by default:

protected void buttonRetrieveData_OnClick(object sender, EventArgs e)
{
    // this stuff is NOT happening   <----------
    this.WaitPanel.Visible = true;
    this.OutputPanel.Visible = false;
    this.buttonRetrieveData.Enabled = false;
    try
    {
        blah blah blah...
    }
    catch (Exception ex)
    {
        if (ex != null) { }
    }
    finally
    {
        // this stuff IS happening - WTF?! <--------------
        this.WaitPanel.Visible = false;
        this.OutputPanel.Visible = true;
        this.buttonRetrieveData.Enabled = true;
    }
}

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Eduard Keilholz15-Dec-09 1:08

Eduard Keilholz

15-Dec-09 1:08

Does the code run (is the event being fired?)

Is the button RetrieveData in an Ajax Update panel?

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

#realJSOP15-Dec-09 3:14

15-Dec-09 3:14

Eduard Keilholz wrote:
Does the code run (is the event being fired?)

Yes, it does. I even tried putting the code (that doesn't work) into the Page_Load method thinking maybe it should go there instead, but that had no effect.

Eduard Keilholz wrote:
Is the button RetrieveData in an Ajax Update panel?

No. The panels are PlaceHolder controls.

dan!sh 15-Dec-09 1:27

15-Dec-09 1:27

John Simmons / outlaw programmer wrote:
this.WaitPanel.Visible = true;
this.OutputPanel.Visible = false;
this.buttonRetrieveData.Enabled = false;

John Simmons / outlaw programmer wrote:
this.WaitPanel.Visible = false;
this.OutputPanel.Visible = true;
this.buttonRetrieveData.Enabled = true;

Aren't these contradictory? Whatever the case maybe, end result will be what is there in finally block. Isn't it?

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

#realJSOP15-Dec-09 3:10

15-Dec-09 3:10

The intent is that when the button is clicked, the wait panel is displayed, the output panel is hidden, and the button that fired the event is disabled. When the process is finished, the wait panel is hidden, the output panel is displayed, and the button is re-enabled.

The finally block merely ensures that the controls are returned to the desired state, no matter what happens in the try block.

I don't see how the code I posted is contradictory.

dan!sh 15-Dec-09 3:28

15-Dec-09 3:28

John Simmons / outlaw programmer wrote:
I don't see how the code I posted is contradictory

I was thinking the other way. After the event the result will always be the same.

I don't think it will work (not among the even decent ASP.Net guys so may be wrong). Since the page will not be rendered during the phase where event is getting executed. I would rather employ a javascript function which make the panels visible/hidden before the server side event is fired and then in the event hide them.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

#realJSOP15-Dec-09 3:42

15-Dec-09 3:42

Well, I did try moving the first block into the Page_Load method, but that didn't help at all...

dan!sh 15-Dec-09 4:54

15-Dec-09 4:54

That will not help. In fact if it is a full postback, nothing will. Since during the event is during executed, the page will not be rendered in the browser.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

#realJSOP15-Dec-09 3:45

15-Dec-09 3:45

The process that is contained in the button event is fairly long, and I was considering moving it into a thread, which would be responsible for changing the controls back upon completion. Maybe that's ultimately the answer...

dan!sh 15-Dec-09 4:53

15-Dec-09 4:53

I assume you would have, but still I would suggest. Have you thought about having that button in a update panel and and using update panel animator? It would give a better look.

(Here I am assuming that WaitPanel must be something like those loading/working kind gifs)

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

#realJSOP15-Dec-09 5:07

15-Dec-09 5:07

d@nish wrote:
Have you thought about having that button in a update panel and and using update panel animator? It would give a better look.

I don't know what that is...

d@nish wrote:
(Here I am assuming that WaitPanel must be something like those loading/working kind gifs)

Yeah, it is.

dan!sh 15-Dec-09 5:14

15-Dec-09 5:14

This[^] should help. And this[^] link for UpdateProgress control (sorry for incorrect control name in earlier post).

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Abhishek Sur15-Dec-09 4:23