SQL Query or Linq query to get number of Events per Day.

Question

SQL query or linq query to get the number of events per day for each and every record (Id), Event Jupiter, Earth and Mars comes under 7th Date so number of events is 3(considering time).

1. A event can start and end in the same day.

2. A event can start today and end after 3 days.

 

Table Name: **Events**

 

Id	Name	StartDateWithTime	EndDateWithTime
1	Sun	2017-11-28 00:00:00.000	2017-11-29 0:00:00.000
2	Moon	2017-11-28 00:00:00.000	2017-12-01 10:00:00.000
3	Earth	2017-11-07 00:00:00.000	2017-11-30 00:40:00.000
4	Jupiter	2017-11-07 00:00:00.000	2017-11-07 20:00:00.000
5	Mars	2017-11-07 10:00:00.000	2017-12-07

 

SQL query or linq query to get the number of events per day

Answer 1

Ok, how does this translate to the RTB control?

With properties such as Font, ForeColer, BackColor etc. It's simply a matter of selecting the text you want (best done via REGEX) then changing the back and forecolors.

So I think your question is how do I filter incoming ASCII data?  Use REGEX
How do I apply the formatting to the data? Use the RTB.properties and methods.

Answer 2

In the font world there are two types of fonts proportional and non-proportional.  Try using Courier New, it is a non-proportional font.

Your other issues, that of knowing the differences between RTF and regular text files is summed up with this statement: "They are both standards-based ways to present data to the end user."  

Here's the RTF standard.

http://www.microsoft.com/downloads/details.aspx?FamilyID=e5b8ebc2-6ad6-49f0-8c90-e4f763e3f04f&DisplayLang=en 

A Rich Text Box supports this standard.

TextBox is a more simple "standard" that has much less overhead.  I don't know the standard for Textbox support but feel it must be pretty simply  ASCII characters with very simple font control.