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
13442 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 connected architecture in ado.net?

1075

What is the return type of executescalar?

1019

What is the difference between DataReader and DataSet in ADO.NET?

1167

What is data access pattern?

950

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

2145

What connected data?

967

What is the difference between dataset and datatable?

1016

What is untyped dataset?

1094

What is sqldatasource?

929

What is ado asp?

1004

What are the drawbacks of using ado.net?

981

What is bubbled event?

980

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

872

Describe the disconnected architecture of ADO.NET’s data access model.

1065

What is ado recordset?

998