Hi guys,
I'm a complete newbie here and to VB.net in general. My friend for his company has written a program to tell if machines within his workplace are actually doing anything. The results from this are then shown in a text file, which I will show a small part of now:
Server to Check : AC01VS007c

Date Stamp : 26/06/2009

Time Stamp : 08:15

SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql

--------------------------------------------------------------------------------------------------------

Name

------------------------------

CES Manager 3.08.012



Name

------------------------------

SIS Translator 20.2.1



Name

------------------------------



Name

------------------------------



Name

------------------------------

CDS 22.1 WHO TR3



TODAYS DECLARATIONS

Number of Meetings

------------------

19



Number of BTG_OPTYS

-------------------

199



ODEC MESSAGES RECEIVED

Meetings

-----------

19



Events

-----------

195





--------------------------------------------------------------------------------------------------------

Server to Check : AC01VS014a

Date Stamp : 26/06/2009

Time Stamp : 08:15

SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql

--------------------------------------------------------------------------------------------------------

Name

------------------------------

CES Manager 3.11.006

Central System 20.0.3.0



Name

------------------------------

SIS Translator 20.2.1.2



Name

------------------------------

PA Translator 22.0.5.0



Warning: Null value is eliminated by an aggregate or other SET operation.

Name

------------------------------



Name

------------------------------

CDS 22.1 WHO TR3



TODAYS DECLARATIONS

Number of Meetings

------------------

0



Number of BTG_OPTYS

-------------------

0



ODEC MESSAGES RECEIVED

Meetings

-----------

0



Events

-----------

0





--------------------------------------------------------------------------------------------------------

Server to Check : AS02VS035S

Date Stamp : 26/06/2009

Time Stamp : 08:15

SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql

--------------------------------------------------------------------------------------------------------

Name

------------------------------
The problem with this is that it is very hard to read and takes unecessary time scrolling through to find whether it is working or not. If the meetings and events add up to 0 then obviously the machine isn't working.
What he has assigned me to do is put this information into a form which is simple and easy to read. I have successfully created a DataGridView which shows the Name of Machine, Status, Date Stamp and Time Stamp. However, this is only reproduced by entering the data manually into the source code eg.

for Date and Time Stamps.
So what I'm trying to do is be able to change the program so it can search the text file for the machine name, add up all of the events and meetings for that machine and store it as an integer which can be updated straight to the DataGridView, and do the same for the Date Stamp and time Stamp. I hope all of this makes sense and I would really appreciate your help because I don't have a clue of where to start.

This tutorial should give you something to start from. Come on back when you've go some code and we'll be glad to help you.

Good luck.

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this:

Thanks.

and post your q's in the correct forum. this is classic VB and not .NET