Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

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

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

Answer / arunananth

SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]

Is This Answer Correct ?    2 Yes 0 No

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

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

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

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

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

Answer / himanshu

select col1,col2,TO_CHAR(DateTime.Now(),"dd/mm/yy") as date1
from table1

Is This Answer Correct ?    0 Yes 0 No

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

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

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

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

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

Answer / shivani

SELECT col1,col2 Convert(Varchar(20),Now(),3) as PerDate
FROM Table

Is This Answer Correct ?    1 Yes 3 No

suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validat..

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

Post New Answer

More ADO.NET Interview Questions

FetCh Records No 5 to 10 From Dataset

4 Answers  

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

0 Answers  

What provider ADO.net use by default ?

5 Answers   Accenture, BirlaSoft, Wipro,

What are the major challenges in accessing data from a database?

0 Answers  

What are the features of ado.net?

0 Answers  

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  

Define the data provider classes that is supported by ado.net?

0 Answers  

What is the difference between OLEDB Provider and SqlClient?

0 Answers  

What providers does Ado.net uses?

0 Answers  

What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

0 Answers   CGI,

Explain the difference in record set and dataset?

0 Answers  

Which provider is used to connect ms access, oracle, etc…?

0 Answers  

For more ADO.NET Interview Questions Click Here
Categories