hh..
how can i get the value accumulated from the date i select from datetimepicker1 to datetimepicker2 in vb.net and mysql? the value here refers to the daily sales and i need to find the total sales between the range dates that i choose..
please help me..as im beginner and my knowledge is limited..
thanks in advance..
abc_123abc
0
Newbie Poster
Recommended Answers
Jump to PostYou didnt say exactly where from, so I will assume from database.
You can write an sql query that will look like:Dim sqlQuery As String = "SELECT * FROM MyTable WHERE DateColumn >= @param1 AND DateColumn <= @param2" 'by using sqlcommand you then define parameters: cmd.Parameters.Add("@param1", …
All 4 Replies
Mitja Bonca
557
Nearly a Posting Maven
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
abc_123abc
0
Newbie Poster
gd740
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.