Maintain Error Log

Question

Hi     How we can maintain error log in Sql Database.   Thanks

Sachin Singh · Accepted Answer

step1. SET  ANSI_NULLS  ON        GO              SET  QUOTED_IDENTIFIER  ON        GO              SET  ANSI_PADDING  ON        GO              CREATE   TABLE  [dbo].[Tbl_ExceptionLoggingToDataBase](           [Logid] [ bigint ] IDENTITY(1,1)  NOT   NULL ,           [ExceptionMsg] [ varchar ](100)  NULL ,           [ExceptionType] [ varchar ](100)  NULL ,           [ExceptionSource] [nvarchar]( max )  NULL ,           [ExceptionURL] [ varchar ](100)  NULL ,           [Logdate] [datetime]  NULL ,         CONSTRAINT  [PK_Tbl_ExceptionLoggingToDataBase]  PRIMARY   KEY  CLUSTERED        (           [Logid]  ASC        ) WITH  (PAD_INDEX =  OFF , STATISTICS_NORECOMPUTE =  OFF , IGNORE_DUP_KEY =  OFF , ALLOW_ROW_LOCKS =  ON , ALLOW_PAGE_LOCKS =  ON )  ON  [ PRIMARY ]       )  ON  [ PRIMARY ] TEXTIMAGE_ON [ PRIMARY ]              GO              SET  ANSI_PADDING  OFF        GO   step2 Create   Procedure  ExceptionLoggingToDataBase       (       @ExceptionMsg  varchar (100)= null ,       @ExceptionType  varchar (100)= null ,       @ExceptionSource nvarchar( max )= null ,       @ExceptionURL  varchar (100)= null        )       as        begin        Insert   into  Tbl_ExceptionLoggingToDataBase       (       ExceptionMsg ,       ExceptionType,        ExceptionSource,       ExceptionURL,       Logdate       )       select        @ExceptionMsg,       @ExceptionType,       @ExceptionSource,       @ExceptionURL,       getdate()       End   step 3. create a folder named Exceptionhandler and under that ceate below static class public   static   class  ExceptionLogging     {               private   static  String exepurl;          static  SqlConnection con;          private   static   void  connecttion()         {             string constr = ConfigurationManager.ConnectionStrings[ "CharpCorner" ].ToString();             con =  new  SqlConnection(constr);             con.Open();         }          public   static   void  SendExcepToDB(Exception exdb)         {           connecttion();             exepurl = context.Current.Request.Url.ToString();             SqlCommand com =  new  SqlCommand( "ExceptionLoggingToDataBase" , con);             com.CommandType = CommandType.StoredProcedure;             com.Parameters.AddWithValue( "@ExceptionMsg" , exdb.Message.ToString());             com.Parameters.AddWithValue( "@ExceptionType" , exdb.GetType().Name.ToString());             com.Parameters.AddWithValue( "@ExceptionURL" , exepurl);             com.Parameters.AddWithValue( "@ExceptionSource" , exdb.StackTrace.ToString());             com.ExecuteNonQuery();       }   }    step 4. use the static class method to log the error public  ActionResult MethodName   {   try              {              // do your work          }              catch  (Exception ex)             {         ExceptionLogging.SendExcepToDB(ex);                    }    return  view();      }

Sachin Singh · Answer

change this  exepurl = context.Current.Request.Url.ToString();      to this exepurl = HttpContext.Current.Request.Url.ToString();      Now, it should work

Ramco Ramco · Answer

Hi Sachin     On this line i get error - exepurl = context.Current.Request.Url.ToString();   The name Context does not exist in the current context   Thanks