XSD Files in asp.net preview data

I have created a Stored Procedure in SQL and have configured it to be used with DataTables. The stored Procedure accepts 3 variables. 1. 3635 (Int) 2. NotMeeting (AnsiString) 3. 1 (Boolean)

When i want to preview the output after inserting values into the "Preview Data" function in DataTables, i get the following error:

"Failed to convert parameter value from a String to a Boolean".

I tried putting single speechmarks around '1' & double speechmarks of "1" but it makes no difference.

This works fine if i execute it in SQL Server Management Studio开发者_如何学JAVA (i.e. exec dbo.EXSP_CIA_Events_Timeline_List @Ext_Acquisition_ID=3635,@CalcType='NotMeeting',@UseCompleteTasks=1 ) Any clues?

I think you are maybe using ADO.net, in which case, you don't pass 1 to the SqlParameter, you would pass an actual boolean value (e.g. true/false).