Click here to Skip to main content
15,897,704 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how can i retreive data from the database in between two dates by giving Date inputs in an html page(front-end).Help me regarding this..Thank U
Posted
Updated 10-Feb-14 3:33am
v3
Comments
Kornfeld Eliyahu Peter 10-Feb-14 9:58am    
Have you done anything so far? Show some effort (code or searching)! As is it ain't a question...

1 solution

Which database are you using you can use javascript to get the records like below:

You can use javascript library called ACCESSdb which can be found here:ACCESSdb[^]

C#
function SelectRecords(startdate, enddate) {
var adoConn = new ActiveXObject("ADODB.Connection");
var adoCmd = new ActiveXObject("ADODB.Command");

adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\dbName.mdb'");
adoCmd.ActiveConnection = adoConn;
adoCmd.CommandText("Select * From tblName Where Date between startdate and enddate");
adoCmd.Execute();

adoConn.Close();
}


Ref:Here
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900