How to validate user input with MS SQL Table ?

Hi Community,

I have a user input task on my site. User fills the data and the data goes into MS SQL table.

I have a field (say PR No.) in my form. I want to validate the the data entered by user in the PR filed on the fly with my table to check whether PR No. entered by user exist in my table or not ?

How can i do it ?


Thanks for your help.

  Discussion posts and replies are publicly visible