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
13201 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 between ado and ado.net?

895

What are the namespaces used in ado.net for data access?

946

differance between ADO vs ADO.Net?

1014

Is it possible to load multiple tables in a Dataset?

1020

What is different between sqlcommand object and command behavior object?

1008

What is a control toolbox?

919

What provider ado.net use by default? Explain the role of data provider in ado.net?

939

What is executenonquery ado.net?

903

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

977

What are all the different authentication techniques used to connect to MS SQL Server?

1029

What are all components of ADO.Net data provider?

1028

What are the types of databinding?

951

What is dao and ado?

893

What are the objects of ado.net?

1032

What is ado rdo dao in visual basic?

1120