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

What is ole in vb?

952

What is a sqldataadapter?

1057

What is the difference between dataset and datatable?

1071

Explain the difference in an abstract class and an interface?

975

Difference between sqlcommand and sqlcommandbuilder?

1190

What is serialization and de-serialization in .net? How can we serialize the dataset object?

1017

How do you merge 2 datasets into the third dataset in a simple manner?

1058

What is the difference between ado.net and oledb?

1003

What is ado.net in vb net?

965

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

1016

What is difference between executequery and executeupdate?

1097

Explain sqlconnection object?

1066

Which is faster sqldataadapter and sqldatareader?

979

Compare Data Reader & Dataset in ado.net?

1046

Explain the difference between data reader and data set?

969