ASP.NET

Abubakarsb7-Aug-07 21:52

Abubakarsb

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

Abubakarsb

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

System.Resources.MissingManifestResourceException

Abubakarsb10-Aug-07 5:02

Abubakarsb

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

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

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

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

Christian Graus7-Aug-07 20:33

Christian Graus

7-Aug-07 20:33

AJAX is just javascript. The odds of there being a non js solution are close to zero.

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 )

Michael Sync7-Aug-07 22:15

Michael Sync

7-Aug-07 22:15

Have you tested in Firefox (latest version)? It works well as the way you want without changing anything. but it doesn't work in IE6.

I'm looking for the solution for you.. I will let you know once done.

Hari_10107-Aug-07 22:21

7-Aug-07 22:21

Hi Michael,

I dont have firefox in my system. Thanks for your help michael. Let me know if you find the solution for me.

Thanks and Regards,
Hariharan C

Hari_10108-Aug-07 1:52

8-Aug-07 1:52

Hi Michael,

Yes its working fine in firefox. But its there any other way to make it work in IE. If you got the solution let me know it.

Thanks and Regards,
Hariharan C

Michael Sync8-Aug-07 7:42

Michael Sync

8-Aug-07 7:42

Hello Hariharan,

I just arrive at home and I remember your question that I don't have enough time to figure out the solution.. So, I opened my page and I'm trying to reproduce this issue. Now, I have tested with Internet Explorer 7, Firefox 2.0.0.6, Opera 9.2 and Safari 3.0.3. It is working fine in all those browsers except internet explorer 6. I don't have this one in my laptop. I tried to install IE6 standalone version that can run with IE7 on same machine but that installer doesn't work on Windows Vista. Frown | :(

Anyway, I'm gonna give you some codes that I think it should work on IE6.

<script language="javascript" type="text/javascript"><br />
      var pressedKeyString = "";<br />
      var delay = 1000;<br />
      var timeID = null;<br />
      function move(id){<br />
        <br />
        var selectList = document.getElementById(id);<br />
        var arr = new Array();<br />
        <br />
        var idx = 0;<br />
        <br />
        for(var i = 0; i < selectList.options.length-1; i++){           <br />
           if(selectList.options[i].value.length >= pressedKeyString.length){<br />
             if(pressedKeyString.toLowerCase() == selectList.options[i].value.substring(0,pressedKeyString.length).toLowerCase()){<br />
                 selectList.options[i].select = true;                                  <br />
                 i=selectList.options.length;                                  <br />
             }<br />
           }                      <br />
        }<br />
        <br />
        //pressedKeyString = "";<br />
      }<br />
      <br />
      function foo(e,id){<br />
        if(timeID != null)clearTimeout(timeID);<br />
        timeID = setTimeout("move('" + id + "');",delay);<br />
        <br />
        var key;<br />
        if(window.event) // IE<br />
        {<br />
           key = e.keyCode<br />
        }<br />
        else if(e.which) // Netscape/Firefox/Opera<br />
        {<br />
           key = e.which<br />
        }        <br />
        <br />
        var pressKey = String.fromCharCode(key);<br />
        pressedKeyString += pressKey;           <br />
        <br />
      }<br />
      <br />
    </script>

 protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        DropDownList1.Attributes.Add("onkeypress", "foo(event,'" + DropDownList1.ClientID + "');");<br />
<br />
        List<string> list = new List<string>();<br />
        list.Add("Alien");<br />
        list.Add("Emos");<br />
        list.Add("Poker");<br />
        list.Add("Peter");<br />
        list.Add("Michael Sync");<br />
        list.Add("Petro");<br />
        list.Add("Pet");<br />
        list.Add("Elizabeth");<br />
<br />
        DropDownList1.DataSource = list;<br />
        DropDownList1.DataBind();<br />
    }

The main idea of this code is that we will enable the timer to check whether the user is still typing or not. The timer will get clear as long as the user keep on typing. If the user stop then the timer will count 1000 minisecound and will invoke the Move function. In that function, we will do some string comparison to find whether there is any item which is started with the string that the user type or not. If we found the matched string then we will make this item as a selected item..

this is the idea. I'm not so sure whether it gonna work without error or not since I haven't tested yet and I don't have IE6 installed in my machine. For the time being, you can do some modifications to this code if you interest the idea. I will test my script for you tomorrow because the machine from my office has IE6 installed.

Anyway, what I like to suggest you is that if the particular thing works on main browsers except IE6, you should not spend so much time for finding the solution ...

Hari_10108-Aug-07 20:49