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
Answers were Sorted based on User's Feedback
Answer / prashant kamble
first way , we are go in gridview property in that edit
column in that select that field name and make it item
template. after that right click gridview in that edit item
templated and select that field and then drag regular
expression validator in that column and give regular
expression .
Is This Answer Correct ? | 17 Yes | 1 No |
Answer / arunananth
SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raja
Regular expression will be
^(0[1-9]|[12][0-9]|3[01])[-/.](0[1-9]|1[012])[-/.](19|20)\d\d$
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gt
its is very simple just u go to the sql database,change the
related database table like
SELECT col1,col2 Format(Now(),dd/mm/yy) as PerDate
FROM Table
and provide the parameters
(Asper my knowledge(iam not sure))
Is This Answer Correct ? | 6 Yes | 6 No |
Answer / himanshu
select col1,col2,TO_CHAR(DateTime.Now(),"dd/mm/yy") as date1
from table1
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / kishore
its is very simple just u go to the sql database,change the
related database table like
SELECT col1,col2 Format(Now(),dd/mm/yy) as PerDate
FROM Table
and provide the parameters
(Asper my knowledge(iam not sure))
Is This Answer Correct ? 2 Yes 2 No
0
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / shivani
SELECT col1,col2 Convert(Varchar(20),Now(),3) as PerDate
FROM Table
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / kishore
related database table like
SELECT col1,col2 Format(Now(),dd/mm/yy) as PerDate
FROM Table
and provide the parameters
(Asper my knowledge(iam not sure))
Is This Answer Correct ? 2 Yes 2 No
0
Gt
Is This Answer Correct ? | 0 Yes | 3 No |
What we do with the object of ado.net dataset after using it?Can we dispose it or can we set it nothing?Is it must or not?
How can we serialize the dataset object?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is the default provider in ado.net?
What are two types of transaction supported by ado.net?
What are the drawbacks of using ado.net?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
How to fetch the last inserted record in a particular table?
10 Answers CarrizalSoft Technologies, Microsoft,
Using Ado.net, what front ends and back ends can you use?
What is the difference between ado.net and entity framework?
How to load multiple tables into a dataset?