Mask for DateTime field in PropertyGrid

Question

All How to create a mask to the DateTime field in the propertygrid such a way that user can enter only in that format. For example by default dd/mm/yyyy should be displayed in the DateTime field. When user key in numbers the numbers should replace the respective palces. Ofcourse user can give input from DateTime picker also. Please suggest me by giving code snippets or sample source code. Thanks in advance.

Bijayani Baijayanti · Answer

We can use SharePoint API as well as SharePoint List web reference to update List Items. Using API it is quite straight forward as we can directly assign a DateTime object against a DateTime field in SharePoint list. But with List web reference it is not that straight forward as we need to first convert the DateTime object into the SharePoint DateTime formatted string and then assign it to the specific field. Provided below are code samples written in C# to format an input as per SharePoint DateTime field. /* -- Format for Date Only Field -- */ private static String ToSPDate(String strDt) { if (strDt == String.Empty) return strDt; else return (Convert.ToDateTime(strDt)).ToString(yyyy-MM-dd); } /* -- Format for DateTime Field -- */ private static String ToSPDateTime(String strDt) { if (strDt == String.Empty) return strDt; else return (Convert.ToDateTime(strDt)).ToString(yyyy-MM-ddTHH:mm:ssZ); } Thanks Bijayani SharePoint Development

kumar p · Answer

all Can we customize the propertygrid such a way that it can fit in my needs???

kumar p · Answer

First of all Thanks for the response....... Actually Im using C# and .NET......I tried as you said. But I did not get expected result. Please If you have a source code share with me. Thank you.......

Scott Lysle · Answer

Set the dataGridViewCellStyle Format property to format the content (e.g. use Format=d to display dates like 2/12/1999. this.birthDateDataGridViewTextBoxColumn.DataPropertyName = BirthDate; dataGridViewCellStyle1.Format = d; dataGridViewCellStyle1.NullValue = null; this.birthDateDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle1; this.birthDateDataGridViewTextBoxColumn.HeaderText = BirthDate; this.birthDateDataGridViewTextBoxColumn.Name = birthDateDataGridViewTextBoxColumn;

Scott Lysle · Answer

Set the dataGridViewCellStyle Format property to format the content (e.g. use Format=d to display dates like 2/12/1999. this.birthDateDataGridViewTextBoxColumn.DataPropertyName = BirthDate; dataGridViewCellStyle1.Format = d; dataGridViewCellStyle1.NullValue = null; this.birthDateDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle1; this.birthDateDataGridViewTextBoxColumn.HeaderText = BirthDate; this.birthDateDataGridViewTextBoxColumn.Name = birthDateDataGridViewTextBoxColumn;