sqlite

[jashimu]

Hi All, I am trying to create a report for every hour based on a selected day. I am trying to use sql statement. For example, I have dateTimePicker and I select a dy of a month then it should get all the data that took place from 12am to 11pm for every hour. FYI : my database sqlite. coding in C# thanks for any help in advance.

[Dimitri Witkowski]

And what is the problem? :)

See my article about Windows 7 Taskbar timer here on CodeProject

[jashimu]

Thanks Dmitry, I am not an expert in sql. therefore, I don't know how to do that. FYI: TableOne has Column Sell, quantity, emID,orderDate,shipDate. I want to know how many sell was made on a given day. And how many sell was made per hour in a gaven day(24 hours).

[Dimitri Witkowski]

You should create a query with condition, like this: select count(*) from TaleOne where shipDate between <start_date> and <end_date> You can google and find how to use queries in sqlite, there are plenty of such info.

See my article about Windows 7 Taskbar timer here on CodeProject

[Bassam Saoud]

SELECT COUNT(SELL) FROM TableOne GROUP BY CONVERT(DATETIME, orderDate, 101) The convert is to use short date For the hour look at DatePart[^] It is always good to read a book or tutorials before jumping to development.

[Dimitri Witkowski]

SQLite doesn't have DatePart; you should save dates as long in sqlite.

See my article about Windows 7 Taskbar timer here on CodeProject

[jashimu]

Thanks all for your help. I will try to do this at the same time I am going to read books on sql thanks.

[Bassam Saoud]

My bad - missed that fact that its a SQlLite question. Nice article by the way.