ASP.NET

Protected Sub Btn_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim btn As LinkButton = DirectCast(sender, LinkButton)
    Dim savecontinue As String = btn.CommandArgument    
    Dim correctExtension As Boolean = False
    'Dim blSucces As Boolean = False
    Dim FilePath As String = ConfigurationManager.AppSettings("FilePath").ToString()

    If FileUploadToServer.HasFile Then    
        Dim fileName As String = FileUploadToServer.PostedFile.FileName    
        Dim fileSize As Integer = FileUploadToServer.PostedFile.ContentLength    
        Dim fileExtension As String = Path.GetExtension(fileName).ToLower()    
        Dim extensionsAllowed As String() = {".pdf"}    
        If extensionsAllowed.Contains(fileExtension) Then    
            correctExtension = True    
        End If    
        If correctExtension Then    
            If fileExtension = ".pdf" Then    
                Try   
                    FileUploadToServer.PostedFile.SaveAs(filePath)    
                    SaveFileInfo(fileName, fileSize, FilePath)    
                    lblResult.Text = "File successfully uploaded and file path saved in database"
                    lblResult.ForeColor = Drawing.Color.Red    
                Catch ex As Exception    
                    lblResult.Text = "Unable to upload file"
                    lblResult.ForeColor = Drawing.Color.Red    
                End Try    
            End If
            ''Check if file already exists. If so, delete it and replace with new one
            If File.Exists(Server.MapPath(FilePath) & fileName) Then
                File.Delete(Server.MapPath(FilePath) & fileName)
            End If

            ' Get size of uploaded file, here restricting size of file
            fileSize = FileUploadToServer.PostedFile.ContentLength
            If FileSize <= 26214400 Then
                '1048576 byte = 1MB
                'Get file name of selected file
                fileName = Path.GetFileName(FileUploadToServer.FileName)
                'Save selected file into specified location
                FileUploadToServer.SaveAs(Server.MapPath(FilePath) & fileName)

                lblResult.Text = "File uploaded successfully!"
                lblResult.ForeColor = Drawing.Color.Red
                'blSucces = True
            Else
                lblResult.Text = "Attachment file size should not be greater then 250 MB"
                lblResult.ForeColor = Drawing.Color.Red
            End If
        Else    
            lblResult.Text = "File extension " + fileExtension + " is not allowed"
            lblResult.ForeColor = Drawing.Color.Red    
        End If
    End If

End Sub
Private Sub SaveFileInfo(ByVal strfilename As String, ByVal size As Integer, ByVal strPath As String)
    Using Sqlcon As New SqlConnection(connStr)
        Using cmd As New SqlCommand()
            Sqlcon.Open()
            cmd.Connection = Sqlcon
            cmd.CommandType = CommandType.StoredProcedure
            cmd.CommandText = "InsertOrUpdate"
            cmd.Parameters.Add(New SqlParameter("@EmpID", Session("EmpNum")))
            cmd.Parameters.Add(New SqlParameter("@ckRequestReview", ""))
            cmd.Parameters.Add(New SqlParameter("@RequestedTitle", txtTitleChange.Text))
            cmd.Parameters.Add(New SqlParameter("@TitleChangeComments", txtTitleComments.Text))
            cmd.Parameters.Add(New SqlParameter("@RequestedPay", txtPayGradeChange.Text))
            cmd.Parameters.Add(New SqlParameter("@PayChangeComments", txtPayComments.Text))
            cmd.Parameters.Add(New SqlParameter("@RequestedClass", txtClassSpecChange.Text))
            cmd.Parameters.Add(New SqlParameter("@ClassChangeComments", txtClassComments.Text))
            cmd.Parameters.Add(New SqlParameter("@EmpSignature", txtsign.Text))
            cmd.Parameters.Add(New SqlParameter("@finishedOrUnfinished", "Finished"))
            cmd.Parameters.Add(New SqlParameter("@ManagerID", divManager.SelectedValue))
            cmd.Parameters.Add(New SqlParameter("@DeptID", Session("DeptID")))
            cmd.Parameters.Add(New SqlParameter("@DirectorID", Session("DirectorNum")))
            cmd.Parameters.Add(New SqlParameter("@apFileName", SqlDbType.VarChar, 100))
            cmd.Parameters.Add(New SqlParameter("@apFilepath", SqlDbType.VarChar, 100))
            cmd.Parameters.Add(New SqlParameter("@FileSize", SqlDbType.Int))
            cmd.Parameters("@apFileName").Value = strfilename
            cmd.Parameters("@apFilepath").Value = strPath
            cmd.Parameters("@FileSize").Value = size
            cmd.ExecuteNonQuery()
            Dim rows As Integer = cmd.ExecuteNonQuery()
            If rows = 1 Then
                lblResult.Text = "Record Successfully Saved. Please log out and close your browser"
                lblResult.ForeColor = System.Drawing.Color.Red
            End If
        End Using
    End Using
End Sub

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CS.aspx.cs" Inherits="CS" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        body
        {
            font-family: Arial;
            font-size: 10pt;
        }
        table
        {
            border: 1px solid #ccc;
            border-collapse: collapse;
            background-color: #fff;
            width:200px;
        }
        table th
        {
            background-color: #B8DBFD;
            color: #333;
            font-weight: bold;
        }
        table th, table td
        {
            padding: 5px;
            border: 1px solid #ccc;
        }
        table, table table td
        {
            border: 0px solid #ccc;
        }
    </style>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script type="text/javascript">
        $(function () {
            $.ajax({
                type: "POST",
                url: "CS.aspx/GetCustomers",
                data: '{}',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: OnSuccess,
                failure: function (response) {
                    alert(response.d);
                },
                error: function (response) {
                    alert(response.d);
                }
            });
        });

        function OnSuccess(response) {
            var xmlDoc = $.parseXML(response.d);
            var xml = $(xmlDoc);
            var customers = xml.find("Table");
            var table = $("#dvCustomers table").eq(0).clone(true);
            $("#dvCustomers table").eq(0).remove();
            customers.each(function () {
                var customer = $(this);
                $(".name", table).html(customer.find("compid").text());
                $(".city", table).html(customer.find("Compdate").text());
                $(".postal", table).html(customer.find("name").text());
                $(".country", table).html(customer.find("phone").text());
                $(".phone", table).html(customer.find("subdepartnm").text());
                $(".fax", table).html(customer.find("block").text());
                $("#dvCustomers").append(table).append("<br />");
                table = $("#dvCustomers table").eq(0).clone(true);
            });
        }
    </script>

</head>
<body style="font-family: Arial; font-size: 10pt">
    <form id="form1" runat="server">
    <div id="dvCustomers">
        <asp:Repeater ID="rptCustomers" runat="server">
            <ItemTemplate>
                <table class="tblCustomer" cellpadding="2" cellspacing="0" border="1">
                   <tr>
                        <th>
                            <b><u><span class="name">
                                <%# Eval("compid")%></span></u></b>
                        </th>
                    </tr>
                    <tr>
                        <td>
                            <b>Complain Date: </b><span class="city"><%# Eval("Compdate")%></span><br />
                            <b>Name: </b><span class="postal"><%# Eval("name")%></span><br />
                            <b>Phone: </b><span class="country"><%# Eval("phone")%></span><br />
                            <b>Department: </b><span class="phone"><%# Eval("subdepartnm")%></span><br />
                            <b>Block: </b><span class="fax"><%# Eval("block")%></span><br />
                        </td>
                    </tr>
                </table>
            </ItemTemplate>
        </asp:Repeater>
    </div>
    </form>
</body>
</html