Hi
we develop web application,currently need to support other language date type also.
When we save date in Date/Time column in access db we convert to US format and save it,but retrieve date value from access db,it show in other language(2558/08/14 Thai format,bcz web application running in Thailand OS) but copy/paste that access db in English version OS and open access db,the date in (14/8/2015 US format)
So how to convert Thai date to US format from datatable.
Below is i tried
Dim iString As String = row(0).ToString
Dim oDate As DateTime = DateTime.ParseExact(iString, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)
It show "String was not recognized as a valid DateTime." error
Note:Web application running in Thai OS,when save date in access db we convert to US format using following code
DateTime.Now.ToString("dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)
Pls check screenshot taken form Thai OS,which install visual studio in Thai OS
http://prntscr.com/85jofq[
^]
http://prntscr.com/85jodq[
^]
I am create new web application and windows application inside Thai OS using VS2010
This is web application asp button click event
Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
Dim cn As OleDbConnection
Dim cmd As OleDbDataAdapter
Dim dt As New DataTable
Dim strcmd As String = ""
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Program Files (x86)\OCR\UDatabase\MM.mdb; Jet OLEDB:Database Password= Password;")
strcmd = "SELECT Format(ProcessDate,"yyyy/MM/dd") as PDate FROM tblFile "
cmd = New OleDbDataAdapter(New OleDbCommand(strcmd))
cmd.SelectCommand.Connection = cn
cn.Open()
cmd.Fill(dt)
Label1.Text = dt.Rows(0)("ProcessDate")
cn.Close()
End Sub
My web config is
="1.0"
<configuration>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
</system.web>
</configuration>
In windows application button click event is
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim cn As OleDbConnection
Dim cmd As OleDbDataAdapter
Dim dt As New DataTable
Dim strcmd As String = ""
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Program Files (x86)\OCR\UDatabase\MM.mdb; Jet OLEDB:Database Password= Password;")
strcmd = "SELECT Format(ProcessDate,"yyyy/MM/dd") as PDate FROM tblFile "
cmd = New OleDbDataAdapter(New OleDbCommand(strcmd))
cmd.SelectCommand.Connection = cn
cn.Open()
cmd.Fill(dt)
Label1.Text = dt.Rows(0)("ProcessDate")
cn.Close()
End Sub
in Access db got this value in tblFile table
ID ProcessDate
200 14/8/2015 4:41:51 PM
In windows application same US format date showing,but in web application it show Thai date format.
Note: i am running in Thai OS with VS2010 ,need to specify and date culture in web config ?
Pls check this link for exe and web application result
https://www.dropbox.com/s/3b3ano2xnqph0ls/thaios.wmv?dl=0[
^]