Yes the SP returns the record properly. I just checked again.

The page with the UI has the following code behind. It is on the data bind of the details view where this issue starts (in red).

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            txtEndDate.SelectedDate = DateTime.Now;
            txtStartDate.SelectedDate = DateTime.Now.AddDays(-(Convert.ToInt32(Globals.Settings.Tasks.DefaultDat eRangeInDays)));
            dvTaskDetails.Visible = false;

        }
    }
    protected void btnRefreshView_Click(object sender, EventArgs e)
    {
        gvTasks.DataBind();
    }
    protected void gvTasks_SelectedIndexChanged(object sender, EventArgs e)
    {
        getTaskDetail();
    }

    private void getTaskDetail()
    {
            dvTaskDetails.ChangeMode(DetailsViewMode.Edit);
            dvTaskDetails.DataBind();
This has the ID value from the grid. It should grab the record.

            dvTaskDetails.Visible = true;
    }

Am I missing something obvious? I have a suspicion I might be.

--
Tara G Deschenes
Technimedia LLC

What does the code look like that creates the reader and passes it to GetTaskFromReader?

Maybe you're not calling the right procedure or sending it incorrect parameters?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Just a quick update on this situation. I reviewed all my code and was missing some key lines. Ugh.

    public override TaskDetails GetTaskById(int taskId)
        {
            using (SqlConnection cn = new SqlConnection(this.ConnectionString))
            {
                SqlCommand cmd = new SqlCommand("Tasks_GetTaskById", cn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@TaskId", SqlDbType.Int).Value = taskId;
                cn.Open();
                IDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
                if (reader.Read())
                    return GetTaskFromReader(reader);
                else
                    return null;
            }
        }

That fixed it. I didn't see this in the book (for some reason) and had to download the online version of the code and compare the two. Then I found it.

That's what happens when you stare at something for too long without regular breaks!!

Thanks again for the attention and conversation. Sometimes it just helps to vent. :)

--
Tara G Deschenes
Technimedia LLC

Hi Tara,

Great, glad it's working now....

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.