CODEWITHSUNDEEP
vb.nettry-catchsqldatasource
mrjimoy_05
mrjimoy_05

Reputation: 3578

How to catch error while inserting data with SqlDataSource

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.

Upvotes: 0

Views: 3464

Answers (1)

Glory Raj
Glory Raj

Reputation: 17701

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
   }
}

--

Upvotes: 3

Related Questions