Date Format in DetailView

[Chris]

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

[Ivan Todorov]

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

[Balamurugan]

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

[Dess | Tech Support Engineer, Principal]

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

[Balamurugan]

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.
  

[Dess | Tech Support Engineer, Principal]

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

[Balamurugan]

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

[Balamurugan]

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.

[Balamurugan]

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"

[Dess | Tech Support Engineer, Principal]

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

[Balamurugan]

How to Add Multiple Records from Grid1 to Grid2 on cell_click event.. 

[Balamurugan]

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..

[Dess | Tech Support Engineer, Principal]

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