just try to this.This is working good SELECT convert(nvarchar,colname,11

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

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

Answer Posted / ravi

just try to this.This is working good

SELECT convert(nvarchar,colname,110)as PrDate from Table

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define isolation?

1024

What are the benefits of using of ADO.NET in .NET 4.0?

1151

Explain what are the steps to connect to a database?

1016

Explain how to find the given query is optimised one or not?

1092

Does entity framework use ado.net?

1022

Explain the various objects in dataset.

1048

What are the benefits of ADO.NET?

1172

What are the 3 major types of connection objects in ado.net?

1051

What is ado object model?

992

What is disconnected scenario in entity framework?

1164

differance between ADO vs ADO.Net?

1133

Explain the architecture of ado.net?

1129

What is a dynaset in access?

1107

Define data access layer?

1012

What is the difference between typed and untyped dataset?

1162