Download File From Server

Hello All,

In my code i have CSV File saved in the server. Once the CSV is saved in server through code i want my users to prompt for download with save/open / cancel dialog box . Can anyone please guide me? Its very urgent i tried the following code

        Response.ContentType = "text/csv"
        Response.AppendHeader("Content-Disposition", "attachment; filename=Test.csv")
        Response.TransmitFile(Server.MapPath("~\CSV\Test.csv"))
        Response.End()

But Stil It is not prompting the dialog box to the user whether to save\open. When i click the button the file is saved in the server and its getting downloaded automatically.How to solve this