Check uploaded file already exits or not using C# in ASP.Net

user93

SOLVED CLOSED ACTIVE ANSWERED
User: user93
Posted: on Sep 11, 2017 05:26 AM
Forum: ASP.Net Web Forms
Answer: 3
Views: 6592
Sample Code: Download

Below is my code which is used to check file already exists or not

var flag1 = CheckFileExist(Session["subjectname"].ToString());
                    if (!flag1)
                        return;
  private bool CheckFileExist(string SubjName)
    {
        var flag1 = false;
        string qry = string.Empty;
        if (Type == "Add")
        {
            if (Stype == "3")
            {
                qry ="select ID,Subjectnames,stuName from students where subjectnames='" + SubjName + "'";

            }
            else
            {
                qry = "select ID,Subjectnames,stuName from students where subjectnames='" + SubjName + "'";
            }
        }
        else
        {
            if (Stype == "3")
            {
                qry = "select ID,Subjectnames,stuName from students where subjectnames='" + SubjName + "'";
            }
            else
            {
                qry = "select ID,Subjectnames,stuName from students where subjectnames='" + SubjName + "'";
            }
        }
        SqlCommand cmd = new SqlCommand(qry, con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        if (ds.Tables[0].Rows.Count > 0)
        {
            if (HasFile == false)
            {
                lblerrmsg.Visible = true;
                lblerrmsg.Text = "File Already Exist ...!";
                return false;
            }
            else
            {
                lblerrmsg.Visible = true;
                lblfname.Text = "";
                lbldocname.Text = "";
                pnl1.Visible = true;
                btnupdate.Enabled = false;
                lblerrmsg.Visible = true;
                btnadd.Enabled = true;
                string Subjects = "select ID, Subject from Subjects where Module = '" + null + "'";
                BindDropDownList(ddlsubjname, Subjects, "Subject", "ID", "--Select--");
                lblerrmsg.Text = "File Already Exist ...!";
                if (IsPostBack)
                {
                    BindGrid();
                }
                Clear();
                return false;
            }
        }
        flag1 = true;
        return flag1;
    }

the problem is i will be uploading mutiple sheets for a subject it should check whether that sheet is alread there for that subject or not this code is working fine when i take single documnet in file uploader if i am taking mutiple file it is not checking for all the multiple files instead it is getting returned after checking the first file only.how can i resolve this

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 8

Reply
User: dharmendr
Replied: on Sep 12, 2017 05:10 AM
Modified: on Sep 12, 2017 05:12 AM
Report

dharmendr says:
for (int i = 0; i < Request.Files.Count; i++)

    {

        HttpPostedFile postedFile = Request.Files[i];

        if (postedFile.ContentLength > 0)

        {

            string fileNameWithoutExtension = Path.GetFileNameWithoutExtension(postedFile.FileName);

            string fileExtension = Path.GetExtension(postedFile.FileName);

            if (fileExtension.ToLower() == ".mp3")

            {

                bool flag1 = CheckFileExist(Session["sid"].ToString(), fileNameWithoutExtension + ".mp3", Session["type"].ToString(), Session["phname"].ToString(), Docname, TFiName, DrfName, true, Type, DrftFName);

                if (!flag1)

                {

                    return;

                }

            }

        }

    }

You need to handle this code like below.

for (int i = 0; i < Request.Files.Count; i++)
{
    HttpPostedFile postedFile = Request.Files[i];
    if (postedFile.ContentLength > 0)
    {
        string fileNameWithoutExtension = Path.GetFileNameWithoutExtension(postedFile.FileName);
        string fileExtension = Path.GetExtension(postedFile.FileName);
        if (fileExtension.ToLower() == ".mp3")
        {
            bool flag1 = CheckFileExist(Session["sid"].ToString(), fileNameWithoutExtension + ".mp3", Session["type"].ToString(), Session["phname"].ToString(), Docname, TFiName, DrfName, true, Type, DrftFName);
            // File[i] not exist then insert into database with details. 
            if (flag1 == false)
            {
                // Insert code goes here.
            }
            else
            {
                lblerrmsg.Visible = true;
                lblerrmsg.Text = "File Already Exist ...!";
            }
        }
    }
}

I would suggest you inside CheckFileExist don't do any other task. Just need do the task of checking file exist or not.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Check uploaded file already exits or not using C# in ASP.Net

Company

Explore

Follow us

Contact Us