又一个日期格式问题:((Yet another date formatting problem :()

 我似乎每天都有日期格式问题！ 
 
 我正在查询一个表格，并以格式dd / mm / yyyy（作为字符串btw）获得一个日期。 辉煌！ 这就是我想要的。 但是，现在我想将该字符串转换为日期，以便我可以做到 
 
dim dayNumber as integer = day.DayOfWeek 
 
 但是，当我将它转换为日期时，它会将其更改为＃m / dd / yyyy＃。 AHHHH！ 我怎么能改变这个？ 
 
 这是我试过的代码 
 
Dim ActivityDate As String
If dt.Rows(i)("Date") Is DBNull.Value Then
    ActivityDate = ""
Else
    ActivityDate = dt.Rows(i)("Date")
End If

Dim ci As New System.Globalization.CultureInfo("en-CA")
Dim theDate As Date = Date.Parse(ActivityDate, ci)

Dim day As Integer = theDate.DayOfWeek
 
 干杯 

I seem to have a date formatting problem every day!
 
I am querying a table and am getting a date back in the format dd/mm/yyyy (as a string btw). Brilliant! thats what I want. But, now I want to convert that string to a date so i can do
 
dim dayNumber as integer = day.DayOfWeek 
 
But when I convert it to a date it changes it to #m/dd/yyyy#. AHHHH! how can I change this?
 
here is my code i've tried 
 
Dim ActivityDate As String
If dt.Rows(i)("Date") Is DBNull.Value Then
    ActivityDate = ""
Else
    ActivityDate = dt.Rows(i)("Date")
End If

Dim ci As New System.Globalization.CultureInfo("en-CA")
Dim theDate As Date = Date.Parse(ActivityDate, ci)

Dim day As Integer = theDate.DayOfWeek
 
Cheers

原文：https://stackoverflow.com/questions/2629526