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
13444 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 is difference in record set and dataset?

1079

What is the difference between data grid and data repeater?

1083

List all the steps in order, to access a database through ado.net?

1088

What does ado stand for in ado.net?

1109

What are three methods for displaying data in a syncfusion datagrid

1080

What are the key events of sqlconnection class?

1197

What are the steps you will take to improve performance?

896

What are the types of databinding?

997

What is ole2 format?

907

What is a control toolbox?

972

Is ado.net an orm?

970

What is the difference between Command and CommandBuilder object?

1249

What is the default Timeout for SqlCommand.CommandTimeout property?

1023

What is data view and variable view?

929

What are datareaders?

989