Hi people

Attempt to edit time format, sql express by default takes in and displays us format, not the uk one.

I formated appearance of the calendar and the text box as follows:

    Calendar1.SelectedDate = Calendar1.TodaysDate
        HiddenField1.Value = Format(Calendar1.TodaysDate, "dd,MM,yyyy")

    Protected Sub Calendar1_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        txtDate.Text = Format(Calendar1.SelectedDate, "dd/MM/yyyy")


will that suffice and will the server return the error? Hypothetical question as I did not get my insert working yet! Stuffed!!!

Also, how the grid time appearance may be formated to the same standard?


thanx fellas, a valuable forum
mdm

You have to change the fomat in the gridview's RowDataBound event:
Ex:


    Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
        If e.Row.RowType = DataControlRowType.DataRow Then
            Dim mydate As DateTime
            Dim mystring As String
            mydate = e.Row.Cells(3).Text
            mystring = mydate.ToString("dd/MM/yyyy")
            e.Row.Cells(3).Text = mystring
        End If
    End Sub

Jim

Jim, would the same work for details view? I have tried to implement that for a details view and it did not like it.

thank you

mdm