Hi nauna,

global.asax

protected void Application_Error(object sender, EventArgs e)
{
   Exception ex = Server.GetLastError().GetBaseException();
   if (!(ex is HttpException))
   {
       string url = (HttpContext.Current.Request.IsNull() || HttpContext.Current.Request.Url.IsNull()) ? "" : HttpContext.Current.Request.Url.AbsoluteUri;
       /* Call email sending Method from any static class so you can directly use it here . 
          eg. sendMail.send(); where sendMail is static class having static send email send method.*/
    }
}

Also refer the below links.

[Solved] Log and Insert Error and Exception message details in database using Global.asax file in ASP.Net

Error logging and Exception handling in ASP.Net using C# and VB.Net

should i send string url in send mail body so i can get the exact error? Please advice

Hi nauna,

You need to pass ex.Message to email body and url gives you the url where the exception occured. So as per your requirement in mail body you need to pass.

Refer the below sample.

HTML

Default.aspx

 <asp:Button ID="Button1" Text="Click to Raise Exception" runat="server" OnClick="RaiseException" />

Default2.aspx

 <asp:Button ID="Button1" Text="Click to Raise Exception" runat="server" OnClick="RaiseException2" />

Code

Default.aspx

protected void RaiseException(object sender, EventArgs e)
{
   /* If you are using try catch then use throw statement is compulsory 
    Else if you are not using try catch then it will automatically handel 
    in Application_Error method in global.asax file.*/
    try
    {
        int i = int.Parse("Default 1");
    }
    catch (Exception)
    {
        throw;            
    }
}

Default2.aspx

protected void RaiseException2(object sender, EventArgs e)
{
    /* If you are using try catch then use throw statement is compulsory 
    Else if you are not using try catch then it will automatically handel 
    in Application_Error method in global.asax file.*/
    try
    {
        int i = int.Parse("Default 2");
    }
    catch (Exception)
    {      
        throw;
    }
}

Global.asax

void Application_Error(object sender, EventArgs e)
{
    // Code that runs when an unhandled error occurs
    Exception ex = Server.GetLastError().GetBaseException();
    if (!(ex is HttpException))
    {
        string url = (HttpContext.Current.Request == null || HttpContext.Current.Request.Url == null) ? "" : HttpContext.Current.Request.Url.AbsoluteUri;
        string exceptionMessage = ex.Message;
        string StackTrace = ex.StackTrace.Replace(Environment.NewLine, string.Empty);
        string source = ex.Source.Replace(Environment.NewLine, string.Empty);
        string targetSite = ex.TargetSite.ToString().Replace(Environment.NewLine, string.Empty);
        /* Call email sending Method from any static class so you can directly use it here .
            eg. sendMail.send(); where sendMail is static class having static send email send method.*/
    }
}

hello i am using following code of mudassir to save the error in database

i am using this in global asax page, this works fine, the only problem is that it shows in db "object reference not set to an instance of an object" that is fine, but can i trace on which page that error occured what should i modify in the below code to take page url of the error.

please advice

string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
string sqlStatment = "INSERT INTO ErrorLog VALUES(@Date,@Message)";
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(constr))
{
   using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sqlStatment, con))
   {
       con.Open();
       cmd.Parameters.AddWithValue("@Date", DateTime.Now);
       cmd.Parameters.AddWithValue("@Message", ((System.Exception)(Server.GetLastError().InnerException)).Message.Trim());
       cmd.ExecuteNonQuery();
       con.Close();
    }
}

dharmendr says:

string url = (HttpContext.Current.Request == null || HttpContext.Current.Request.Url == null) ? "" : HttpContext.Current.Request.Url.AbsoluteUri;

 The above statement gives you the url.