Ahmad,

One thing you could do is to create a user control that has textbox on it. Bind your date column to this control, but in the text box that is on the control, only show the date portion, with the .ToShortDate() method.

~~Bonnie


>I am trying to display the date from SQL server database into a window form textbox as "dd/MM/yyyy", but it shows the time also.
>even this does not work :
>textbox1.text = format(dteDateandTime, "dd/MM/yyyy")
>
>beacuse I am using Databinding:
>Me.txtRegDate.DataBindings.Add("Text", myDS.Tables("Member"), "RegDate")
>
>Any idea how to avoide this.
>
>Thanks for the help