[RESOLVED] format datagrid column to display only the time

[sunshine123]

Hi,

I'm using compact framework with VS 2005.
How can I format a datagrid column to display only the time.

Thanks

[petevick]

HI,
For a time using your own date
FormatDateTime(mydate, DateFormat.ShortTime)
else
FormatDateTime(Date.Now, DateFormat.ShortTime)
for the current date.

Is that what you mean?

Pete

[jmcilhinney]

Did you follow the link I provided in your other thread? Question 44 on that page is "How do I format a date column in a datagrid?". It shows you how to set the format for a DataGridTextBoxColumn. Go to the MSDN library topic for the DataGridTextBoxColumn class and it has a code example for adding one to a grid. Look up "date formatting" or "time formatting" on MSDN and you'll find the format strings you can assign to the Format property of your DataGridTextBoxColumn.

Many questions aren't going to be solved by finding a ready-made solution in one place. You have to construct a solution by breaking the problem into pieces and solving each piece on its own.

[sunshine123]

Yes I was able to solve the problem with some support from that link...

Just for anyne who mght come across the same problem...you use tablestyles to format datagrid columns in compact framework apps.

this example I came across might be useful.

private void Form1_Load(object sender, System.EventArgs e)
		{
			string dataTableName = "theTable";
			//add a tablestyle to the grid so there will be custom columnstyles available
			//    after the datasource has been set....
			DataGridTableStyle ts = new DataGridTableStyle();
			ts.MappingName = dataTableName;
			
			this.dataGrid1.TableStyles.Add(ts);
			this.dataGrid1.DataSource = GetTheTable(dataTableName);
			
			//now default customcolumnstyles have been created, so we can use them to set properties
			DataGridTextBoxColumn dgtbc;

			//format the int
			dgtbc = dataGrid1.TableStyles[0].GridColumnStyles[0] as DataGridTextBoxColumn;
			if(dgtbc != null)
				dgtbc.Format = "n0"; 

			//format the double
			dgtbc = dataGrid1.TableStyles[0].GridColumnStyles[1] as DataGridTextBoxColumn;
			if(dgtbc != null)
				dgtbc.Format = "f3"; // 0r "#.000"; 

			//format the double as currency
			dgtbc = dataGrid1.TableStyles[0].GridColumnStyles[2] as DataGridTextBoxColumn;
			if(dgtbc != null)
				dgtbc.Format = "c4";  

			//format the date
			dgtbc = dataGrid1.TableStyles[0].GridColumnStyles[3] as DataGridTextBoxColumn;
			if(dgtbc != null)
			{
				dgtbc.Format = "t"; // t is for time. d is for date				dgtbc.Width = 100; //size it
			}			

		}