howcan insert record Mon to Sata and Sun wll nt insert recod

Question

how can insert record Monday to Sataday and Sunday will not insert record in sql server

Dhanunjay Jajimoggla · Answer

Hi Krishna you many handle this scenario in following ways... 1) Client side function Validation(){ var dayName = new Date(); var weekday = new Array(7); weekday[0] = Sunday; weekday[1] = Monday; weekday[2] = Tuesday; weekday[3] = Wednesday; weekday[4] = Thursday; weekday[5] = Friday; weekday[6] = Saturday; if(weekday[d.getDay()] == Sunday) alert(U cant insert the values on Sunday.); return false; } else{ return true; } OR 2) .cs Page if(DateTime.Now.DayOfWeek.ToString()==Sunday){ // return some alert message } else { //call Insert method } 3)In Stored Procedure begin if(select datename(dwgetdate())=='Sunday') return 'There is no chance to insert the values on Sunday' else //your insert command OR 4) Use trigger also