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

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

839

Give an example of a .net application which connects to microsoft access database using ado.net classes.

1097

What is dataset and datatable in ado.net?

949

What is ado.net code?

904

What is ado rdo dao in visual basic?

1123

What is Data view?

1023

What is ado or jdbc?

891

What is the difference between oledb sql server and oledbdotnet provider?

976

What is the current version of entity framework?

929

What is acid in ado.net?

978

What are dcl commands?

973

Command objects uses, purposes and their methods.

952

What does adodb stand for?

1004

Which is faster sqldataadapter and sqldatareader?

885

Explain ODP.net

951