Tracking Current Web Sessions - C# Discussion Boards

Databinding with combobox as 'lookup' table

Rajendra Rana3-Feb-06 8:13

3-Feb-06 8:13

There are 6 comboboxes used on the Form, each combobox should be bind with sql server datasource with particular Table having six fields.After selection of each combobox one by one the output comes as appended string in Label .
as
ans of combobox1-ansof combobox2-.....- ans of combobox6
I want to bind combobox with sql server datasource ,using stored procedures how can i start with...?

Raj

how to create registry objects of Skype (TM)

Sasuko3-Feb-06 8:07

Sasuko

3-Feb-06 8:07

If you open Registry Tab of Skype program, you can see a list of the same controll repeated much time.
It contain an image, a label and sometime a linklabel.
On the right side there is a scrollbar.
So how can i create controlls like that? Is it overloaded a simple multiline textbox or what?

thanks if someone try with me to get an answer Smile | :)

Excel Borders Problem

FreewareFire3-Feb-06 6:26

FreewareFire

3-Feb-06 6:26

Hi!

I'm looking for some help - i'm using the COM Excel Spreadsheet, Version 11 and actually i'm trying to set the borders of an cell. But it fails every time - i've looked around one day for a solution - nothing - i get something like that...

Property, indexer, or event 'LineStyle' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Owc11.Borders.get_LineStyle()' or 'Microsoft.Office.Interop.Owc11.Borders.set_LineStyle(Microsoft.Office.Interop.Owc11.XlLineStyle)

What does that mean - can someone provide some code for this...

i'm using Microsoft.Office.Interop.Owc11 - because the com object as well uses Interop and not excel...

Thanks...

Ralf Frown | :(

FreewareFire

Re: Excel Borders Problem

Douglas Troy3-Feb-06 6:42

Douglas Troy

3-Feb-06 6:42

It means you shouldn't be calling get_LineStyle() directly ... there should be a property accessor available called LineStyle (or maybe just Style) available from the Office and/or Excel Namespace.

:..::. Douglas H. Troy ::..

Bad Astronomy |Development Blogging|Viksoe.dk's Site

Re: Excel Borders Problem

FreewareFire3-Feb-06 12:51

FreewareFire

3-Feb-06 12:51

Hi!

Thanks for answer. But still i can't get it work... I'm using the AxSpreadsheet... from the Office 2003. How can i set the bordes in that control?

Here's my Code:

<br />
Microsoft.Office.Interop.Owc11.Range NewRange = GridIt.get_Range("A1","A2");<br />
<br />
NewRange.Select();<br />
<br />
NewRange.Borders[Microsoft.Office.Interop.Owc11.XlBordersIndex.xlEdgeBottom].LineStyle = Microsoft.Office.Interop.Owc11.XlLineStyle.xlContinuous;<br />

Error occurs at .. .LineStyle = !!!

What should i do?

Greets

Ralf Smile | :)

FreewareFire

-- modified at 18:53 Friday 3rd February, 2006

Re: Excel Borders Problem

Member 42856225-Nov-08 1:49

Member 4285622

5-Nov-08 1:49

Use this...it works NewRange.Borders[Microsoft.Office.Interop.Owc11.XlBordersIndex.xlEdgeBottom].set_LineStyle(Microsoft.Office.Interop.Owc11.XlLineStyle.xlContinuous);

Good Luck Smile | :)

Vikas Pradhan

mouse move and click in any other window

toposte3-Feb-06 5:28

toposte

3-Feb-06 5:28

is there a way to make my program control mouse?
i want it to move mouse pointer and performe some clicks on the active window(any other program running)

Tracking Current Web Sessions

Pualee3-Feb-06 5:08

Pualee

3-Feb-06 5:08

Hey there,

I'm working on a webpage using ASP and C#. At the server, I am tracking all of the live Sessions based on the HttpContext.Current.Session.SessionID value. As you probably know this is a value unique to each web browser accessing my pages.

Now my problem. I would like to know when a user closes the browser and leaves the site (assuming he/she doesn't "log out"). I am hoping to periodically check each SessionID to see if it is still current or expired. Is there a way to load a specific session based on its ID and check to see if it has expired or not?

If it matters, I am using cookies to store the session information.

Thanks in advance,

Pualee

-- modified at 11:10 Friday 3rd February, 2006

P.S. -- Im reading a few books and looking all over the web, but having difficulty finding good information about Sessions (I'm new to Web Development). If you know a good online faq or tutorial, please share the love/url here Poke tongue | ;-P

Re: Tracking Current Web Sessions

Guffa3-Feb-06 6:03

Guffa

3-Feb-06 6:03

Unless you use javascript in the browser to tell the server when the user leaves the page, there is no way that the server can know when this happens. If the user doesn't log out, the server session ends 20 minutes (at default setting) after the last request.

Any information you store in a cookie is only available when a request is made, as the cookie is stored in the browser.

---
b { font-weight: normal; }

Re: Tracking Current Web Sessions

Pualee3-Feb-06 7:12

Pualee

3-Feb-06 7:12

Guffa wrote:
Unless you use javascript in the browser to tell the server when the user leaves the page, there is no way that the server can know when this happens.

I'm not so much worried about the "event" of leaving, I just want to clean up some things periodically...

While still researching this topic, I have come across the following:

System.Web.SessionState.HttpSessionState class
.Count - Gets the number of items in the session-state collection
.Keys - Gets a collection of keys for all the values in the session-state collection

Shouldn't it be possible to loop on the .Keys to compare the active Keys against the keys my application believes are active? This might not be very scalable, but I'm not expecting thousands of users to connect per hour, this is a very specialized application.

I'm going to try this for now, but I'll be rechecking this board for feedback (never know when someone else has the same problem).

Also, would keeping the session data on server side, rather than as cookies, make this possible?

Pualee

Re: Tracking Current Web Sessions

Ravi Bhavnani3-Feb-06 9:42

Ravi Bhavnani

3-Feb-06 9:42

You may want to consider setting a short (< 5 mins.) session timeout on your app and have every page periodically (using JavaScript) retrieve a very small resource (eg: a 1x1 pixel transparent .gif) in an iframe.

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Re: Tracking Current Web Sessions

Guffa4-Feb-06 3:28

Guffa

4-Feb-06 3:28

Pualee wrote:
I just want to clean up some things periodically...

Then use the Session_End event in global.asax.

Pualee wrote:
Shouldn't it be possible to loop on the .Keys to compare the active Keys against the keys my application believes are active?

You are confusing session objects with session variables. Each user has one session object that each can contain several variables. The Session.Keys property contains the keys of the variables that has been stored in the session object for the current user.

The server of course keeps track of the active sessions, but it doesn't expose this list to anyone. Probably because items can be removed from the list at any time.

Pualee wrote:
Also, would keeping the session data on server side, rather than as cookies, make this possible?

That depends. What is it that you store in the cookies anyway?

---
b { font-weight: normal; }

Hard Disk Manufacter Serial Number

Stanciu Vlad3-Feb-06 4:56

Stanciu Vlad

3-Feb-06 4:56

How can I get programaticaly the hard disk's manufacter serial number (not the volume number). If not in c#, even in c would be very usefull.
Thanks

protected internal static readonly ... and I wish the list could continue ...

Re: Hard Disk Manufacter Serial Number

Simon Capewell3-Feb-06 5:54

Simon Capewell

3-Feb-06 5:54

You need to use Google!
http://www.google.co.uk/search?q=hdd%20serial%20number[^]
brings up a CodeProject article in C# within the first 3 results, which in turn has a link in the comments to a C based solution
http://cboard.cprogramming.com/showthread.php?p=427642[^]

Re: Hard Disk Manufacter Serial Number

Stanciu Vlad3-Feb-06 6:14

Stanciu Vlad

3-Feb-06 6:14

Thank you for your interest, but (there is allways a but...) those methods require XP+ as an operating sistem (beeing dependent on WMI). This is exacly what I've founded myself.

I am curently looking for an other method, whitch should be suported on a 95-98-me-2000 operating system too, or two methods one for XP+ and one for the rest ...

Anyway, the WMI querry didn't returned the corect string, other programs gave me an other result.

Any further ideeas?

PS: Thank you for your help again...

protected internal static readonly ... and I wish the list could continue ...

Re: Hard Disk Manufacter Serial Number

Simon Capewell3-Feb-06 6:19

Simon Capewell

3-Feb-06 6:19

Aaah, the same problem I had, although in my case the client wanted it written in VB6. this[^] is what I based my solution on. Sorry, it really is VB6, but it's largely calling onto the Win32 API so perhaps it'll get you started.

Re: Hard Disk Manufacter Serial Number

Stanciu Vlad3-Feb-06 21:27

Stanciu Vlad

3-Feb-06 21:27

Thanks, you pointed me on the right track...

protected internal static readonly ... and I wish the list could continue ...

export text/reports in XLS, HTML, PDF, DBF, XML format

MihaiChioariu3-Feb-06 4:27

MihaiChioariu

3-Feb-06 4:27

Hy,

I need some tools (classes not exe) to export/trnasform some text(reports) in XLS, HTML, PDF, DBF, XML... format.

Tranks,
Mihai

Re: export text/reports in XLS, HTML, PDF, DBF, XML format

malharone3-Feb-06 4:51

malharone

3-Feb-06 4:51

Oh that's easy.

using RG = System.ReportGenerator;<br />
<br />
ReportGenerator _generator = new ReportGenerator(new StreamReader(@"c:\sourcefile.txt"));<br />
_generator.OutputType = ReportTypes.Text;<br />
_generator.OutputType = ReportTypes.Html;<br />
_generator.OutputFile = @"c:\outputreport.html";<br />
_generator.Generate();

- Malhar

Re: export text/reports in XLS, HTML, PDF, DBF, XML format

MihaiChioariu3-Feb-06 5:52

MihaiChioariu

3-Feb-06 5:52

Hello,

Thank for your reply. It's very easy what you say, but i don't have the class System.ReportGenerator in my Microsoft .NET Framework 1.1. What framework you use? Or ReportGenerator it's a other class, not from .NET framework. If you fave this class, please send me (mihai@sln.ro).

Tranks,
Mihai

Re: export text/reports in XLS, HTML, PDF, DBF, XML format

malharone3-Feb-06 6:02

malharone

3-Feb-06 6:02

I was not serious about that piece of code i wrote. There is no class built in .Net framework which allows you to perform such operations.

Each of the formats (Text, PDF, XML, Excel, HTML) are meant for different purposes. There is no one-fit-all solution which allows you to perform any-to-any conversion.

It is up to you to implement the logic for this. For example, you'd have to define how to take care of
a) images in the PDF file when converting to text .. or
b) how to convert a text file containig some article in XML .. or
c) What is it that you want to "convert" from HTML to Excel .. the tags / tables / text ..?

- Malhar

Help with Environment.UserName and services

DUKEMAN3-Feb-06 4:04

DUKEMAN

3-Feb-06 4:04

Can anyone help me?

I have a service written in C# which runs under the System Account, and seems to be working fine. But one of the things i need to do is get the current logged in user (i.e. the person who logged into the workstation), but can't seem to get it.

I’ve tried using the Environment.UserName Property but all this seems to return is the account of person who started the current thread. Does anyone have any ideas how to get the information while running with a service?

Cheers

Paul

Re: Help with Environment.UserName and services

Sean Michael Murphy3-Feb-06 5:17

Sean Michael Murphy

3-Feb-06 5:17

DUKEMAN wrote:
But one of the things i need to do is get the current logged in user (i.e. the person who logged into the workstation), but can't seem to get it.

Uhh, I don't think you can get that with 100% certainty. The whole point of services is to insulate your code from requiring a user to be logged in. What would it return when no-one was logged in?

Maybe you could fudge it by iterating over the running processes at some interval and look for User Name not equal to "SYSTEM" or "NETWORK SERVICE" or "LOCAL SERVICE". If someone was logged in, something would be running under their context.

You can get an array of running processes with this code:

System.Diagnostics.Process.GetProcesses()

You can get the contexts of the processes using WMI with code here[^] ( I haven't tried it).

Share and enjoy.
Sean

Re: Help with Environment.UserName and services

DUKEMAN3-Feb-06 5:33

DUKEMAN

3-Feb-06 5:33

Hi Sean,

Having gone over other articles and notes I think you right the only way to get the current user would be to check the running process list and cross match this with the in build accounts and this should get you the current username/s.

Cheers for this

Paul

C# 2.0 & 1.1 interop

ryancrawcour3-Feb-06 3:22

ryancrawcour

3-Feb-06 3:22

Answer me this ...

I have an application that is built in .net 2.0.
It references an assembly built in .net 1.1

What happens internally when my application uses the 1.1 assembly?
Does it create a new process for the 1.1 CLR? Is it seamless?

This is important to me because if there are cross process calls I presume that there will be some sort of performance impact, am I correct?

Thanks
Ryan

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.