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
13143 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 execute scalar in ado.net?

911

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

872

describe the dataset object in ado.net.

913

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

968

What is the use of adodc?

948

How to check if the Dataset has records ?

952

What is ole word?

902

Describe ado.net object model in detail.

952

What is data control techniques?

903

What is difference between connected and disconnected architecture in ado.net?

1111

Explain the difference between an ado.net dataset and an ado recordset?

1009

What are the rules to implement connection pooling?

1009

What is the namespaces being used to access oracle database?

1010

Which is faster entity framework or ado.net?

884

Explain the difference between ado and ado.net?

886