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
13343 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 difference between oledb sql server and oledbdotnet provider?

996

How do you implement locking concept for dataset?

980

What is Data view?

1051

Describe the disconnected architecture of ADO.NET’s data access model.

1043

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

943

What is ado.net and its architecture?

1146

How to work with disconnected data - the dataset and sqldataadapter?

968

What does executenonquery () method return?

913

What are the key features of ado.net?

1181

Why edit is not possible in repeater?

934

What is difference between Dataview and Datatable?

1051

What is microsoft ado?

982

Why do we use sqldataadapter?

938

Which object is used to add relationship between two Datatables?

1029

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

1033