I have to deal with a Stored procedure which is commiting the query after executing the query. I have to control the transaction at the application level with .NET. Hows it possible to control the transaction of this stored proc which is doing a commit inside its body...I cannot control the transaction's rollback or commit in the application with .NET's tran control as the decision of commit is being made at the stored proc level..Is there a solution...

I have a dropdownlist which has a OnSelectedIndex Changed event set. It fires when the selection changes. The user will use the keyboard to briwse the selection instead of using the mouse to drop down the list to see all the options. However, when the user uses the keyboard to scroll up or down the list, the above event fires on every scroll up or down which I do not want. Is there a way that I can make the control keyboard friendly?