English 中文(简体)
如何在用SqlDataSource插入数据时发现错误
原标题:How to catch error while inserting data with SqlDataSource

我有SqlDataSource和GridView。

我想做的是,虽然问询已经执行(即插入数据),但在数据成功插入之后,应当看上去信息的声音:“成功删除数据”。 我通过使用GridView1_RowDeleted方法解决了这一问题。

现在的问题是,在问询未能执行时,我想赶上错误。 如果问询没有执行,那么就应当看上去“数据没有插入”。

如何这样做? 我对此没有想法。

你们需要帮助。

感谢很多。

最佳回答

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

纽约总部

问题回答

暂无回答




相关问题
Is Shared ReadOnly lazyloaded?

I was wondering when I write Shared ReadOnly Variable As DataType = New DataType() Or alternatively Shared ReadOnly Variable As New DataType() Is it lazy loaded or as the instance initializes? ...

Entertaining a baby with VB.NET

I would like to write a little application in VB.NET that will detect a baby s cry. How would I get started with such an application?

Choose Enter Rather than Pressing Ok button

I have many fields in the page and the last field is a dropdown with list of values. When I select an item in a dropdown and press Enter, it doesn t do the "Ok". Instead I have to manually click on Ok ...

ALT Key Shortcuts Hidden

I am using VS2008 and creating forms. By default, the underscore of the character in a textbox when using an ampersand is not shown when I run the application. ex. "&Goto Here" is not ...

Set Select command in code

On button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn t work. What am i doing wrong? protected void bttnView_Click(object sender, ...

Hover tooltip on specific words in rich text box?

I m trying to create something like a tooltip suddenly hoovering over the mouse pointer when specific words in the richt text box is hovered over. How can this be done?

热门标签