I
Iwan Petrow
Hi,
I have a column DateTime in a table in MS SQL Server database. I take
this column using a Web Service and show it in a TextBox in a Web
Application. I want the format of the date to be
"dd\mm\yyyy hh:mm:ss". The collation name of the database is
SQL_Latin1_General_CP1_CI_AS (if it necessary I could change it).
In the Web service and in the Web App I don't change anything about
culture and the text box shows "mm/dd/yyyy hh:mm:ss AM/PM" .
I use a DataSet to get the data from the database (fill it with
SqlDataAdapter).
What could I do to fix this problem?
Thanks.
I have a column DateTime in a table in MS SQL Server database. I take
this column using a Web Service and show it in a TextBox in a Web
Application. I want the format of the date to be
"dd\mm\yyyy hh:mm:ss". The collation name of the database is
SQL_Latin1_General_CP1_CI_AS (if it necessary I could change it).
In the Web service and in the Web App I don't change anything about
culture and the text box shows "mm/dd/yyyy hh:mm:ss AM/PM" .
I use a DataSet to get the data from the database (fill it with
SqlDataAdapter).
What could I do to fix this problem?
Thanks.