---

Private con As New SqlConnection("server=.\SqlExpress;AttachDbFileName=|DataDirectory|Gallery.mdf;Integrated Security=True;User Instance=True")
Private fileNamePath As String

---

---

Protected Sub FormView1_ItemInserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertEventArgs) Handles FormView1.ItemInserting
        Try
           
            Dim theFileUpload As FileUpload = CType( _
                            FormView1.FindControl("FileUpload1"), FileUpload)
            If theFileUpload.HasFile Then
                fileNamePath = "~/Music/" & Guid.NewGuid.ToString()
                Dim theExtension As String = Path.GetExtension(theFileUpload.FileName)
                fileNamePath &= theExtension
                theFileUpload.SaveAs(Server.MapPath(fileNamePath))
               
                e.Values("SongPath") = fileNamePath
                e.Values("SongExtn") = theExtension
               
            End If
        Catch ex As Exception
            Throw
        End Try
    End Sub

---

---

Protected Sub FormView1_ItemDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewDeleteEventArgs) Handles FormView1.ItemDeleting
        con.Open()
        Dim musicId As Integer = Convert.ToInt32(Request.QueryString.Get("Id"))
        Dim filePath As String = "select SongPath from Music where Id = " & musicId
        Dim cmd As New SqlCommand(filePath, con)
        cmd.ExecuteNonQuery()
        File.Delete(filePath)
        con.Close()
    End Sub

---

---

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xs="http://www.w3.org/2001/XMLSchema" exclude-result-prefixes="xs" version="2.0">
   
    <xsl:param name="input-uri" as="xs:string"/>
    <xsl:output indent="yes"/>
   
    <xsl:template name="main">
        <xsl:variable name="in" select="unparsed-text($input-uri, 'iso-8859-1')"/>

        <Log>
        <xsl:analyze-string select="$in"
            regex="^([^,]+,)([^,]+,)(&quot;(([0-9]{4})|([A-Z][0-9])|())&quot;,)(&quot;(([a-zA-Z]{3}[0-9])|(SERVER)|(EVS_SRV))&quot;,)(&quot;[0-9_a-zA-Z]+&quot;,)(&quot;[^&quot;]+&quot;)" flags="m">
            <xsl:matching-substring>
                <LogEntry>
                    <time>
                        <xsl:value-of select="regex-group(1)"/>
                    </time>
                    <DuplicateTime>
                        <xsl:value-of select="regex-group(2)"/>
                    </DuplicateTime>
                    <Employee>
                        <xsl:value-of select="regex-group(4)"/>
                    </Employee>
                    <Device>
                        <xsl:value-of select="regex-group(5)"/>
                    </Device>
                    <Action>
                        <xsl:value-of select="regex-group(7)"/>
                    </Action>
                    <Description>
                        <xsl:value-of select="regex-group(9)"/>
                    </Description>
                </LogEntry>
            </xsl:matching-substring>
        </xsl:analyze-string>
        </Log>
    </xsl:template>

</xsl:stylesheet>

---