Visual Basic

5-Apr-04 19:37

Dear All,

I am in such a need of creating a Window service for logging my internet In and Out timing.

That means When I connected to the internet my windows service should log the time of entering.
At the same time it should log the time of leaving also.

One more thing is that windows service should send the report to the dedicated mail account periodically.

Can anyone detail me how to create a Windows service to meet my req ?.

Your help w'd be appreciated.

Thanks

DHARMA.R

Milton Karimbekallil5-Apr-04 20:43

5-Apr-04 20:43

hi
I don't understand the first requirement of logging the entering time and leaving time. Coz if it is a web server then it will be online all the time right? Otherwise if u are talking about the time of logging into ur website then u can use ur client application to log the log in and logout time. Normally Login and Logout time are entering using the client app right?

Second requirement is straight: periodically send mails to various clients. For this you can use the windows service or it will be more easy and efficient if u goes for DTS Packages in Sql Server provided ur database shud be MSSQL Server. Simply create a DTS package and schedule to execute it periodically.

rgds..mil10

Dave Kreskowiak6-Apr-04 0:51

Dave Kreskowiak

6-Apr-04 0:51

If you using a dialup connection, it's not so hard just monitoring IP for that connection. But this method won't work if your on a cable modem or some other permanent connection.

If you are looking at monitoring network traffic, then it will be an inaccurate accounting of the time since there, for the most part, is no traffic while your staring at the page you just downloaded.

A better method would be to monitor the task list for any instance of IEXPLORE or what name is being used for Netscape or whatever browser your using. If the instance is in the task list, you must be browsing the internet or at least viewing a page local to the machine. You would also have to monitor for any FTP client you happen to be using...

Another idea would be to write your own proxy server. You would be able to monitor all your connections independent of the client app that your using at the time, but again how do you know when your not viewing pages anywmore since the connection is only there when you are actually downloading something?

RageInTheMachine9532

DHARMA.R6-Apr-04 4:00

6-Apr-04 4:00

Hi,

Thanks for ur interest.

This is what I need exactly.

I have a Pc with internet connection (Dialup connection).
My friends and family members are using that Pc for browsing websites.

I'd like to log the everyone's total time of internet using.
This will help me to track who uses internet connection more.

For eg. consider this situation (Assume everyone has seperate windows user account)

1.Friend1 login to Windows.

2.He connected to the Internet using dialup connection at 6.00 P.M

3.He browsing web pages.

4.Friend1 disconnect the internet connection at 8.00 P.M

Our Windows service should record the foll. details.

==================
Date : 06/04/2004
User : Friend1
In : 6.00 P.M
Out : 8.00 P.M
==================

Could u understand my prob.
Can u suggest me the soln. for this ?

Thanks in advance.

Dave Kreskowiak6-Apr-04 5:51

Dave Kreskowiak

6-Apr-04 5:51

I already suggested methods of doing this, but it's not as easy as you may think it is. The only way to surely track that a connection is alive is if it is a dial-up modem connection. Since this type of connection is temporary and is not alive the entire time the machine is up, you can watch for changes in the IP stack, like gateway changes, that will occur when the connection is made and dropped.

If your using a cable modem or some other permanent connection, then this method will not work since the machine is connected all the time. You would have to monitor the process list for the various web browsers and FTP clients (by name!) to see how long the person is online.

RageInTheMachine9532

DHARMA.R6-Apr-04 20:25

6-Apr-04 20:25

Hi,

Thanks for ur informations.
Its v interesting.

Say, I am a new bee to VB.NET as well as Windows services.
Can u suggest me any resources reg. this.
Thanks

DHARMA.R

Dave Kreskowiak7-Apr-04 1:19

Dave Kreskowiak

7-Apr-04 1:19

Writing a Windows Service and monitoring the processes list are not exactly newbee projects. But you can search Amazon and checkout the dozens of books on VB.NET for every level from beginner to advanced programmers and cookbooks.

RageInTheMachine9532

DHARMA.R7-Apr-04 18:00

How to get target path of Shorcut (lnk) files in VB 6

7-Apr-04 18:00

Hi Dave,

Thank u v muc for ur help.
I'll check it out.

Regards

DHARMA.R

Dataset to Textboxes

trg50305-Apr-04 19:07

trg5030

5-Apr-04 19:07

I have a dataset where i display info in a data grib but i would like to show it in textboxes instead, any ideas?

i was thinking

dataset --> a class --> to the textbox

Re: Dataset to Textboxes

Alberto Venditti5-Apr-04 20:57

Alberto Venditti

5-Apr-04 20:57

Are you working on a Windows Form or on a Web Form?
What about the following?

myTextBox.DataBindings.Add(New Binding("Text", myDataSet, "myDataTable.myColumn"))

Re: Dataset to Textboxes

trg50306-Apr-04 13:12

trg5030

6-Apr-04 13:12

its a windows form

Re: Dataset to Textboxes

trg50306-Apr-04 18:53

trg5030

6-Apr-04 18:53

i would like to click on the datagrid and display the work in textboxes...
so that dosent work for me

EmanAli5-Apr-04 19:06

Re: How to get target path of Shorcut (lnk) files in VB 6

5-Apr-04 19:06

hi
Please help me how to get the target path of windows shortcut fiels in Visual Basic

Eman Ali Moughal
Senior Software Engineer
Soon Soft (pvt) Ltd
www.soonsoft.com

Milton Karimbekallil5-Apr-04 22:54

Re: How to get target path of Shorcut (lnk) files in VB 6

5-Apr-04 22:54

hi

Following code will resolve the target path of a shortcut named notepad.lnk in c:\
Change the path accordingly to meet ur requirment.

  Dim objFolder As Folder<br />
    Dim objFolderItem As FolderItem<br />
    Dim objShell As Shell<br />
    <br />
    Set objShell = New Shell<br />
    Set objFolder = objShell.NameSpace("c:\")<br />
        <br />
    Set objFolderItem = objFolder.ParseName("notepad.lnk")<br />
    <br />
    If Not objFolderItem Is Nothing Then<br />
    Dim objShellLink As ShellLinkObject<br />
    <br />
    Set objShellLink = objFolderItem.GetLink<br />
<br />
    If Not objShellLink Is Nothing Then<br />
        <br />
        Debug.Print objShellLink.Path<br />
    End If<br />
<br />
    Set objShellLink = Nothing<br />
    End If

rgds..mil10

EmanAli6-Apr-04 20:11

Re: How to get target path of Shorcut (lnk) files in VB 6

6-Apr-04 20:11

Thnks BUddy for the code
but the problem is that this code is not working in VB 6
i think this is the code for VB.NET because in VB 6 FolderItem and Shell does not Exist
would you please help me in this matter
Thanks

Eman Ali Moughal
Senior Software Engineer
Soon Soft (pvt) Ltd
www.soonsoft.com

Milton Karimbekallil11-Apr-04 19:24

Re: How to get target path of Shorcut (lnk) files in VB 6

11-Apr-04 19:24

hi
I just came back to my desk after Easter vacation. Sorry for the delay.
The code works fine with vb6. But I missed to tell u one thing.
You have to give reference to C:\WINNT\system32\shell32.dll. Give reference to this dll and try.

Rgds…mil10

EmanAli13-Apr-04 20:12

Re: How to get target path of Shorcut (lnk) files in VB 6

13-Apr-04 20:12

HI Thanks for the reply.
But sorry to bother you again and again Smile | :)

i have some problems related to the code i have added the link to Shell32.dll
so the problem of variables resolve but the function are not working properly
Like
like SET FOLDERITEM = objShell.ParseIFle("c:\") I think this is the function , si this function is not returning the proper directory
I dont know why
woould you please Help me
Thanks

Eman Ali Moughal
Senior Software Engineer
Soon Soft (pvt) Ltd
www.soonsoft.com

Milton Karimbekallil13-Apr-04 21:04

Re: How to get target path of Shorcut (lnk) files in VB 6

13-Apr-04 21:04

hi

No chance for any mishap, it shud work. Just chk the export list of shell32 using object browser whether those methods are there in the specified class. I tested it on Win2k professional and works fine.

rgds..mil10

EmanAli13-Apr-04 21:59

DataGrid Header and Alignment

13-Apr-04 21:59

hi Cool man Thanks Very much the code is working too much file but with a little change i dont know why but the change is

Dim objFolder As Folder2 in the deceleration section.
Because in the Intellisence list their two Folder options one is FOLDER and other is FOLDER2.
Folder2 option contains the procedure PARSENAME() .

Any way thanks very much for the Help

Eman Ali Moughal
Senior Software Engineer
Soon Soft (pvt) Ltd
www.soonsoft.com

ibok235-Apr-04 15:01

ibok23

5-Apr-04 15:01

I am trying to put a header on each of my columns in my data grid. I am getting an error while trying to run it. It is telling me that

An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll

Additional information: Index was out of range.  Must be non-negative and less than the size of the collection.

The error is on the first line in this part of the code.

What am I doing wrong? I have a total of 6 columns. Any suggestions.

dgPayrollInfo.GridColumnStyles(0).HeaderText = "Employee ID"
        dgPayrollInfo.GridColumnStyles(0).Alignment = HorizontalAlignment.Center
        dgPayrollInfo.GridColumnStyles(1).HeaderText = "Payroll ID"
        dgPayrollInfo.GridColumnStyles(1).Alignment = HorizontalAlignment.Center
        dgPayrollInfo.GridColumnStyles(2).HeaderText = "Pay Date"
        dgPayrollInfo.GridColumnStyles(2).Alignment = HorizontalAlignment.Center
        dgPayrollInfo.GridColumnStyles(3).HeaderText = "Gross Pay"
        dgPayrollInfo.GridColumnStyles(3).Alignment = HorizontalAlignment.Right
        dgPayrollInfo.GridColumnStyles(4).HeaderText = "Withholding"
        dgPayrollInfo.GridColumnStyles(4).Alignment = HorizontalAlignment.Right
        dgPayrollInfo.GridColumnStyles(5).HeaderText = "Net Pay"
        dgPayrollInfo.GridColumnStyles(5).Alignment = HorizontalAlignment.Right

Thank you,

ibok23

GetWindowText() from hidden window?

ndalal5-Apr-04 11:01

ndalal

5-Apr-04 11:01

I am trying to get the caption/title string of a hidden window, which is bascally a cmd.exe running in the background (not visible on screen). But using GetWindowText() function, I get an empty string back.

If I make that cmd.exe window visible, then it extracts the right caption of that window.

Any idea on what should I use if I have hidden process running in background to get its caption/title bar??

Many Thanks.

Re: GetWindowText() from hidden window?

Milton Karimbekallil5-Apr-04 23:10

Re: GetWindowText() from hidden window?

5-Apr-04 23:10

hi

If GetWindowText returns empty string then it means that the window does not exist at all. GetWindowText will return the exact caption even if the window is invisible. So if GetWindowText returns NULL then either the window does not exist or the window doesn't have a caption.

Use Spy++ ( comes with visual studio ) to inspect all active windows and processes.

rgds..mil10.

ndalal6-Apr-04 11:09

ndalal

6-Apr-04 11:09

OK, I dont know but it doesn't work for me Cry | :((

.
If you like, I can send you my code.

Anyways, any idea on how to get only hidden processes listed in VB?

Thanks.

Re: GetWindowText() from hidden window?

Milton Karimbekallil11-Apr-04 19:09