how to use AsyncFileUpload to read a file content in asp.net using c#?

Question

i have a AsyncFileUpload control :

<asp:AsyncFileUpload ID="venfileupld" runat="server" OnUploadedComplete="ProcessUpload" />

on its OnUploadedComplete event i am writing this code :

protected void ProcessUpload(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
    string name = venfileupld.FileName.ToString();
    string filepath = "upload_excel/" + name;
    venfileupld.SaveAs(Server.MapPath(name));

}

now i have to read the content of the uploaded file ... i have a function for that:

public void writetodb(string filename)
{
    string[] str;
    string vcode = "";
    string pswd = "";
    string vname = "";
    StreamReader sr = new StreamReader(filename);
    string line="";

    while ((line = sr.ReadLine()) != null)
    {
        str = line.Split(new char[] { ',' });
        vcode = str[0];
        pswd = str[1];
        vname = str[2];
        insertdataintosql(vcode, pswd, vname);
    }
    lblmsg4.Text = "Data Inserted Sucessfully";
}

now my query is that how i can get the uploaded file to pass to this function ?

UPDATE

i have done this :

protected void ProcessUpload(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
    string name = venfileupld.FileName.ToString();
    string filepath = "upload_excel/" + name;
    venfileupld.SaveAs(Server.MapPath(name));
    string filename = System.IO.Path.GetFileName(e.FileName);
    writetodb(filepath);

}

but getting an error... file not found

What's the problem, why can't you simply call that method from ProcessUpload? — Tim Schmelter
– Tim Schmelter, Commented Nov 19, 2012 at 13:13
You access the file that is now on the server itself. You know where the document is because of filepath in your very own code. — Security Hound
– Security Hound, Commented Nov 19, 2012 at 13:16
Yes, because you're saving it as Server.MapPath(name) but you are passing System.IO.Path.GetFileName(e.FileName) to the method. Have you tried my code below? — Tim Schmelter
– Tim Schmelter, Commented Nov 19, 2012 at 13:23

Tim Schmelter · Accepted Answer · 2012-11-19 13:25:55Z

1

I'm not sure if i have understood the problem, but isn't it easy as:

protected void ProcessUpload(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
    string name = System.IO.Path.GetFileName(e.filename);
    string dir = Server.MapPath("upload_excel/");
    string path = Path.Combine(dir, name);
    venfileupld.SaveAs(path);
    writetodb(path);
}

SaveAs will save the file on the server, so you can do what you want with it afterwards.

edited Nov 19, 2012 at 13:25

answered Nov 19, 2012 at 13:14

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Arindam Das Over a year ago

i am getting an error The SaveAs method is configured to require a rooted path, and the path 'upload_excel/VENDOR.csv' is not rooted. on line venfileupld.SaveAs(path);

Tim Schmelter Over a year ago

@ArindamDas: Edited my answer. The directory is Server.MapPath("upload_excel/") and the name is System.IO.Path.GetFileName(e.filename).

Arindam Das Over a year ago

hello sir that solution u gave worked fine in my localhost but when i am doing this in a hosting server i am getting error.. the file is getting uploaded in the server but i think i am not getting the file for the function writetodb() can u 1sec help me on this ?\

Collectives™ on Stack Overflow

how to use AsyncFileUpload to read a file content in asp.net using c#?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related