how to set the validation error

Question

Dear All I am develop the help Sp but i dont know how to set validation error . kindly give the suggetion. Note : if select multiple options show error Ex : select multiple months in help show error message if (@paramname= 'Month') begin select 'ALL' 'GRDPARAMVALUE' union all SELECT distinct DATENAME(month schedule_date) 'GRDPARAMVALUE' from tmscd_emp_gre_calendar_vw m where master_ou=@ouinstance end

Rafnas T P · Answer

then check like this in click event from begin if( checkbox1 .IsChecked==true&& checkbox2 .IsChecked==true) { //message goes here return; } red are check boxes names

venkatesh duddukuri · Answer

i am using the check boxs click the two check boxs and click OK button . after click the ok button disply the validation msg like multiple selection are not passible select only one

Rafnas T P · Answer

how are you passing selected values to sp?. From where you are passing there you can validate it

Nitin Sontakke · Answer

Okay. Got it. So it is a front-end validation. But the code you are sharing here is sql used to fetch the data to populate the control. Which control are you using in front-end? Why not use something like drop-down list where such a mistake just cannot be done. It is a good UI practise that let not user commit the mistake in first place than allow him to commit mistake and then show error message.

venkatesh duddukuri · Answer

for example calender months like jan feb select more then one select the ok button show the error message multiple options are not possible

Nitin Sontakke · Answer

Not sure how you are planning to handle validation error message in stored procedure. Are you referring to user input validation on front-end? If yes then it would go somewhere in business logic or model attribute. If no what is it that you are validating and most importantly where (which layer)?