how to set the validation error

venkatesh duddukuri

9y825SQL

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
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 duddukuri9y ago
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 P9y ago
how are you passing selected values to sp?. From where you are passing there you can validate it
Nitin Sontakke9y ago
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 duddukuri9y ago
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 Sontakke9y ago
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)?