How to format column in datacolumn

  • Thread starter VISVAMBHAR TRIBANG RAJAT AMOL TANMAY RASIK VISHAL
  • Start date
V

VISVAMBHAR TRIBANG RAJAT AMOL TANMAY RASIK VISHAL

Hi,

I need display dropdown with data from two columns, so I am doing like this:

DataTable source = data.GetSomeData(); //returns a datatable
source.Columns.Add("DisplayName", typeof(string), "[EventTitle] + ' (' +
[EventDate] + ')'");

theDropdown.DataValueField = "IDColumn";
theDropdown.DataTextField = "DisplayName"; //created above

theDropdown.DataSource = source;
theDropdown.DataBind();


When displayed in dropdown, it shows:

Event #1 (9/15/2006 12:00:00 AM)
Event #2 (10/23/2006 12:00:00 AM)

I want to not have the time in there. I know that I can change how the data
is returned in the GetSomeData() method, and that is probably what I'll do,
but this got me wondering how I could apply formatting to the column with
how I'm adding it by concatenating other fields. I tried to see if ADO.Net
used DATEPART or something like that, but it was not known.

Thank you,
VISVAMBHAR TRIBANG RAJAT AMOL TANMAY RASIK VISHAL BHUSHAN SUBHASH SOUMIL
OMKAR HARSHIT SUDHIT GARUD MUKUND SHAHALAD KRIPAL SANSHRAY MEET NITYANAND
ANGIR SUMANT SHANTANU RAM ADVAITA VISVARUP KAVIN SRINIVAS HANUMAN KEWAL
VISVAMBHAR TRIBANG RAJAT AMOL TANMAY RASIK VISHAL BHUSHAN SUBHASH SOUMIL
OMKAR HARSHIT SUDHIT GARUD MUKUND SHAHALAD KRIPAL SANSHRAY MEET NITYANAND
ANGIR SUMANT SHANTANU RAM ADVAITA VISVARUP KAVIN SRINIVAS HANUMAN KEWAL HARI
NAVADWEEP PARAN TANMAY GOPESH HARSHAD MEHUL RANAK PANAV BHIM MADAN SHYAMAL
DAMODAR NITIN MADHUSUDAN ETASH TAKSHEEL AKSHAR AMAR ACYUTA AYUSH SRIVAS
RASAPARAYAN SUBHASH KHUSHAL RAJDEEP PUNIT VIRAJ AGASTHYA ANUPAM.
 

Members online

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top