How to catch error while inserting data with SqlDataSource

Question

I have a SqlDataSource and a GridView.

What I want to do is, while the query is executed (i.e. for inserting a data), then after the data has inserted successfully, it should appear a message sounds: "The data deleted successfully". I've solved it by using GridView1_RowDeleted method.

Now the problem is, I want to catch the error while the query is failed to executed. If the query has failed to execute, then it should appear a message: "The data failed to insert.".

How to do it? I don't have an idea about this.

Need your help guys.

Thanks a lot.

Glory Raj · Accepted Answer · 2011-10-30 14:48:34Z

3

You should be able to add a handler for the relevant event: inserted, deleted. Then, in the handler look at the SqlDataSourceStatusEventArgs property Exception. If it's not null then an exception has occurred. For example if the selected command threw an exception:

protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
   if (e.Exception != null)
   {
       // handle the exception
   }
}

--

answered Oct 30, 2011 at 14:48

Glory Raj

17.7k28 gold badges115 silver badges216 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mrjimoy_05 Over a year ago

hey it's worked!! :) . I've tried to change the handler become:

Protected Sub SqlDataSource1_Updated(sender As Object, e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SqlDataSource1.Updated

. Thanks a lot :)

Collectives™ on Stack Overflow

How to catch error while inserting data with SqlDataSource

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related