We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Columns Format Change

Thread ID:

Created:

Updated:

Platform:

Replies:

124648 Jun 20,2016 10:16 PM UTC Jun 22,2016 05:58 PM UTC WPF 3
loading
Tags: GridDataControl
Hamit KARAKAYA
Asked On June 20, 2016 10:16 PM UTC

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 [Syncfusion]
Replied On June 21, 2016 01:57 PM UTC

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, 
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> 
 
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
Replied On June 21, 2016 03:46 PM UTC

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 [Syncfusion]
Replied On June 22, 2016 05:58 PM UTC

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; 
     } 
 }      
 
 
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  


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;