How do I populate date without converting it to string

See more:

ASP.NET

MySQL

  string sql1 = @"Select * from Meeting where meeting_id = {0}";
    DataTable dt = DBUtl.GetTable(sql1, TxtMeetingID.Text);
    if (dt.Rows.Count == 1)
    {
        //populate the form = retrieve value from DataTable
        TxtDate.Text = String.Format("{0:yyyy-MM-dd}", dt.Rows[0]["date"]);
        DrpRoom.SelectedValue = dt.Rows[0]["room_id"].ToString();
        DrpPax.SelectedValue = dt.Rows[0]["attendees_pax"].ToString();
        ti.Value = dt.Rows[0]["start_time"].ToString();
        to.Value = dt.Rows[0]["end_time"].ToString();
    }
    else
    {
        LtlMsg.Text = "Meeting ID not found – please try again.";
    }
}

> The error i got was Format exception error unhandled by user

An exception of type 'System.FormatException' occurred in mscorlib.dll but was not handled in user code
Additional information: Input string was not in a correct format.

> how do i populate/retrieve date without converting to string? because i still need to do a delete query to delete the booking.
> Please help me!

What I have tried:

I tried to convert it to datetime and then string it .. But it got red underline.