Hello Rajiv,

That is weird, why cannot you remove the InsertCommand from the SqlDataSource if you are manually calling the stored procedure? In any case, then I believe you can cancel the event directly from the datasource itself, rather from the grid, in the SqlDataSource.Inserting event, e.g.

    protected void SqlDataSource1_Inserting(object sender, SqlDataSourceCommandEventArgs e)
    {
        e.Cancel = true;
    }

Hello Rumen,

My Data source looks something like this:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testdbConnectionString %>"

InsertCommandType="StoredProcedure" InsertCommand="InsertTimeSheet">

<InsertParameters>

<asp:Parameter Name="LaborID" Type="Int16" />

<asp:Parameter Name="Weekend" Type="DateTime" />

<asp:Parameter Name="STHrs" Type="Decimal" />

<asp:Parameter Name="OTHrs" Type="Decimal" />

<asp:Parameter Name="PRHrs" Type="Decimal" />

</InsertParameters>

I can't really remove the InsertCommand as I want the data to beinserted in the database but I don't want the Insert to happen automatically.

I need to use the AddRowBatch event as I have to insert multiple items together in one go on the postback.

I debugged and found that the AddRowBatch event is triggered but the data is still inserted in the database. I checked the AddRow event but even that doesn't seems to work for me.

Thanks & Regards,

Rajiv 

Hello Rajiv,

If you are using declarative SqlDataSource, can't you just delete the InsertCommand that is probably autogenerated by the SqlDataSource wizard (the one in bold in the example below)

 <asp:SqlDataSource ID="SqlDataSource" runat="server"
        DataFile="~/App_Data/Nwind.mdb"
        DeleteCommand="DELETE FROM [Employees] WHERE [EmployeeID] = ?"
        InsertCommand="INSERT INTO [Employees] ([EmployeeID], [LastName], [FirstName], [Title], [TitleOfCourtesy], [BirthDate], [HireDate], [Address], [City], [Region], [PostalCode], [Country], [HomePhone], [Extension], [Photo], [Notes], [ReportsTo]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
        SelectCommand="SELECT * FROM [Employees]"
        UpdateCommand="UPDATE [Employees] SET [LastName] = ?, [FirstName] = ?, [Title] = ?, [TitleOfCourtesy] = ?, [BirthDate] = ?, [HireDate] = ?, [Address] = ?, [City] = ?, [Region] = ?, [PostalCode] = ?, [Country] = ?, [HomePhone] = ?, [Extension] = ?, [Photo] = ?, [Notes] = ?, [ReportsTo] = ? WHERE [EmployeeID] = ?">

Also, are you sure that you need AddRowBatch event (works only if you add multiple rows on the client at once and then postback at server)? Can you verify this event fires by placing a breakpoint on it? Can you check the same e.Cancel logic with AddRow event instead?

Thank you for the Reply.

I am using the the Stored procedures for selecting and inserting data in the SQLDataSource.  I tried to use the UltraWebGrid1_AddRowBatch event to cancel the insert operation using  e.Cancel = true;. But for some reason the insert opertaion is not cancelled and the data gets inserted in the database.

Could you please let me know why this is happening and how to fix this?

Thanks & Regards,

Rajiv