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
13663 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 the default Timeout for SqlCommand.CommandTimeout property?

1067

What is ado.net objects?

1010

Explian About DataAdapters

1088

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1083

Explain ado.net features?

1102

What are the parameters that control most of connection pooling behaviours?

1119

What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

1078

What is connected architecture in ado.net?

1182

Explain advantages of ado.net?

1097

What is disconnected scenario in entity framework?

1165

Explain the difference between data reader and data adapter?

1017

How to identify the updated rows in a dataset?

1053

What is two way data binding android?

1029

Some important instruction regarding ADO.NET connection string ?

1044

What is the difference in an abstract class and an interface?

1067