DataSource Controls :: Storing Large Files In Database?
Aug 6, 2010
I want to upload some large files from a web page to MS SQL Sever database, I am very sure that it is sounding weird.
File sizes are around 100MB.
I am having following settings,
SessionTimeOut period = 60 Mins,
Server Operation timeout = 60 Mins,
SQL Connection Timeout = 4 mins (Not sure if this is helping)
This is page is going to be used by our client only once a week & as they are having web farm environment we are avpiding to store these files on file systems.
Currenty we are able to upload files with sizes upto 8 MB succesfully. But when we are uploading a file of 100MB it fails, its for sure that operation takes lots of time.
I used SQLMetal to generate a DBML file, which worked fine. The problem is that since this DBML file is so big (185,000 lines at 840Kb) it takes literally hours to load in VS2008. What is the recommended way to resolve this? I tried using a third party tool call SqlMetalInclude to break the DBML up into multiple data contexts, but that tool generates only designer.cs files, not dbml files.
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.
Have a question about the best approach for file storage in a SQL database. I have a table called Widgets, and each row in the Widgets table can have multiple files. I also have another table called Extensions, and again each record in this table can have many files.
Here is what I am considering:
Approach #1:
[Code]....
That approach is very simple and easy to use, but I feel that I could merge the two file tables into one, then use lookup tables:
Approach #2:
[Code]....
The thing is, there are no duplicate or shared files between the two types of objects. So even though I feel better about approach #2, I am concerned that I may be adding additional complexity (and using more server resources to perform the joins), than needed.
I need to populate a database (SQL Server) with some data from a templated excel document.Here are some approaches:
A) User upload a file.xls or file.csv that the server reads, checks and updates the database (cons:the uploaded file might be too big. file.* needs to be in correct format)
B) User downloads a tool.exe to read and upload file.xls (cons: maintenance of the tool.exe)
C) Use of a web service in excel? (don't know how to do it) but this article might give you a hint
Which one is the best to use? Are there any others?
In my web application I am working with files. Some files are very large. I use Response.Write() to write the file to the browser. This goes well for the smaller files, but for large files this can take a while and the bandwidth is fully used.
Is it possible to split large documents and send it piece by piece to the browser? Are there other ways to send the document quicker to the browser?I hold the document as a property of an object.
I am a new-bie in Asp.Net.I am working in a project where I need to store an attachment which will be uploaded by the user in radGrid into Sql server 2005 database.After storing this attachment, I have to retrieve this attcahment and show the same to the other users in radGrid so that they will be able to download the attachment and see that.How should I do that?what kind of datatype would it be?
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?
I have developed an asp.net application that I developed using visual studio express 2008.
With this application, I have 20 sales items. I can sell 10 of each item each day. Customers can order the items in advance but once an item has more than 10 orders for the day then I can not sell any more of the items for that given day. If a customer tries to order another item after 10 has already been ordered then I must tell them that no further items of that kind are available. So for each day there can be possible 200 orders total (20 items x 10 sales). Customers can order months in advance...
So, my question is what kind of storage device do I use to keep track of this kind of data? Database or application variable or other?
Im in the process of developing a web application, and I wish to store a reasonable amount of data for each user.
This data will be accessed each time the page is refreshed.
The only 2 options that I have come up with is:
* Session Data * Storing the information in a text file with random file names for each person * Database
The first one I do not really want to use as it would bog down the server - the second one is cumbersome
Is there any other options?
If possible i was thinking using the database, but am hesitant because of the amount of times the accessing of the database would need (every refresh for every user)
I dont want to store the information inside the viewstate (i dont know what MS was thinking when they thought of viewstate)
how to store common data like an arraylist of Sports Class which will have different variables in it. I want to access that Arraylist from Vaious pages.
I am new in PHP Progamming, but done sufficient amount of Web Programming in .Net.
I have a scenario for which I wanted the best solution in asp.net c#. My application allows users to retrieve search data from database, this data is the users own temporary list of records which they can search, delete records or select them. All these actions are only on users temporary data list and not on the data base. I have currently carried out this functionality using data table which is stored in session. This method is causing problems when huge amounts of data is held in session (eg: 7000 records). I need a best possible solution for this. Is creating temporary tables an option? Can it be assigned to particular user sessions? Please point me to the right direction and right articles.
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
Ms SQL 2005 database I have a empty database at my hoster site. Its has nothing in it period. The admin's of the hosting site (asp.net 2.0) said send them a .bak file. .bak files are from "generate a backup" of a database in TOTAL. So I can see how a .bak file can restore a FULL database, but what about changing a stored proc?? Q1: The hoster admins only want .bak files to do tweaks to my database, so how does a .bak file acheive this for a just adding a table or a store proc only ? Q2: Some tables had data in them on my localhost, is there a way to generate a INSERT script for each data row and run this code at hoster site, or do I have to do an EXPORT from my localhost and an import at my hosting site?
Not sure if this is the correct section to ask this but this is regarding storing datatype problem.im trying to convert an image file retrieve from a folder and convert it to Byte so that i can save into database
In below function i retrieve and convert the image from a folder to byte
i'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.
I 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.
Is there a way of filtering large CSS files for the only required selectors on a page, and creating css files that contain just these selectors?
Case: I have a very large CSS file that I want to filter on a per page basis, so that the file size is cut down and can be cached by mobile devices. I was thinking along the lines of something like a server side dust me selectors tool.The particular project I am working on is using ASP.NET MVC.
I have MS SQL Server 2008 and I would like to store formatted text from a rich textbox. Formatted in the sense that I want to store a multiple choice question's formatting, an example would be like this:What is 2 + 2?
4 6 2 8
Then when I retrieve it from the SQL database it saves its formatting.
