"how to get odd saturday in a month in c#" Code Answer's
You're definitely familiar with the best coding language C# that developers use to develop their projects and they get all their queries like "how to get odd saturday in a month in c#" answered properly. Developers are finding an appropriate answer about how to get odd saturday in a month in c# related to the C# coding language. By visiting this online portal developers get answers concerning C# codes question like how to get odd saturday in a month in c#. Enter your desired code related query in the search bar and get every piece of information about C# code related question on how to get odd saturday in a month in c#.
how to get odd saturday in a month in c#
int year = 2016; // 366 days in 2016 because leap year
DateTime yearStart = new DateTime(year, 1, 1);
int daysInYear = (yearStart.AddYears(1) - yearStart).Days; // 366
var oddSaturdays = Enumerable.Range(0, daysInYear)
.Select(day => yearStart.AddDays(day))
.Where(date => date.Day % 2 == 1 && date.DayOfWeek == DayOfWeek.Saturday);
foreach (DateTime oddSaturday in oddSaturdays)
{
// ...
string sql = string.Format("INSERT INTO {0}.[WEEKEND] ([DATE],[DAYNAME]) VALUES (@DATE, @DAYNAME)", schemaname);
using (var cmd = new SqlCommand(sql, con))
{
cmd.Parameters.Add("@DATE", SqlDbType.Date).Value = oddSaturday;
cmd.Parameters.Add("@DAYNAME", SqlDbType.VarChar).Value = oddSaturday.DayOfWeek.ToString();
int inserted = cmd.ExecuteNonQuery();
}
// ...
}
Source: stackoverflow.com
All those coders who are working on the C# based application and are stuck on how to get odd saturday in a month in c# can get a collection of related answers to their query. Programmers need to enter their query on how to get odd saturday in a month in c# related to C# code and they'll get their ambiguities clear immediately. On our webpage, there are tutorials about how to get odd saturday in a month in c# for the programmers working on C# code while coding their module. Coders are also allowed to rectify already present answers of how to get odd saturday in a month in c# while working on the C# language code. Developers can add up suggestions if they deem fit any other answer relating to "how to get odd saturday in a month in c#". Visit this developer's friendly online web community, CodeProZone, and get your queries like how to get odd saturday in a month in c# resolved professionally and stay updated to the latest C# updates.