Hi all,

the following is the structure of my database table

table
{
  DateTime StartDate;
  DateTime EndDate;
  VarChar Event;
}

I'm trying to grab start date and end date from database, then reformat the Dates to represent as "StartDate-EndDate" and i am using a data repeater control to display the data. How would I do it without adding another column say DisplayDates in the database? I guess my questions is how can I grab values from database, then do some manipulation of that data and display it in data repeater or data grid control?

thanks in advanced!

Hi All,

I've found a solution to it. Actually, Data repeater solves the problem.

thanks!!