SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]

suppose we using gridview contrl,with sqldatasource.in that
for birth date how can we take validation contrl for
dd/mm/yy formator how we assign regular expression for same

Question Posted / arunananth

9 Answers
13333 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / arunananth

SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to maintain the relation between two tables in ADO.NET?

994

What is full form of ado?

1033

What is ole db query?

962

Define partial class?

941

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

984

What are the advantages of oledb compared with other classes?

2776

What are dcl commands?

987

What is ado.net architecture?

912

What is data relation?

882

What are the steps you will take to improve performance? Will you use dataset or datareader?

968

Give few examples of datareader that is used in different dataproviders.

957

What are the various methods provided by the DataSet object to generate XML?

988

What is partial class?

962

What is openrowset?

965

What are the ado.net objects?

924