PostBackURL on button inside Repeater ItemTemplate

[Annyka]

I've got a button inside a Repeater control Item Template

I'm doing a SQL insert using a SqlDataSource Control based on the RepeaterName_ItemCommand event, since the button in the template isn't available on the code behind file for a click event.

After the SQL command has run, I'd like to post back to another page.

When I set the PostBackURL property, it posts back before the insert is performed.

Can I either:

1. use code in the RepeaterName_ItemCommand Sub that will do the postback after the SQLDataSource.Insert() statement

or

2. do something in a script blog on the aspx page itself using the onclick event set in the button. I've just tried that and while the insert worked, when I add the PostBackURL to the button, it does the postback before the onclick event again.

How can I manage both?

[Annyka]

The obvious hits me --

Response.Redirect(url)

Never mind!