Data Controls :: How To Attach Multiple Files And Store In Database
May 21, 2013i have a file upload control that attach files.i want to attch multiple files and that should be stored in database
and code to store multiple attchment
i have a file upload control that attach files.i want to attch multiple files and that should be stored in database
and code to store multiple attchment
I have an entity called a file which is the main part of my project. The file has invoices and timesheets captured against it. So I have a file tab with info about the file, like FileNumber, Vessedl, Voyage etc. Now I need to be able to upload documents for the file. So I will add an uploads tab. But the uploaded documents need to be saved for the specified file the user uploads it for. then when a user opens a file I need to show the documents for that file in a list of some sort. the best way to do this. What's the best way to upload multiple files? should I store all the info in my database?
View 36 RepliesI am curious to know the following:
We are going to develop a website where we need to store large number of files. The file size may be uptp 50 MB. What approach should we follow:
1) We should store files in Database
2) We should have a directory and store all the files in that
3) We should hire a SAN Storage and use this seperate location to store the files.
I am working on a journal website where user submit manuscripts , pdf files , is it good idea to store pdf files on directory or on database.
View 1 RepliesI manage to upload multiple files from a web form to my local drive. Say at "D:uploadedfilesamy". How do I attach all files in the directory on my email? The email without attachment is sending just fine.
View 1 Repliestry {
string str = "";
HttpFileCollection fileCollection = Request.Files;
for (int i = 0; i < fileCollection.Count; i++) {
HttpPostedFile uploadfile = fileCollection[i];
[Code] ....
The control jump in catch block or showing error file could not be found, how to remove it ..
my problem is my asp.net and C#.net application should read flat files(.txt,.doc) from folder automatically and read the data from file and stored into database
my file like this :
BNK20100312APPHU6658994 // BNK,20100312(date),Ap,PHU6658994 So we have to store these..
BNK20100312APPRU5104220
BNK20100312APPRU5761800
BNK20100312APPZU3739288
BNK20100312APPZU4454037
BNK20100312APESU2552894
BNK20100312APAXU4302543
BNK20100312APCKU1613369
how to store files (pdf and word files) into sql database and how to display that files with an option of "save" , "open" window from sql data base when user click. i am doing project using c# + asp.net web application
View 1 Repliesi've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
Download multiple file from server and stored in client browse directory.
View 1 Repliesin my system folder(E:\santhu) i have flat files(.txt and .doc ) .my problem is how to read those files automatically one by one and store the data(records) in to database?
View 8 RepliesI am creating a video database .. User will upload his video.. I know the path will be store in database and video on hard disk .. How video will upload, path are set, and if possible video is downloaded.. I am not creating online streaming .. Just upload and download ..
View 1 RepliesIts related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
View 9 RepliesI have seen in your's Save and Retrieve Files from SQL Server Database using ASP.Net
there it is accepting only specific file but i want it should take all type of files. and store it in the database.
I have a project where I need to create a folder type view which will show a list of files, and the description of them to the user when they navigate to the website.
View 3 Replieshow to store the 'multiple check box ' record in a database in a single column .. example like "hobbies" for this we have to select multiple check boxes
View 1 RepliesI creating a page where our clients can view advertising images and then able to download the images in different file formats. So I need the images and the different download types all saved into the same row in the database so that when I go to display them on the page when they select a picture the right download links will be there. So here where my problem comes in, I don't know how to code it so that I can insert mulitiple file paths into the database at once. The images are saved in a table called images. The downloads are saved in a table called Image Downloads.
Here is the code for the page I have it coded to submit the images to the database but not sure how to add the rest. I have got three different sql datasources for each table not sure if that's the way to go.
[Code]....
iam using asp.net2.0 with c#
in my gridview iam at page load event iam displaying data from view.my 1st column in the gridview is checkbox, when user selects the checkbox and iam using paging in gridview, when user selects the checkbox and selects the rows from first page or from any page, that have to be stored in database.
in my database the table contains
orderid int primary key autoincrement
productname nvarchar
price nvarchar
quantity nvarchar
total nvarchar
when user selects the rows then in database how to store multiple rows in that table field
iam using asp.net2.0 with c#
in my gridview iam at page load event iam displaying data from view.my 1st column in the gridview is checkbox, when user selects the checkbox and iam using paging in gridview, when user selects the checkbox and selects the rows from first page or from any page, that have to be stored in database.
in my database the table contains
orderid int primary key autoincrement
productname nvarchar
price nvarchar
quantity nvarchar
total nvarchar
when user selects the rows then in database how to store multiple rows in that table field
am able to download single files which is coming as bytes from database..how to go with multiple files....
View 4 Replies1. How to store I ZIP file in Database using FileUpload in ASP.NET C#
2. Also need to downloading it from database by gridview
I have a form on which anyone can send me his/her information. Now i want to add 2 or 3 file upload options so that anyone from the website can send me their files along with the information. For getting information i am using this code (in button click) which works fine for me:
using System;
using System.Net.Mail;
using System.Text;
using System.Web.UI;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
protected void btnMyButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
string enquiry = txtEnquiry.Text.Trim();
if (String.IsNullOrEmpty(enquiry))
return;
string emailTitle = GetLocaleResourceString("MyTopic.EmailTitle");
string fullName = txtFullName.Text.Trim();
string email = txtEmail.Text.Trim();
string subject = string.Format("{0}. {1}", SettingManager.StoreName, emailTitle);
var body = new StringBuilder();
body.AppendFormat("<hr />{0} ({1})<hr />", emailTitle, DateTime.Now.ToShortDateString());
body.AppendFormat("<b>{0}:</b> {1}<br />", GetLocaleResourceString("MyTopic.FullName"), fullName);
body.AppendFormat("<b>{0}:</b> {1}<br />", GetLocaleResourceString("MyTopic.E-MailAddress"), email);
body.Append("<br />");
body.AppendFormat("<b>{0}:</b><br /> {1}<br />", GetLocaleResourceString("MyTopic.Enquiry"), MessageManager.FormatContactUsFormText(enquiry));
var from = new MailAddress(email, fullName);
var emailAccount = MessageManager.DefaultEmailAccount;
string body2 = body.ToString();
//required for some SMTP servers
if (SettingManager.GetSettingValueBoolean("Email.UseSystemEmailForContactUsForm"))
{
from = new MailAddress(emailAccount.Email, emailAccount.DisplayName);
body2 = string.Format("<b>From</b>: {0} - {1}<br /><br />{2}", Server.HtmlEncode(fullName), Server.HtmlEncode(email), body2);
}
var to = new MailAddress(emailAccount.Email, emailAccount.DisplayName);
MessageManager.InsertQueuedEmail(5, from, to, string.Empty, string.Empty, subject, body2,
DateTime.UtcNow, 0, null, emailAccount.EmailAccountId);
pnlResult.Visible = true;
pnlRequestQuote.Visible = false;
}
Now I added 3 file upload options in the page, now when i try to add code in .cs file i get errors. This is what i am trying to add (in BOLD)
protected void btnMyButton_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
string enquiry = txtEnquiry.Text.Trim();
if (String.IsNullOrEmpty(enquiry))
return;
string emailTitle = GetLocaleResourceString("MyTopic.EmailTitle");
string fullName = txtFullName.Text.Trim();
string email = txtEmail.Text.Trim();
string subject = string.Format("{0}. {1}", SettingManager.StoreName, emailTitle);
var body = new StringBuilder();
body.AppendFormat("<hr />{0} ({1})<hr />", emailTitle, DateTime.Now.ToShortDateString());
body.AppendFormat("<b>{0}:</b> {1}<br />", GetLocaleResourceString("MyTopic.FullName"), fullName);
body.AppendFormat("<b>{0}:</b> {1}<br />", GetLocaleResourceString("MyTopic.E-MailAddress"), email);
body.Append("<br />");
body.AppendFormat("<b>{0}:</b><br /> {1}<br />", GetLocaleResourceString("MyTopic.Enquiry"), MessageManager.FormatContactUsFormText(enquiry));
//'Attach the file
if (FileUpload2.HasFile)
{
body.Attachments.Add(new Attachment(AttachmentFile.PostedFile.InputStream, AttachmentFile.FileName));
body.Attachments.Add(new Attachment(FileUpload1.PostedFile.InputStream, FileUpload1.FileName));
body.Attachments.Add(new Attachment(FileUpload2.PostedFile.InputStream, FileUpload2.FileName));
}
else
{
body.Attachments.Add(new Attachment(AttachmentFile.PostedFile.InputStream, AttachmentFile.FileName));
body.Attachments.Add(new Attachment(FileUpload1.PostedFile.InputStream, FileUpload1.FileName));
}
var from = new MailAddress(email, fullName);
var emailAccount = MessageManager.DefaultEmailAccount;
string body2 = body.ToString();
//required for some SMTP servers
if (SettingManager.GetSettingValueBoolean("Email.UseSystemEmailForContactUsForm"))
{
from = new MailAddress(emailAccount.Email, emailAccount.DisplayName);
body2 = string.Format("<b>From</b>: {0} - {1}<br /><br />{2}", Server.HtmlEncode(fullName), Server.HtmlEncode(email), body2);
}
var to = new MailAddress(emailAccount.Email, emailAccount.DisplayName);
MessageManager.InsertQueuedEmail(5, from, to, string.Empty, string.Empty, subject, body2,
DateTime.UtcNow, 0, null, emailAccount.EmailAccountId);
pnlResult.Visible = true;
pnlRequestQuote.Visible = false;
}
I get this error message:
System.Text.StringBuilder' does not contain a definition for 'Attachments' and no extension method 'Attachments' accepting a first argument of type 'System.Text.StringBuilder' could be found (are you missing a using directive or an assembly reference?)
My hosting company provider MS SQL Express as part of my hosting package, they have provided me with both the name and IP address of the server running MS SQL Express.
I have created a database on this server via management studio and when I create a connection string like this (connectionString="Data Source=ServerName/IP;Persist Security Info=True;User ID=xxx;Password=xxx") my application works fine.
But if I create a local database file and try to attach this with a connection string like this (connectionString="Data SourceServerName/IP; AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance = True ; Trusted_Connection=Yes) my application doesn't work.
Therefore my questions are:-
Is there something wrong with my connection string? Can you use a local database file within a production environment?
If you can I want Upload multiple files in database like this....
View 1 Repliesi want to store Session["Name"] into databse "name" column. how to do this ?
View 1 Replies