SELECT col1,col2 Convert(Varchar(20),Now(),3) as PerDate FROM Table

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 / shivani

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

Answer Posted / shivani

SELECT col1,col2 Convert(Varchar(20),Now(),3) as PerDate
FROM Table

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

917

What are the different execute methods of Ado.Net?

972

What is aggregate root?

998

What is ado.net architecture?

878

What is the maximum pool size in ado.net connection string?

888

Define different execute methods of ADO.NET command object ?

1003

How can we check that some changes have been made to dataset since it was loaded?

917

What is the use of SqlCommandBuilder?

1146

How is it possible to get 2 tables of data at a time by using data reader?

904

What does sqldatareader return?

914

What are the drawbacks of using ado.net?

920

What is ole used for?

889

What is ado.net object model?

918

What are the key features of ado.net?

1126

What are three methods for displaying data in a syncfusion datagrid

1015