Problem in exporting data to chart

Question

Hi,

I would like to make chart with taskname (on X-axis) and timetakenfortheTask (on y-axis).

in my database i have data as:
Taskname   timetakenfortheTask(hrs)
Writing           1:00
printing          2:30
delivery          5:00

I wrote code like this:

With the below code i am getting all task names on x-axis. But i am not getting "timetakenfortheTask" on y-axis with times.

 chart1.Enabled = true;

            con.Open();

            chart1.DataSource = null;

            SqlCommand chartcmd = new SqlCommand("select taskname, timetakenfortheTask  from Time_sheet where Name='" + cmbEmpnam.Text + "';", con);

            chartcmd.Connection = con;

            SqlDataAdapter chartada = new SqlDataAdapter(chartcmd);

            DataSet ds = new DataSet();

            chartada.Fill(ds);

            DataView source = new DataView(ds.Tables[0]);

            chart1.DataSource = source;

            chart1.Series[0].XValueMember = "taskname";

            chart1.Series[0].YValueMembers = "timetakenfortheTask";

            chart1.DataBind();

            con.Close();



Advance thanks,

Darma