How to format a DataTime field

[Nikola]

heeey guys 


I have a question, I have  here a data time field that is saved in the db as date time and it need to be a date time , and I want to load this Field in a drop down but not the hole value just the year 

}
     protected void LoadYear()
     {
         SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HolidayTrackerConnectionString"].ConnectionString);

         SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM HtVacationDay", connection);
         DataTable dt = new DataTable();

         adapter.Fill(dt);

         rcbYear.DataTextField = "FromDate";
         rcbYear.DataValueField = "VacationDayId";

         rcbYear.DataSource = dt;
         rcbYear.DataBind();

         rcbYear.Items.Insert(0, new RadComboBoxItem("-Select a Year-"));
     }

thanks for help and fast answer ! 

[Shinu]

Hi,

Here is the sample code to show the year alone.
C#:

int date;
protected void LoadYear()
{
  SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HolidayTrackerConnectionString"].ConnectionString);
  SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM HtVacationDay", connection);
  DataTable dt = new DataTable();
  adapter.Fill(dt);
  dt.Columns.Add("MyRow");
  foreach (DataRow dr in dt.Rows)
  {
    date = Convert.ToDateTime(dr["FromDate"]).Year;
    int index = dt.Rows.IndexOf(dr);
    dt.Rows[index]["MyRow"] = date;
  }
   rcbYear.DataSource = dt;
   rcbYear.DataTextField = "MyRow";
   rcbYear.DataValueField = "OrderID";
   rcbYear.DataBind();
   rcbYear.Items.Insert(0, new RadComboBoxItem("-Select a Year-"));
}

Thanks,
Shinu.