CODEWITHSUNDEEP
c#asp.netsql
jinaljagani
jinaljagani

Reputation: 37

How I can count data according to day?

I do like this to count job_id

Code:

string cmdstr3 = "SELECT COUNT(job_id) FROM applied_jobs 
                  WHERE js_id='" + jsId + "' AND apply_date='" + DateTime.Now.Date + "'";`

string cmdstr4 = "SELECT COUNT(job_id) FROM applied_jobs 
                  WHERE js_id='" + jsId + "' AND (apply_date >='" + start_date.Date + "' AND apply_date <'" + end_date.Date+ "')";

but it counts as 0

I have data like this 

3/6/2012 12:00:00 AM
3/6/2012 12:00:00 AM
3/5/2012 12:00:00 AM

Upvotes: 0

Views: 156

Answers (1)

Shekhar_Pro
Shekhar_Pro

Reputation: 18420

It seems you want to get the count of entries for Current Date of a Certain js_id. Here is what simply you should do:

var cmd = new SqlCommand("SELECT COUNT([job_id]) FROM [applied_jobs] WHERE [js_id] = @jsid AND datediff(day,[apply_date], @applydate) = 0",cn);
cmd.Parameters.Add("@jsid", SqlDbType.Int).Value = jsId;
cmd.Parameters.Add("@applydate", SqlDbType.SmallDateTime).Value = DateTime.Now.Date;

Upvotes: 1

Related Questions