compare two date from two table in sqlserver

Question

Hello Everyone I have two table.. 1. Holiday -HolidayId -Description -HolidayDate - Status 2. EmployeeLeaves - LeaveId -EmployeeId -RequestedDate -LeaveReason -LeaveFrom -LeaveTo -LeaveStatus now when employee apply for the leave that time the HolidayDate will be compare with leaveFrom and LeaveTo date. suppose sir 11/11/2015 is holiday this is allready in Holiday table. now when employee apply for the same date for leave that time it will alert message is printed you can not apply for this day this is already holiday.I want this kind of output. can please help for this for procedure and apply in aspx page.

Rupali Shinde · Answer

Hi Manish Table Name - Holiday Column - HolidayDate DateType - Date using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = Server=...;Database=...;Trusted_Connection=true; conn.Open(); DateTime TodayDate = DateTime.Today; // Create the command SqlCommand cmd = new SqlCommand(SELECT * FROM Holiday WHERE HolidayDate = ' + TodayDate.ToString(yyyy-MM-dd) + ' conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); //DataTable firstTable = dataSet.Tables[0]; DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { DateTime CurrentDate = Convert.ToDateTime(dr[HolidayDate]); int result = DateTime.Compare(TodayDate CurrentDate); string relationship = ; if (result relationship = is earlier than; else if (result == 0) relationship = is the same time as; else relationship = is later than; } } If it works out Please Accept this as Answer

Manish Solanki · Answer

Hello sir can you give me some code so i can get some hint.

Jignesh Trivedi · Answer

Hi when you want to this message? At the time of date selection or on apply leave button also share your screen inputs...