Save Hijri Shamsi Date February 30 in Database using C# in ASP.Net

Mohammad...

SOLVED CLOSED ACTIVE ANSWERED
User: Mohammadmk
Posted: on Jan 08, 2018 01:18 AM
Forum: ASP.Net Web Forms
Replies: 6
Views: 7751

Hello everyone

any one help me how to store hijri shamsi date in sql server hijri shamsi date are used to in most countries like Afghanistan, Iran and many other countires if i take datetime 2 it works fine but in some months like February has 28 days but the month in hijri shamsi calendar has about 30 days

now the question is how to deal with this kinds of problems

one solution is come to my mind is to store the date in Gregorian date and then convert them into hijri shamsi date but i will create performance issues

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 3

Reply
User: Mudassar
Replied: on Jan 15, 2018 12:36 AM
Modified: on Jan 15, 2018 12:37 AM
Report

How will that work? Hijri Calendar Supports max 29 days in .Net. Your date itself is wrong.

See this below. How you must work with Hijri Dates.

protected void Page_Load(object sender, EventArgs e)
{
    System.Globalization.HijriCalendar hijri = new HijriCalendar();
    string date = "1396-02-29";
    DateTime hijriDate = new DateTime(int.Parse(date.Split('-')[0]), int.Parse(date.Split('-')[1]), int.Parse(date.Split('-')[2]), hijri);
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Save Hijri Shamsi Date February 30 in Database using C# in ASP.Net

Company

Explore

Follow us

Contact Us