How to open a file in C#

Question

1.00/5 (1 vote)

See more:

Hi All,

I like to open a file. The open option should be shown in a separate window. My code works fine but the open window is not displaying to open a file. Can anyone help me to solve this problem. Here is the code:

private void OpenMyFile()
    {
        string path = GetPath() + ViewState["fileopen"];
        FileInfo file = new FileInfo(ViewState["fileopen"].ToString());
        SqlConnection con = new SqlConnection(@"server=servername;database=DBNAME;uid=ID;pwd=PWD;max pool size=250;Connect Timeout=0");
        con.Open();
        cmd = new SqlCommand("select * from filetypemaster where extension='" + file.Extension + "'", con);
        myReader = cmd.ExecuteReader();
        
        
        if (myReader.Read())
        {
            Response.ContentType =(String)myReader["CONTENT_TYPE"];
            myReader.Close();
        }
        else
        {
            myReader.Close();
            Message("Cannot open selected file");
            return;
        }
       
        Response.WriteFile(path);
        Response.End();
        
        con.Close();
    }

;

Thanks in Advance.

Posted 12-Jul-11 23:45pm

Member 7946563

Updated 13-Jul-11 0:31am

Ramalinga Koushik

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 13-Jul-11 14:14pm

ASP.NET? Tag it!
--Sa

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Answer 1 · 2011-07-12T23:48:00

Solution 1

You are missing header.

Response.ContentType = "image/jpeg";
Response.AppendHeader("Content-Disposition","attachment; filename=SailBig.jpg");
Response.TransmitFile( Server.MapPath("~/images/sailbig.jpg") );
Response.End();

Ref:http://www.west-wind.com/weblog/posts/2007/May/21/Downloading-a-File-with-a-Save-As-Dialog-in-ASPNET[^]

Posted 12-Jul-11 23:48pm

Prerak Patel

Comments

Member 7946563 13-Jul-11 5:51am

I like to open a file with all extensions

Prerak Patel 13-Jul-11 5:53am

You are already assigning content type from database.
You can replace the extension with your file.extension
Response.AppendHeader("Content-Disposition","attachment; filename=Temp." + file.Extension);

Member 7946563 14-Jul-11 2:23am

Hi,

Its still not working.
Thanks

Member 8015046 · Answer 2 · 2011-07-13T06:09:00

Maybe you should try something like, looking into the directory, get all the files. Then filter out that list of fileInfos to match your extension. Then you have a List<fileinfo> of all the files with your extension type. Then you can do your open thing.

or

you might want to look into the OpenFileDialog toolbox item in windows Forms