how to catch error message everywhere?

Question

Hi,

i would like to go back to an unsoved problem till now.

The sql statement is in the aspx file (Website application), not in coode-behind. When an error occurs, i get an ugly message like "cannot insert etc ...."). I can avoid it with this code.

using System;
using System.Web.UI.WebControls;

public partial class leden_upd : System.Web.UI.Page
{

protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
if (e.Exception == null)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('Ok.');", true);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('Not ok.');", true);
e.ExceptionHandled = true;
}
}
}

This works. Now i would like to put the code in a static class in order to use this code everywhere in the application.

This a code that i received from someone in C-Corner, but doesn't work (no error but still shows the ugly message)

using System;
using System.Web;
using System.Web.UI;

public partial class ScriptHandler
{
private Page _page;
public ScriptHandler(Page myPage)
{
_page = myPage;
}

public Exception e
{ get; set; }

public void ShowDialog(bool isError)
{
if (!isError)
{
ScriptManager.RegisterClientScriptBlock(_page, this.GetType(), "", "alert('ok');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(_page, this.GetType(), "", "alert('not ok');", true);
}
}
}
------
protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
bool isError = e.Exception == null ? true : false;
ScriptHandler obj = new ScriptHandler(this.Page);
obj.ShowDialog(isError);
}

No error, but this shows again the ugly message "Cannot insert the value Null into column etc ...
Thanks

Sachin Singh · Answer

Condition is incorrect rest is ok, Test this bool isError = e.Exception == null ? false : true; ScriptHandler obj = new ScriptHandler(this.Page); obj.ShowDialog(isError); }

Valerie Meunier · Answer

Finally, i found the problem. This line was missing: e.ExceptionHandled = true; Now it works. Thanks

Valerie Meunier · Answer

Hi Jignesh Kumar what you are proposing is the same as i did (see below). And it still show the message 'cannot insert etc ...'. bool isError = e.Exception == null ? false : true; ScriptHandler obj = new ScriptHandler(this.Page); obj.ShowDialog(isError); How come it never works? Is there something wrong in the Class file of the map App_Code? Thanks for helping. V

Jignesh Kumar · Answer

When you are passing bool flage to shoeDialog(isError) methos you are passing worng values, It should be likw below, protected void GridView1_RowUpdated( object sender, GridViewUpdatedEventArgs e) { bool isError = e.Exception == null ? false : true ; ScriptHandler obj = new ScriptHandler( this .Page); obj.ShowDialog(isError);

Valerie Meunier · Answer

Hi i did this: protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e) { bool isError = e.Exception == null ? false : true; ScriptHandler obj = new ScriptHandler(this.Page); obj.ShowDialog(isError); } The message "cannot insert ... "still appears. No other error. ??