Excute Stored Procedure When Report Completes

Does anyone know how to execute a stored procedure when a report is
completed? Is there possibly an on report end event or something i can
use perhaps? Any ideas?I dont know of a way, but if you tell us what you are ttrying to do there may
be another way of doing it.
"digitor" wrote:
> Does anyone know how to execute a stored procedure when a report is
> completed? Is there possibly an on report end event or something i can
> use perhaps? Any ideas?
>

Excel to Sql

Hi,
I want to convert excel sheet data to sql database.I have completed it using OLEDB connection and sql query.I retrieved the data from excel and bind the data into dataset using OLEDataAdapter and then dataset content will be displayed on grid.If the excel sheet data is of same datatype means it is working properly.See the excel sheet example...

Name Mark1 Mark2
Ram 87 76
somu 45 65
james 65 98

When converting this excel to sql it is working properly..
See the problem below..

Name Mark1 Mark2
Ram 87 76
somu 45 AB
james 65 98

when i am giving 'AB' to mark it shows null value at that specified column(ie,blank space on grid for the data 'AB').
This is my problem...How can i rectify this...Any alternative solutions...

You need to check your database column's datatype. The problem you are running into is most likely the target column is a numeric column.

Let me know whether you can fix the problem by change the data type of the column, keep the data type consistent in your code too.

|||May i know,the way to convert excel t sqlserver database table|||You can simply use Import/Export Wizard in SQL Server