public ucDailySalesReport() { try { InitializeComponent(); nepDate = new DateConverter(GlobalClass.TConnectionString); NumericColumn = new Style(); NumericColumn.TargetType = typeof(DataGridCell); NumericColumn.Setters.Add(new Setter { Property = DataGridCell.HorizontalAlignmentProperty, Value = HorizontalAlignment.Right }); txtTDate.SelectedDate = nepDate.GetLastDateOfBSMonth(DateTime.Today); txtFDate.SelectedDate = nepDate.GetFirstDateOfBSMonth(DateTime.Today); dgDailySales.Columns.Add(new DataGridTextColumn { Header = "In", Binding = new Binding("Date1"), Width = 150 }); dgDailySales.Columns.Add(new DataGridTextColumn { Header = "Out", Binding = new Binding("Date2"), Width = 150, }); // CellContentStringFormat = "{0:MM/dd/yyyy hh:mm tt}", dgDailySales.Columns.Add(new DataGridTextColumn { Header = "Interval", Binding = new Binding("Column3"), Width = 100 }); dgDailySales.Columns.Add(new DataGridTextColumn { Header = "Vehicle Type", Binding = new Binding("Column4"), Width = 100 }); dgDailySales.Columns.Add(new DataGridTextColumn { Header = "Rate", Binding = new Binding("Column6"), Width = 200 }); dgDailySales.Columns.Add(new DataGridTextColumn { Header = "Party", Binding = new Binding("Column5"), Width = 150 }); dgDailySales.Columns.Add(new DataGridTextColumn { Header = "User", Binding = new Binding("Column7"), Width = 200 }); dgDailySales.Columns.Add(new DataGridTextColumn { Header = "Charged Amount", Binding = new Binding("Decimal1") { StringFormat = "#0.00" }, Width = 150, CellStyle = NumericColumn }); //CellContentStringFormat = "{0:#0.00}", dgDailySales.Columns.Add(new DataGridTextColumn { Header = "Amount", Binding = new Binding("Decimal2") { StringFormat = "#0.00" }, Width = 150, CellStyle = NumericColumn }); //CellContentStringFormat = "{0:#0.00}", this.DataContext = ViewModel = new vmDailySales(); } catch (Exception ex) { MessageBox.Show(GlobalClass.GetRootException(ex).Message, "Sales Report", MessageBoxButton.OK, MessageBoxImage.Error); } }