Click here to Skip to main content
Click here to Skip to main content

TaskLister 1.0a

, 25 May 2006
Rate this:
Please Sign up or sign in to vote.
An article about builing a task tracker software.

Sample Image

Introduction

This piece of software can be used for the following:

  • Tracking the project work flow - a Task Lister.
  • Track the issues reported by the client.
  • Project estimation etc.

The features I have integrated, presently, are:

  • Export to HTML and Excel Worksheet.
  • Simple interface.
  • No database used - XML file for storing data.
  • Always-on-top feature.

Background

I was using an Excel sheet for a long time for tracking issues reported by the client. Once I got some free time, I made a small utility for this purpose. That means, I made this tool as per my requirements. Not sure how much this will be useful for you. Well, you can create more fields, features etc., if you wish. Also, if you suggest, I can make it for you.

Using the code

First, the application reads the TaskLister.xml file to a DataSet, and then it fills a DataGridView. The DataGridview gives the users option to add, remove, edit, set priority, set status etc.

ds.ReadXml(XMLfile);

dataGridView1.DataSource = ds.Tables["table1"];

For saving the data, a simple line is used:

ds.WriteXml(XMLfile, XmlWriteMode.WriteSchema);

Exporting to HTML and Excel Worksheets uses the below code - you can see here that the export to Excel is a trick...

private void exportToHTMLToolStripMenuItem_Click(object sender, EventArgs e)
{
    saveFileDialog1.Filter = 
      "HTML Files|*.htm*|Excel Worksheet files|*.xls";
    if (saveFileDialog1.ShowDialog() == DialogResult.OK)
    {
      FileInfo fi = new FileInfo(saveFileDialog1.FileName);
      StreamWriter sw = fi.CreateText();
      sw.WriteLine("<html><head><title>" + 
                   "TaskLister Export</title>"); 
      sw.WriteLine("<style>th, td {border-bottom:solid 1px" + 
                   " brown;border-right:solid 1px brown;}" + 
                   " table {font:normal 12px arial}" + 
                   "</style></head><body>");
      sw.WriteLine("<table cellpadding=0 cellspacing=0 " + 
                   "style='border:solid 1px brown'>");
      sw.Write("<tr bgcolor='#FF9933'><th align='center' " + 
               "width='30px'>No.</th><th align='center' " + 
               "width='50px'>Priority</th><th align='center' " + 
               "width='100px'>Ref.</th><th align='center'" + 
               " width='250px'>Task</th><th align='center' " + 
               "width='70px'>Status</th><th align='center' " + 
               "width='30px'>Hrs.</th><th align='center' " + 
               "width='200px'>Comments</th></tr>");
      foreach (DataRow dr in ds.Tables["table1"].Rows)
      {
          sw.Write("<tr><td align='center'>&nbsp;" + dr[0] + 
                   "</td><td align='center'>&nbsp;" + dr[1] + 
                   "</td><td>&nbsp;" + dr[2] + 
                   "</td><td width='250px'>&nbsp;" + dr[3] + 
                   "</td><td align='center'>&nbsp;" + dr[4] + 
                   "</td><td width='30px'>&nbsp;" + dr[5] + 
                   "</td><td width='200px'>&nbsp;" + dr[6] + 
                   "</td></tr>");
      }
      sw.WriteLine("</table>");
      sw.WriteLine("<span style='font:italic 8px times new roman'>" + 
                   "Created with TaskLister1.0 from Praveen." + 
                   "</span></body></html>");
      sw.Close();
    }
}

History

This is the first version of my code.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Praveen Nair (NinethSense)
Architect ORION INDIA SYSTEMS
India India
Praveen.V.Nair - aka NinethSense - PMP, Microsoft MVP - is working as a Head of Technology and Architecture at Orion India Systems, Kochi, India. He has been playing with electronics from the age of 10 and with computers from the age of 14. He usually blogs at http://blog.ninethsense.com/.
Follow on   Twitter   Google+   LinkedIn

Comments and Discussions

 
GeneralPort to VB.net Pinmembergnixon24-Mar-08 11:36 
GeneralRe: Port to VB.net PinmemberNinethSense24-Mar-08 19:53 
GeneralThanks! PinmemberLaurent Cozic13-Nov-07 12:57 
GeneralRe: Thanks! PinmemberNinethSense13-Nov-07 19:06 
QuestionXLS a trick? Pinmembersoulmaster8817-Aug-07 8:27 
AnswerRe: XLS a trick? PinmemberNinethSense18-Aug-07 9:21 
AnswerUse DataGridView Extension PinmemberAlexander Alexandrov21-Aug-07 1:31 
GeneralRe: Use DataGridView Extension Pinmembersoulmaster8822-Aug-07 7:19 
GeneralRe: Use DataGridView Extension PinmemberAlexander Alexandrov22-Aug-07 21:36 
GeneralThanks for checking my project PinmemberNinethSense29-May-06 0:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

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

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.141220.1 | Last Updated 25 May 2006
Article Copyright 2006 by Praveen Nair (NinethSense)
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid