select col1,col2,TO_CHAR(DateTime.Now(),"dd/mm/yy") as date1 fro

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

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

Answer Posted / himanshu

select col1,col2,TO_CHAR(DateTime.Now(),"dd/mm/yy") as date1
from table1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is linq and entity framework?

978

What are the advantage of ado.net?

971

Which property is used to check whether a DataReader is closed or opened?

1030

What is the functionality of data provider in ado.net?

915

What is an example of ordinal data?

1118

What is the difference between executenonquery () and executescalar ()?

942

What is executenonquery ado.net?

917

What is the difference between ado.net and oledb?

930

Explain the various objects in dataset.

970

What is full form of ado?

1032

Can we do database operations without using any of the ado.net objects?

965

What are the different row versions available in table?

949

Which method in OLEDBAdapter is used to populate dataset with records?

1002

Explain the difference in record set and dataset?

921

What are the Data providers in ADO.Net?

997