How to Upload Multiple File in Multiple Column In Database

Question

Hello

I Want To Know How to Save  Multiple File in Multiple Column In Database  I give You My Code Below so Please Write Code for Me--

 

This is my Class where I Make Function---

 

public DataSet InsertRecord(DCI_BAL objprop)

{

CommanFunction cmf = new CommanFunction();

MyConnectionString objcon = new MyConnectionString();

string myconnection = objcon.Constring;

int Querytype = 0; // for Query type i.e. parameter or SP

string SPName = "Proc_Anti_Ragging1";

string Qtype = objprop.Qtype;

string[,] MySPValues = new string[,]

{

{"@Qtype",Qtype},

{"@Year", objprop.Year},

{"@Prospectus_mention_File1",objprop.Prospectus_mention_File1},

{"@Prospectus_mention_File2",objprop.Prospectus_mention_File2},

{"@Prospectus_mention_File3",objprop.Prospectus_mention_File3},

{"@Prospectus_mention_File4",objprop.Prospectus_mention_File4},

{"@Prospectus_mention_File5",objprop.Prospectus_mention_File5}

};

DataSet ds = new DataSet();

ds = cmf.Execute_DSSPQuery(myconnection, Querytype, SPName, MySPValues);

return ds;

}

/////////////////////////////////////////////

 

And  Now i Share You My Cs Page of Button Click ---

 

 

protected void btnsubmit_Click(object sender, EventArgs e)

{

DCI_BAL objDCI_BAL = new DCI_BAL();

DataSet ds = new DataSet();

string collegeId = Session["CollegeId"].ToString();

objDCI_BAL.Qtype = "1";

objDCI_BAL.CollegeId = collegeId;

objDCI_BAL.Prospectus_mention_File1 = flpProspectus.;

objDCI_BAL.Prospectus_mention_File2 = flpProspectus.;

objDCI_BAL.Prospectus_mention_File3 = flpProspectus.;

objDCI_BAL.Prospectus_mention_File4 = flpProspectus.;

objDCI_BAL.Prospectus_mention_File5 = flpProspectus.;

}

 

and Hear is File Upload Code-----

 

 

if (flpProspectus.HasFile)

{

string fileExtension = System.IO.Path.GetExtension(flpProspectus.FileName);

int fileSize = FileUpload2.PostedFile.ContentLength;

// If file size is greater than 2 MB

if (fileSize > 2097152)

{

Label2.ForeColor = System.Drawing.Color.Red;

Label2.Text = "File size cannot be Less than 2 MB";

}

else

{

HttpFileCollection hfc = Request.Files;

for (int i = 0; i < hfc.Count; i++)

{

HttpPostedFile hpf = hfc[i];

if (hpf.ContentLength > 0)

{

hpf.SaveAs(Server.MapPath("~/college/fileupload3/") +System.IO.Path.GetFileName(hpf.FileName));

}

}

}

}

else

{

lblMessage.ForeColor = System.Drawing.Color.Red;

lblMessage.Text = "Please select a file";

}

 

 

I Want To Know--

 File Upload Id is flpProspectus  and i want to upload 5 file in this column which is on my button click event

Column Name--

Prospectus_mention_File1

Prospectus_mention_File2

Prospectus_mention_File3

Prospectus_mention_File4

Prospectus_mention_File5 

 

so How to call file upload and save into database

 

please help