Columns Format Change

[Hamit KARAKAYA]

Hi dear syncfusion team,

I looked in the forum but could not find a result,

I just want to turn the datetime format to smalldate

for example "21.06.2016 23:45:33" to "21.06.2016"
or
17,500 money to 17,500.00$ or  17,500.00€ or 17,500.00TL


Waiting for your help.

Attachment: converting_9c28e689.rar

[Jai Ganesh S]

Hi Hamit, 

Please find the responses for your queries as below, 

Query 1: 

You can change the DateTime format for DateTimeColumn. We already have a kb for this and please find the kb link below, 

https://www.syncfusion.com/kb/2366/how-to-set-the-custom-date-time-format-in-griddatacontrol 

Query 2: 

You can display your own symbol for currency column by using a CurrencySymbol property as like below, 

<Syncfusion:GridDataVisibleColumn MappingName="EmployeeSalary"> 

     <Syncfusion:GridDataVisibleColumn.ColumnStyle> 

 

           <Syncfusion:GridDataColumnStyle 

                                CellType="CurrencyEdit"  

                                NegativeForeground="Red" 

                                HorizontalAlignment="Right" > 

                  <Syncfusion:GridDataColumnStyle.NumberFormat> 

                            <glob:NumberFormatInfo  CurrencySymbol="€" CurrencyPositivePattern="1"  CurrencyNegativePattern="5"/> 

                  </Syncfusion:GridDataColumnStyle.NumberFormat> 

           </Syncfusion:GridDataColumnStyle> 

     </Syncfusion:GridDataVisibleColumn.ColumnStyle> 

 </Syncfusion:GridDataVisibleColumn> 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/159099/ze/GDCSample527011208 

In the above sample, we have set the ‘€’  symbol  in CurrencySymbol property like this you will set $ or TL symbols. 

Regards, 

Jai Ganesh S 

[Hamit KARAKAYA]

Thank you for your quick response,

summarry row mapping to autogenerate column name it's working, but GridDataVisibleColumn map to autogenerated column name and nothing changet the date column

<syncfusion:GridDataControl Name="fdg_rapor"
                                        AllowEdit="False"
                                        AllowGroup="True"
                                        AllowSort="True"
                                        AutoPopulateRelations="False"
                                        ShowAddNewRow="False"
                                        ShowGroupDropArea="True"
                                        HideColumnsWhenGrouped="False"
                                        FilterBarMode="Immediate"
                                        FilterBarPredicateType="And"
                                        GroupDropAreaText="BAŞLIKLARI BU ALANA SÜRÜKLEYİP GURUPLANDIRABİLİRSİNİZ"
                                        ShowFilterBar="True"
                                        VisualStyle="Metro"
                                        ColumnSizer="Star">

<syncfusion:GridDataControl.VisibleColumns>
                <syncfusion:GridDataVisibleColumn HeaderText="Tahsil Date" MappingName="Tahsil">
                    <syncfusion:GridDataVisibleColumn.ColumnStyle >
                        <syncfusion:GridDataColumnStyle HorizontalAlignment="Right" CellType="DateTimeEdit" >
                        <syncfusion:GridDataColumnStyle.DateTimeEdit>
                            <syncfusion:GridDateTimeEditStyleInfo DateTimePattern="ShortDate" />
                        </syncfusion:GridDataColumnStyle.DateTimeEdit>
                    </syncfusion:GridDataColumnStyle>
                </syncfusion:GridDataVisibleColumn.ColumnStyle>
                <syncfusion:GridDataVisibleColumn.HeaderStyle>
                        <syncfusion:GridDataColumnStyle Background="Green" HorizontalAlignment="Center" />
                </syncfusion:GridDataVisibleColumn.HeaderStyle>
            </syncfusion:GridDataVisibleColumn>
            </syncfusion:GridDataControl.VisibleColumns>
</syncfusion:GridDataControl.SummaryRows>

public Rapor_Tahsilat()
        {
            InitializeComponent();
            dt_rapor = Rapor.getir("bugun", dtpic_startdate.SelectedDate.Value.ToString("MM.dd.yyyy") , dtpic_finishdate.SelectedDate.Value.ToString("MM.dd.yyyy"));
            fdg_rapor.ItemsSource = dt_rapor;
         }

           GridDataVisibleColumn mapping to date column, nothing ever changes

my goal
dt_rapor.Columns[5]  Header "Tahsil" = <syncfusion:GridDataVisibleColumn HeaderText="Tahsil Date" MappingName="Tahsil">
dt_rapor.Columns[5]  = 1.1.2016 25:17:15
griddatacolumn         = 01.01.2016        

I thought I would tell hope

in addition

<syncfusion:GridDataVisibleColumn HeaderText="Tahsilat" MappingName="Tahsilat">
                    <syncfusion:GridDataVisibleColumn.ColumnStyle >
                        <syncfusion:GridDataColumnStyle 
                                CellType="CurrencyEdit" 
                                NegativeForeground="Red"
                                HorizontalAlignment="Right" >
                            <syncfusion:GridDataColumnStyle.NumberFormat>
                                <Syncfusion:GridDataColumnStyle.NumberFormat> gives error The attachable property 'NumberFormat' was not found in type 'GridDataColumnStyle'.   
                                    <glob:NumberFormatInfo  CurrencySymbol="€" CurrencyPositivePattern="1"  CurrencyNegativePattern="5"/>
                            </syncfusion:GridDataColumnStyle.NumberFormat>
                        </syncfusion:GridDataColumnStyle>
                    </syncfusion:GridDataVisibleColumn.ColumnStyle>
                    <syncfusion:GridDataVisibleColumn.HeaderStyle>
                        <syncfusion:GridDataColumnStyle Background="Pink" HorizontalAlignment="Center" />
                    </syncfusion:GridDataVisibleColumn.HeaderStyle>
                </syncfusion:GridDataVisibleColumn>

Thank you for your response

[Jai Ganesh S]

Hi Hamit, 

 

Query 1: 

 

We suspect that, you want to set the format for DataTimeColumn in code behind. You can achieve this by using QueryCellInfo event, 

 

this.grid.ModelLoaded += grid_ModelLoaded; 

 

void grid_ModelLoaded(object sender, EventArgs e) 

{ 

    grid.Model.QueryCellInfo += Model_QueryCellInfo; 

} 

 

void Model_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e) 

 { 

     if (grid.VisibleColumns[e.Cell.ColumnIndex].MappingName == "DOB") 

     { 

         e.Style.CellType = "DateTimeEdit"; 

 

         e.Style.DateTimeEdit.DateTimePattern = DateTimePattern.LongDate; 

     } 

 }      

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/DateTimeEdit1335923696.zip 

 

Query 2: 

 

We have checked the issue in our sample but the NumberFormat issue is not reproduced and it is working fine in our side. Could you please recheck in your end? 

 

Regards, 

 

Jai Ganesh