Date Format in DetailView

13 posts, 1 answers
  1. Chris
    Chris avatar
    1 posts
    Member since:
    Nov 2012

    Posted 04 Dec 2012 Link to this post

    Hi,

    I need help with one problem. I got databound ListView on windows form.
    One of the columns in bound data is of DateTime type.
    How do I display it in format dd/MM/yyyy (without time).
    I can return date from database as already formated string but then sorting on this column
    works on string value not DateTime.
    I can't find way around it. Any help would be greatly appreciated.

    Thanks
    Chris
  2. Answer
    Ivan Todorov
    Admin
    Ivan Todorov avatar
    688 posts

    Posted 06 Dec 2012 Link to this post

    Hi Chris,

    Thank you for contacting us.

    You can handle the CellFormatting event to apply any custom formatting over the cells in DetailView. The following sample demonstrates this:
    void radListView1_CellFormatting(object sender, Telerik.WinControls.UI.ListViewCellFormattingEventArgs e)
    {
        if (e.CellElement.Data == this.radListView1.Columns["OrderDate"] && e.CellElement is DetailListViewDataCellElement)
        {
            e.CellElement.Text = String.Format("{0:dd/MM/yyyy}", ((DetailListViewDataCellElement)e.CellElement).Row[e.CellElement.Data]);
        }
    }

    The above code will modify only the visual representation of the cells and sorting and filtering operations will work as expected with the underlying value.

    I hope you find this useful. Feel free to write back if you have any additional questions.

    All the best,
    Ivan Todorov
    the Telerik team
    Q3’12 of RadControls for WinForms is available for download (see what's new). Get it today.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Balamurugan
    Balamurugan avatar
    7 posts
    Member since:
    Nov 2012

    Posted 27 Sep 2013 Link to this post

    how to work with Price Format in RadListview. i use to modify ur Date Format code like shown below.. But, CellFormatting not at all firing when debugging... 

    if (e.CellElement.Data == this.radListView1.Columns["Price"] && e.CellElement is DetailListViewDataCellElement)
                {
                    FontStyle fstyle = FontStyle.Regular;
                    e.CellElement.Font = new Font(ff, 20, fstyle);
                    e.CellElement.Text = String.Format("{0:`0.00##}", ((DetailListViewDataCellElement)e.CellElement).Row[e.CellElement.Data]);
                }
  5. Dess
    Admin
    Dess avatar
    1601 posts

    Posted 01 Oct 2013 Link to this post

    Hello,

    Thank you for contacting Telerik Support.

    In order to achieve price formatting, please, have a look at the following code snippet:
    public partial class Form1 : Form
    {
        Font font = new Font("Arial", 12f, FontStyle.Regular);
     
        public Form1()
        {
            InitializeComponent();
     
            this.radListView1.CellFormatting += radListView1_CellFormatting;
        }
     
        private void radListView1_CellFormatting(object sender, ListViewCellFormattingEventArgs e)
        {
            if (e.CellElement.Data == this.radListView1.Columns["UnitPrice"] && e.CellElement is DetailListViewDataCellElement)
            {
                e.CellElement.Font = font;
                e.CellElement.Text = string.Format("{0:C}", ((DetailListViewDataCellElement)e.CellElement).Row[e.CellElement.Data]);
            }
        }
     
        private void Form1_Load_1(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'nwindDataSet1.Order_Details' table. You can move, or remove it, as needed.
            this.order_DetailsTableAdapter1.Fill(this.nwindDataSet1.Order_Details);
        }
    }

    Note that font creating is a time consuming operation, that is why it is better to be created in advance.

    I hope this information helps. Should you have further questions, I would be glad to help.

    Regards,
    Desislava
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  6. Balamurugan
    Balamurugan avatar
    7 posts
    Member since:
    Nov 2012

    Posted 02 Oct 2013 Link to this post

    The Source Code which u Posted to achieve  Price Formatting, was fine and good.. Its Working.. Thanks.. 

    Could u Please do me one more favor, I am trying to Fetch Price Amount based on Product ID.

    Ex: Kindly Take look on "DetailsView.png" 

    Requirements:

    Input(textbox_KeyPress):- OrderID-10248

    Output(textbox OR label):- UnitPrice-14.00

    How can i achieve this task in RadListView.
      
  7. Dess
    Admin
    Dess avatar
    1601 posts

    Posted 07 Oct 2013 Link to this post

    Hello,

    Thank you for writing back.

    Please, find the attached sample project, demonstrating the functionality from the attached picture.

    I hope this information helps. Should you have further questions, I would be glad to help.


    Regards,
    Desislava
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  8. Balamurugan
    Balamurugan avatar
    7 posts
    Member since:
    Nov 2012

    Posted 09 Oct 2013 Link to this post

    Excellent work buddy.. The Sample code which u posted is really good.. and its working fine.. 

    Thanks buddy..

    I have TWO More Doubts..

    1. If we use Telerik controls in windows form application.. Usually the form takes time to load or is there any other Problem.
    i am using RadListView in one of my form. Particularly, the "Form" where i used RaddListView is taking more time to load. also              the input which i use to  give in commandbarTextBox.


    2. How to use WPF in WinForms.. Need any Sample
  9. Balamurugan
    Balamurugan avatar
    7 posts
    Member since:
    Nov 2012

    Posted 09 Oct 2013 Link to this post


    Pls Find the Attached..

    1. Using RadListView in one of my Form.. Particularly, the "Form " where i am using RadListView, it takes more time to load. Could u pls tell me why? Or is it is normal if we use telerik controls? 

    2.How to use WPF in WinForms. Need Sample Project.

  10. Balamurugan
    Balamurugan avatar
    7 posts
    Member since:
    Nov 2012

    Posted 10 Oct 2013 Link to this post



    Grid1: Grid2:

    s.no name PH#                                                       s.no name PH#
                                                                                                      |-->            2  john 565
              1  bala 123                                                    |
       2  john 565   ---->(Cell_ClickEvent(RowSelect))


    both the Grids are in same "Form"
  11. Dess
    Admin
    Dess avatar
    1601 posts

    Posted 11 Oct 2013 Link to this post

    Hello,

    Thank you for writing back.

    In contrast to the standard MS WinForms controls which are just wrappers of the native Win32 controls, our controls support theming, animations and some other extended features. This slightly reflects on performance. Nevertheless, we constantly try to improve controls' performance and to optimize them. We also take serious all performance issues reported from our customers and try to solve them with high priority. Please take a look at this KB article, it gives some basic ideas on how to improve the performance of RadControls for WinForms.

    In general, we do not have any special means to host a Telerik WPF controls in a WinForms project and if the ElementHost is not appropriate for your scenario I am afraid that I cannot give you any other way to do that. Nevertheless, you can get some general information and samples related to the topic in the MSDN library - WPF and Windows Forms Interoperation.

    As to the question from your last post, the provided information is not sufficient to understand what is the exact requirement. Please give us more details.

    I hope this information helps. Should you have further questions, I would be glad to help.

    Regards,
    Desislava
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  12. Balamurugan
    Balamurugan avatar
    7 posts
    Member since:
    Nov 2012

    Posted 15 Oct 2013 Link to this post



    How to Add Multiple Records from Grid1 to Grid2 on cell_click event.. 
  13. Balamurugan
    Balamurugan avatar
    7 posts
    Member since:
    Nov 2012

    Posted 16 Oct 2013 Link to this post


    Please Take a look on Attached Below,

    Why did it Happens? When i use to transfer data from one Grid to another grid, the existing grid data got invisible..

    Kindly Post As soon as possible..

    Thanks for ur Services..
  14. Dess
    Admin
    Dess avatar
    1601 posts

    Posted 18 Oct 2013 Link to this post

    Hello,

    Your latest question seems to concern RadGridView while the initial topic of this forum thread is related to RadListView. That is why I would like to kindly ask you to open a new thread concerning your RadGridView questions and to avoid mixing different subject in the same thread in future. This way we will allow the community to find the necessary answers easily.

    You can also have a look at our forum guidelines here: http://www.telerik.com/community/forums/winforms/listview/important-information-on-using-the-telerik-forums.aspx.

    Thank you for your understanding.

    Regards,
    Desislava
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
Back to Top
UI for WinForms is Visual Studio 2017 Ready