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
13098 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 the difference between executenonquery () and executescalar ()?

881

What is difference between dataset and datatable?

1083

How to connect and retrieve data from database using dataset

983

What are all the different methods under sqlcommand?

920

What is shadow copy?

932

What is ado.net tutorial?

865

What are the various methods provided by the DataSet object to generate XML?

967

What is data reader in ado.net?

953

Explain sqlconnection object?

933

What is the use of ADO.NET and XML web services?

979

Can you explain how to enable and disable connection pooling?

920

What are basic methods of dataadapter?

923

What is method to get XML and schema from Dataset? getXML() and get Schema ()

922

What is ado connection?

896

How to add a check box or a dropdown list to a column in a datagrid?

921