Hello All,

Right now I am getting ready to write an onSubmit handler.

In the event handler, I would like to write a function that:

- validate some information in a text box Should be 'RO' + 6 numbers(ex. RO152465) 

- builds a SQL query based on checkboxes selected and then the values that are in the drop downs that would hold values that correspond with those checkboxes.

If you know of a quick and efficient way to write that, it would help out a lot.

Then the sweetness would be to have it pop out to a message box or a smaller webpage?(Grid Style) that would allow me to select a view of about 6-8 columns from tables that would have been joined as a result of the SQL query.

 I am using ASP.NET 2.0 w/ Visual Basic code behinds and MS SQL 2005.

 Any assistance is welcomed and appreciated,

 Kevin