[data binding ] set the date format in the textbox.

  • Thread starter Thread starter Agnes
  • Start date Start date
A

Agnes

In my tables, there are invoicedate, as i use databinding, bind the
invoicedate to the textbox,
It show mm-dd-yyyy time. I need to change it into date dd-mm-yyyy only
without time .
how can i do that ???

I think I should not change it into string.
Please help.
 
Hi Agnes,

European style date.

I hope this helps?

Cor

\\\
Private Sub myroutine()
Mybinding = New Binding("Text", ds.Tables(0), "mydatfield")
textdatfield.DataBindings.Add(Mybinding)
AddHandler mybinding.Format, AddressOf DBdateTextbox
AddHandler mybinding.Parse, AddressOf TextBoxDBdate
End sub
Private Sub DBdateTextbox(ByVal sender As Object, _
ByVal cevent As ConvertEventArgs)
If cevent.Value Is DBNull.Value Then
cevent.Value = ""
Else
Dim datum As Date
datum = CDate(cevent.Value)
cevent.Value = datum.ToString("dd - MM - yyyy")
End If
End Sub
Private Sub TextBoxDBdate(ByVal sender As Object, _
ByVal cevent As ConvertEventArgs)
If cevent.Value.ToString = "" Then
cevent.Value = DBNull.Value
End If
End Sub
///
 
Back
Top