Arranging Holidays

Hello
In my ASP 2.0 website, I wish to arrange holidays and specific days from database with using Sql Server. What SQL query I must add to this following code? If you can post the required codes, I'd be most thankful. Regards.private DateTime _siparis;public DateTime Siparis

{

get { return _siparis; }set { _siparis = value; }

}protected void Button1_Click(object sender, EventArgs e)

{Timer1.Enabled = true;

DateTime sonTarih = DateTime.Today.AddDays(1).AddHours(13);Session["siparis"] = sonTarih;

TimeSpan aradakiFark = sonTarih - DateTime.Now;StringBuilder sb = new StringBuilder();

sb.Append("Remaining time is ");if (aradakiFark.Days > 0)

{

sb.Append(aradakiFark.Days.ToString());sb.Append(" days ");

}if (aradakiFark.Hours > 0)

{

sb.Append(aradakiFark.Hours.ToString());sb.Append(" hours ");

}if (aradakiFark.Minutes > 0)

{

sb.Append(aradakiFark.Minutes.ToString());sb.Append(" minutes ");

}

lblSure.Text = sb.ToString();

}protected void Timer1_Tick(object sender, EventArgs e)

{DateTime sonTarih = DateTime.Today.AddDays(1).AddHours(13);

TimeSpan aradakiFark = (DateTime)Session["siparis"] - DateTime.Now;StringBuilder sb = new StringBuilder();

sb.Append("Remaining time is ");if (aradakiFark.Days > 0)

{

sb.Append(aradakiFark.Days.ToString());sb.Append(" days ");

}if (aradakiFark.Hours > 0)

{

sb.Append(aradakiFark.Hours.ToString());sb.Append(" hours");

}if (aradakiFark.Minutes > 0)

{

sb.Append(aradakiFark.Minutes.ToString());sb.Append(" minutes ");

}

lblSure.Text = sb.ToString();

}

}

 
I've tried a select query that uses getdate and returns me to the manually arranged holidays in the Holidays table, but I've failed.  I wish to do that, this query arranges holidays and adds +1 day on that holiday, if this one day added day is a holiday again, than adds one day again. How can I write this code? Thanks.