Maintain Error Log

Question

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

Sachin Singh · 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