Comments by charliedev (Top 29 by date)

windows form

doesn't work with me :/ it gives me a blank line

I'm sorry what query?

thanks

thanks!

This is working, thanks :)

i did not use any code. just made a textbox and typed on it

yea, but i only need last number

Thanks, and can you help me with this question:

http://www.codeproject.com/Questions/773673/Count-items-in-column-by-date-SQL

i seem to be having some problems

i mean column, new column :/ that shows count

i tried it but it wont work. this is my code:

SELECT LEFT(queueno, 1) AS QueueInitial, COUNT(*) AS Count, CONVERT(varchar(10), qdate, 101) AS DateToday
FROM TRN_Queue
GROUP BY qdate

this is error:
TRN_Queue.queueno is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

i already tired it. I used this code:

SELECT LEFT(queueno, 1) AS QueueInitial, COUNT(*) AS Count, CONVERT(varchar(10), qdate, 101) AS DateToday
FROM TRN_Queue
GROUP BY qdate

this is error:
TRN_Queue.queueno is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

can you post your current code?

what do you mean? do you want to display the items of you gridview to your combobox?

Oh, lol did not know there was such a thing :)) Thanks so much!

i didn't make any bindingsource

so i will really have to make a bindingsource?

this is it! thanks

Nice, thanks :)

follow up question, what is the "dd" for in this line:
where Cast(DATEDIFF(dd, datetoday, getDate()) as int) =0

This is perfect! Thanks so much :)

oh, so i can't really have a datetime column that shows the date only.

Yes, I want to see the records for today only.

MS SQL Server