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: 6590
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

user93

0 9

Reply
User: user93
Replied: on Sep 12, 2017 06:24 AM
Report

then what should i change in this code my main problem is here only near 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;

problem is at above code and below is original code

private bool CheckFileExist(string SubjName, string FileName, string Stype, string PhysiName, string DocName, string TempFilName, string DraftFileName, bool HasFile, string Type, string DraftName)
{
var flag1 = false;
string qry = string.Empty;
if (Type == "Add")
{
if (Stype == "Draft")
{
qry = "select ID,SubjectID,auditoName from SubjectItems where (SubjectID='" + SubjName + "' and auditoName='" + FileName + "' and AuditoType='" + Stype + "' and Physician='" + PhysiName + "') or (BaseDocumentName='" + DocName + "') or( DraftDocumentName='" + DraftName + "') ";

}
else
{
qry = "select ID,SubjectID,auditoName from SubjectItems where (SubjectID='" + SubjName + "' and auditoName='" + FileName + "' and AuditoType='" + Stype + "' and Physician='" + PhysiName + "') or BaseDocumentName='" + DocName + "' ";
}
}
else
{
if (Stype == "Draft")
{
qry = "select ID,SubjectID,auditoName from SubjectItems where (BaseDocumentName = '" + DocName + "' and ID <> " + Session["ID"] + ") or (DraftDocumentName = '" + DraftName + "' and ID <> " + Session["ID"] + ") or (SubjectID='" + SubjName + "' and auditoName='" + FileName + "' and AuditoType='" + Stype + "' and Physician='" + PhysiName + "' and ID <> " + Session["ID"] + ")";
}
else
{
qry = "select ID,SubjectID,auditoName from SubjectItems where (BaseDocumentName = '" + DocName + "' and ID <> " + Session["ID"] + ") or (SubjectID='" + SubjName + "' and auditoName='" + FileName + "' and AuditoType='" + Stype + "' and Physician='" + PhysiName + "' and ID <> " + Session["ID"] + ")";
}
}
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;
}

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