Sunday, 12 January 2014

Export Radgrid to Excel in .Net

protected void btn_Export_Click(object sender, EventArgs e)
{
try
{
if (grd_AdmnReg.Items.Count > 0)
{
grd_AdmnReg.MasterTableView.AllowPaging = false;
grd_AdmnReg.PageSize = grd_AdmnReg.Items.Count + 1;
grd_AdmnReg.ExportSettings.FileName = "ServerApps Online";
grd_AdmnReg.GridLines = GridLines.Both;
grd_AdmnReg.ExportSettings.ExportOnlyData = true;
grd_AdmnReg.ExportSettings.OpenInNewWindow = false;
grd_AdmnReg.MasterTableView.ExportToExcel();
}
else
{
Alert.WithoutUpdatePanelMessage("Sorry,there is no records.");
}

}
catch (Exception ex)
{

}
}

Tuesday, 7 January 2014

Upload Multiple File at a Time in Asp.Net

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Multiple FileUpload Example</title>
    <script type = "text/javascript">
        var counter = 0;
        function AddFileUpload() {
            var div = document.createElement('DIV');
            div.innerHTML = '<input id="file' + counter + '" name = "file' + counter + '" type="file" /><input id="Button' + counter + '" type="button" value="Remove" onclick = "RemoveFileUpload(this)" />';
            document.getElementById("FileUploadContainer").appendChild(div);
            counter++;
        }
        function RemoveFileUpload(div) {
            document.getElementById("FileUploadContainer").removeChild(div.parentNode);
        }
    </script>
</head>
<body>
    <form id="form1" runat="server" enctype="multipart/form-data" method = "post">
        <span style ="font-family:Arial">Click to add files</span>&nbsp;&nbsp;
        <input id="Button1" type="button" value="add" onclick = "AddFileUpload()" />
        <br /><br />
        <div id = "FileUploadContainer">
         
        </div>
        <br />
        <asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" />
    </form>
</body>
</html>



 protected void btnUpload_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < Request.Files.Count; i++)
            {
                HttpPostedFile PostedFile = Request.Files[i];
                if (PostedFile.ContentLength > 0)
                {
                    string FileName = System.IO.Path.GetFileName(PostedFile.FileName);
                    PostedFile.SaveAs(Server.MapPath("Worksheet\\") + FileName);
                }
            }
        }