G
Guest
Hi expart,
I have facing the problem of formatting the datetime in Dropdownlist.
I am using Data Reader to retrive the date data from Sql2000 server
and bind to DropDownList Control.
The default format showing in the DropDownList is "MM/dd/yyyy".
I want to change the format to "dd/MM/yyyy".
The code sample as below.
sqlconn.open()
dim sqlcomm as sqlclient.sqlcommand
sqlcomm.commandtext = "select testdate from testtable"
sqlcomm.commandtype= commandtype.text
sqlcomm.connection= sqlconn
dim sqldareader as sqlclient.sqldatareader
sqldareader = sqlcomm.executereader
testdropdownlist.datasource=sqldareader
testdropdownlist.databind
anyone can help me how to program to change testdropdownlist datetime format.
I have facing the problem of formatting the datetime in Dropdownlist.
I am using Data Reader to retrive the date data from Sql2000 server
and bind to DropDownList Control.
The default format showing in the DropDownList is "MM/dd/yyyy".
I want to change the format to "dd/MM/yyyy".
The code sample as below.
sqlconn.open()
dim sqlcomm as sqlclient.sqlcommand
sqlcomm.commandtext = "select testdate from testtable"
sqlcomm.commandtype= commandtype.text
sqlcomm.connection= sqlconn
dim sqldareader as sqlclient.sqldatareader
sqldareader = sqlcomm.executereader
testdropdownlist.datasource=sqldareader
testdropdownlist.databind
anyone can help me how to program to change testdropdownlist datetime format.