3
Answers

Integrating music with C#

Photo of zeeshan_tc

zeeshan_tc

20y
1.9k
1
Hi all Doing a project this year for my degree to create a music production desk in C# using MIDI Anybody have any ideas as to how I would go about integrating the two? Thanks for your time. Ziggy

Answers (3)

0
Photo of Suthish Nair
NA 31.7k 4.6m 14y
Crish, don't post or promote unwanted links here again. We already warned and blocked your user login once. Next time there will be no warning.
0
Photo of Crish
NA 3.7k 76.4k 14y
0
Photo of Rohatash Kumar
NA 25.1k 18.7m 14y
I think

For example, I've an Order table with a DateTime field called OrderDate. I want to retrieve all orders where the order date is equals to 01/01/2006. What's the best way?

  1. WHERE DateDiff(dd, OrderDate, '01/01/2006') = 0
  2. WHERE Convert(varchar(20), OrderDate, 101) = '01/01/2006'
  3. WHERE Year(OrderDate) = 2006 AND Month(OrderDate) = 1 and Day(OrderDate)=1
  4. WHERE OrderDate LIKE '01/01/2006%'
  5. WHERE OrderDate >= '01/01/2006'  AND OrderDate < '01/02/2006'
  6. ...
In my opinion the best way in terms of performances is the 5

WHERE OrderDate >= '01/01/2006'  AND OrderDate < '01/02/2006'

0
Photo of Amit Choudhary
NA 27.7k 3m 14y
hi vishnu,

Use the
DATEDIFF ( datepart , startdate , enddate )
function here the datepart can be days, month or years so you have to mention the days.
and startdate will be date of you have changed your password last time and the end date will be the +30 days of current date.
now you can check it for if 30 days are over or today is last date.

difference the todays date with end date. if the value is +ve then no need to show the link and if its -ve or 0 then show the link for change password.

Hope this make sense to you.


Thanks.