web form validations

Question

How to validate fields on form before submitting data into database in web form.

my web form consists two fields 1.productname

                                                    2.quantity

before insert into database,verify that text box field is empty or not  and after insert that fields should empty.