I am doing a Project of Uploading the files to SQL Server and then Download it I want to Select Multiple files to be Selected and Uploaded at a Single Click but Presently a Single File is selected and Uploaded both to FTP Server and SQL Server, could any one Suggest me a link or Sample Code to Select Multiple Files and Upload it to SQL Server
Thanks in Advance...
You need to use FileUpload.PostedFiles Property
Try with following code:
foreach (HttpPostedFile upFile in FileUpload1.PostedFiles)
{
SaveFiles(upFile);
}
private void SaveFiles(HttpPostedFile fObj)
{
using(SqlConnection con = new SqlConnection(ConnectionString))// set ConnectionString
{
using(SqlCommand cmd = new SqlCommand(DatabaseQuery,con)) // set appropriate query
{
cmd.Parameters.AddWithValue("@data", ReadFile(fObj));
con.Open();
cmd.ExecuteNonQuery();
}
}
}
private byte[] ReadFile(HttpPostedFile fObj2)
{
byte[] data = new Byte[fObj2.ContentLength];
fObj2.InputStream.Read(data, 0, file.ContentLength);
return data;
}
MSDN:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.fileupload.postedfiles.aspx
Hope Its Helpful.
Be sure to use the AllowMultiple attribute (supported by .Net 4.5):
<asp:FileUpload ID="MyFileUpload" runat="server" AllowMultiple="true" />
You can now select multiple files with ALT/STRG to be uploaded. Then use Freelancer´s code.
