I m building report in MII SSCE where I want to execute update query on click of button. But I dont want to update any grid/chart in page.
I think icommnad can work but not sure how to use it.
Can anyone help me this?
iCommand is for executing SQL scripts that perform a task. It is similar to Fixed Query, but does not return a result set. So for doing updates, creates, or deletes, one should always use iCommand queries. Fixed Query will execute similarly (and usually successfully), but will show an error (No Results Returned or some such).