Can you give me an example or guidance how i can create and call an onsubmit related event so that upon submit I can execute a string of sql statements to inject content from that form submission to a sql table, or call a stored procedure using the form variables as parameters.

I have a xmpro tabel thats being populated on submit , but a I have anothe tabel table that needs that data too...
also thinking ..can i have multiple submit statements for that addform.... i suppose i could also define a trigger ... any suggestions welcome

Thanks !!

The best way is to use a stored procedure. To do this, use the EXEC command in your command text. So, if your stored procedure is called "AddContact" and takes two parameters "Name" and "Address", your SubmitCommand might look like this:

<SubmitCommand CommandText="EXEC AddContact @Name, @Address" />

In your form, presumably, you would have some fields tied to this parameters:

<TextBox id="txtName" DataField="Name" DataType="String" />
<TextArea id="taAddress" DataField="Address" DataType="String" />

if i already had an insert statement in the submit woul dI need to move that to the stored procedure or can I just add a second submit command ?

You would need to move your INSERT statement into the stored procedure