ASP.NET

7-Aug-07 21:19

Good Morning,

Is it possible to fire an event when user closes the browser window in javascript or any other language? Please help.

I have user a login system in my project which is being made in asp.net 2.0. I want that when user closes the browser window it should logout autmatically. If anyone of you knows about it please guide me. Thanks.

waiting for reply. Bye.

Abubakar

SHatchard7-Aug-07 21:28

SHatchard

7-Aug-07 21:28

I saw an good article the other day on handing browser close events on the server side

http://aspalliance.com/1294_CodeSnip_Handle_Browser_Close_Event_on_the_ServerSide[^]

Hope it helps

Abubakarsb7-Aug-07 21:52

7-Aug-07 21:52

Thanks for reply.

I don't think it could be solution becaue "onunload" function will be called every time even user moves to another page by clicking a link then user will be logout which is not right. what do u think?

Sonia Gupta7-Aug-07 22:33

Sonia Gupta

7-Aug-07 22:33

hi there
ca u provide the link other then ajax
thanQ

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

N a v a n e e t h7-Aug-07 22:52

N a v a n e e t h

7-Aug-07 22:52

Abubakarsb wrote:
I want that when user closes the browser window it should logout autmatically.

Session will have some timeout specified. It will end after that time. So no need to end it explicitly when user closes browser. And I don't think that doing this using javascript will be a good solution, because if javascript is disabled on user browser, your script won't work. Are you updating any value in database when user logs out ?

My Website | Ask smart questions

Vasudevan Deepak Kumar7-Aug-07 23:29

Vasudevan Deepak Kumar

7-Aug-07 23:29

N a v a n e e t h wrote:
Are you updating any value in database when user logs out ?

Check out this article if you are depending on Session_OnEnd for your logic:

http://www.eggheadcafe.com/articles/20030418.asp[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

N a v a n e e t h7-Aug-07 23:39

N a v a n e e t h

7-Aug-07 23:39

Vasudevan Deepak Kumar wrote:
Check out this article if you are depending on Session_OnEnd for your logic:

Yes read that more than 3 times, all from your message only. But I didn't had any problem with firing session_end event. It works perfectly for me. I feel in article they are concentrating on webfarms, and this thread starter has not told that he is using a webfarm. He may be using InProc, and for that session_end will easy and optimum ? What do you say ?

My Website | Ask smart questions

Abubakarsb7-Aug-07 23:48

7-Aug-07 23:48

No, I am not updating any value. I am just logging out of user from the system. The problem is sometimes when I close the browser it loged out user but when I try to relogin again with same username it says "User is currently Login"

N a v a n e e t h7-Aug-07 23:54

N a v a n e e t h

7-Aug-07 23:54

Abubakarsb wrote:
it says "User is currently Login"

How you are checking this ? That's what I asked are you storing any values to identify whether user is online ?

My Website | Ask smart questions

Abubakarsb10-Aug-07 5:02

System.Resources.MissingManifestResourceException

10-Aug-07 5:02

Sorry guys! I was really busy with other parts of my project. Regarding to your question

"How you are checking this ? That's what I asked are you storing any values to identify whether user is online ? "

The thing is I am new in Visual Studio 2005 (Asp.net 2.0) and a developer already made this, I am just updating it. I don't have any idea how new login system works in VS2005. I really don't know how he is storing or checking that whether user is login or not?

He made a commonMaster page and I have found a check please check code below, may be it helps you to understand my problem, if you still need more please don't hasitate. I want to fix this soon. Thanks.

if (Properties.IsLoggedIn)
{
string cookieName = FormsAuthentication.FormsCookieName;
HttpCookie authCookie = Context.Request.Cookies[cookieName];
FormsAuthenticationTicket authTicket = FormsAuthentication.Decrypt(authCookie.Value);

MembershipUser mu = Membership.GetUser();
Properties.EndUserGUID = mu.ProviderUserKey.ToString().ToUpper();

DateTime expiration = authTicket.Expiration.AddSeconds(-90);
if (expiration < DateTime.Now)
{
mu.LastLoginDate = DateTime.Now;
Membership.UpdateUser(mu);
FormsAuthentication.SetAuthCookie(Context.User.Identity.Name, true, "/");
}
}

sankar.K7-Aug-07 20:32

sankar.K

7-Aug-07 20:32

resources = new System.Resources.ResourceManager("SharpWebMail", System.Reflection.Assembly.GetExecutingAssembly());

The resources are not getting loaded and i am getting the error when i access the resources the following way

Session["resources"] = resources.GetResourceSet(invariant, true, true);

Transfer data from CSV to Sql Server 2005!!

shweta@syscom7-Aug-07 20:28

shweta@syscom

7-Aug-07 20:28

Hi,

I want to copy the data in a csv to sqlserver 2005 database.
Please help me in this regard.

Data in csv is in this format:
"1","Sa","New Aol","America,NY",""

Thanks a lot!!

SHWETA!!

Re: Transfer data from CSV to Sql Server 2005!!

sulabh20207-Aug-07 23:19

sulabh2020

7-Aug-07 23:19

Hi shweta, may i know u want to copy the data through soem programming source or directly through sql server 2005.

Hello Forum
Always be in touch to help about the topic ASP.NET

Re: Transfer data from CSV to Sql Server 2005!!

sulabh20207-Aug-07 23:29

sulabh2020

7-Aug-07 23:29

I have the solution with me thriugh programming.

u can mail me at personalmail@mysampatti.com

Hello Forum
Always be in touch to help about the topic ASP.NET

Re: Transfer data from CSV to Sql Server 2005!!

shweta@syscom8-Aug-07 0:49

shweta@syscom

8-Aug-07 0:49

yes.. I want to transfer data using ASP.NET (C#).

If you can then please post the code here..

Thanks a lot!!..

SHWETA!!

Treeview control

Brendan Vogt7-Aug-07 20:06

Brendan Vogt

7-Aug-07 20:06

Hi,

I am using SQL Server's full text search capability.

Please go and look at what I currently have at:
http: http://beta.redpepperbooks.co.za.shopdirect.co.za/PowerSearch.aspx (scroll down)

It populates all the categories by default. Alternatively the user can type a piece of text and click the lookup button. Then a do I search for all categories that contains that text, and brings back the category ID, category name, and category parent ID. There might be more than 1 category brought back, and their parent IDs might differ.

What is confusing me is to re-populate the treeview from scratch based on the category ID and parent ID. Lets say the category name(s) brought back is way down in the hierachy how I do not know how "work back" to get the root parent?

Please can some one help??

Regards
ma se
(South Africa)

Requirement in Drop down list

Hari_10107-Aug-07 19:54

Hari_1010

7-Aug-07 19:54

Hi all,

There is a small requirement in drop down list. Suppose I have bounded the employee names to the drop down list. Now I am searching for a name “Peter”. So if I press ‘p’ and then ‘e’ it should go to Peter’s name. But it goes to Elizabeth’s name. Is there any solution for that? Could anyone of you please help me on that? I am using .Net version 2.0

Thanks and Regards,
Hariharan C

Christian Graus7-Aug-07 20:09

Christian Graus

7-Aug-07 20:09

It always goes based on the first key you pressed, there are probably custom controls out there that do what you want, but the standard one, does not

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Hari_10107-Aug-07 20:12

Hari_1010

7-Aug-07 20:12

So if there is any custom controls you can help me.

Thanks and Regards,
Hariharan C

Michael Sync7-Aug-07 20:11

Michael Sync

7-Aug-07 20:11

I suggest you to use Ajax AutoComplete (something like Google suggest) instead of using dropdown list.
eg:

Creating a Textbox with JavaScript Auto-Complete[^]

http://www.codeproject.com/aspnet/AJAXWasHere-Part3.asp[^]

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

Hari_10107-Aug-07 20:16

Hari_1010

7-Aug-07 20:16

Hi Michael,

I know there is a solution in Ajax. But if i select Ajax, then i will find difficult to implement in my project. So is there any solution without using Ajax.

Thanks and Regards,
Hariharan C