I have a problem with grid view

See more:

VB

Hi I want to ask you I am using a field name consultDate it's a Hijri date the field is nvarchar(8)
I use this code in a button to retrieve the date

Dim conn As New SqlConnection(Web.Configuration.WebConfigurationManager.ConnectionStrings("UserManagement").ConnectionString)
      Dim comm As New SqlCommand
      Dim adpt As New SqlDataAdapter
      Dim result As New DataTable

      comm.CommandText = "SELECT SUBSTRING(HIJRI_DATE,7,2) AS DAY,SUBSTRING(HIJRI_DATE,5,2) AS MONTH,SUBSTRING(HIJRI_DATE,1,4) AS YEAR FROM TABLE1 "
      comm.Connection = conn
      adpt.SelectCommand = comm
      Try
          adpt.Fill(result)
          DDL_Day.SelectedValue = result.Rows(0).Item("DAY").ToString
          DDL_Month.SelectedValue = result.Rows(0).Item("MONTH").ToString
          DDL_Year.SelectedValue = result.Rows(0).Item("YEAR").ToString
      Catch ex As Exception
          Throw ex
      Finally
          conn.Close()
      End Try
  End Sub

But now I have a gridview and I am using a sqldatasource
the date appears as 01021439
How can I put / between them to make it as a date
Thanks