Event Handler Code

        //writing the note in the notepad
        public void writeToNotepad(string strTxt)
        {
            StreamWriter strWriter = File.AppendText(@"c:\Hello.txt");
            strWriter.Write(strTxt + "\n");
            strWriter.Close();
        }
        //Db information
        public void saveData(string strUserName, string dtTime, string strDesc)
        {
            //dtTime = DateTime.Now.ToString() ;
            SqlConnection con = new SqlConnection("server=madan;uid=sa;pwd=madan@123;database=mydb");
            string sqlStr = "insert into allevents values('" + strUserName + "','" + dtTime + "','" + strDesc + "')";
            SqlCommand cmd = new SqlCommand(sqlStr, con);
            try
            {
                con.Open();
                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
            }
            finally
            {
                con.Close();
            }
        }
       /// <summary>
       /// An item is being added.
       /// </summary>
       public override void ItemAdding(SPItemEventProperties properties)
       {
           writeToNotepad("Item Adding :" + properties.ListItem.Title + " Adding time " + DateTime.Now.ToString());
           saveData("Madan", DateTime.Now.ToString(), "Item adding");
           //saveData("Madan", DateTime.Now.ToString(), "Iteam Adding");
       }
       /// <summary>
       /// An item is being updated.
       /// </summary>
       public override void ItemUpdating(SPItemEventProperties properties)
       {
           writeToNotepad("Item Updating :" + properties.ListItem.Title + " Updating time " + DateTime.Now.ToString());
           saveData("Madan", DateTime.Now.ToString(), "Item Updating");
       }
       /// <summary>
       /// An item is being deleted.
       /// </summary>
       public override void ItemDeleting(SPItemEventProperties properties)
       {
           properties.Cancel = true;
           properties.ErrorMessage = "Evening batch you dont have the delete permissions..";
       }
       /// <summary>
       /// An item is being checked in.
       /// </summary>
       public override void ItemCheckingIn(SPItemEventProperties properties)
       {
           base.ItemCheckingIn(properties);
       }
       /// <summary>
       /// An item is being checked out.
       /// </summary>
       public override void ItemCheckingOut(SPItemEventProperties properties)
       {
           base.ItemCheckingOut(properties);
       }
       /// <summary>
       /// A file is being moved.
       /// </summary>
       public override void ItemFileMoving(SPItemEventProperties properties)
       {
           base.ItemFileMoving(properties);
       }
       public override void ItemDeleted(SPItemEventProperties properties)
       {
           base.ItemDeleted(properties);
       }