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
13101 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

Explain the difference in record set and dataset?

875

What is XML serialization

976

What is ole access?

884

What is datasource in ado.net?

1021

What is the meaning of executenonquery?

962

How would you connect to database using .NET?

982

What is Serialization in .NET? what are the types of Serialization?

1024

How to identify the updated rows in a dataset?

973

What is connection in ado.net?

890

What are the essential features of ado.net?

896

What is ole db query?

922

Define connection string?

1013

What is the difference between Data adaptor and Data set?

975

What are the major challenges in accessing data from a database?

961

What is a control toolbox?

902