Web Forms :: Storing Videos And Images Into Database (binary Data)?
Apr 15, 2010
Friends have quick question for you.i want to know storing videos and images into database(binary data) or local hard drive is efficent. What way general websites stores them in their websites.
I have one folder which contains the jpg images. That images i want to store binary format into sql server database. And finally that images binding in the DataGrid.
i want to display the image either from a database or through file upload control but in case of database i had seen your article but what binary data i can store as you had in data column table and when i save a file somewhere through file upload but it is not displaying the image.
I suppose this question has been asked to death all over the web, but I can seem to find a clear cut answer. What I am trying to achieve is as follows: I have a web application that lists various products, their descriptions, names etc and also an image of that specific product. The user will type in a product code or name of the product and a page will pop up with al the previous mentioned info and image or images of that specific product. The problem I am having is: I read somewhere that storing images in a database is 'bad idea' since it effects performance, then I read somewhere else to keep it in the images / or app_data folder. But what would be the best approach and how would I call it from the database (if that's the best way)? And if App_Data / images are the way to go how many images can I put in there (??) already the product catalog has several hundred images of various products. So how would one go about sorting everthing in those folders without having a few hundred images rolling down in my solutions explorer.
i am a beginer and i want to know how to store images in the database tables like pictures of the pizzas and when the user selects one of the pizza from the dropdownlist he sees the image of the selected pizza.
i m developing website using asp.net with microsoft access 2003 i have product details along with the images now i want to add this images into database but how i add this pictures what code is use if there are 100 products with 100 images i want to show 10 records per page i need also code of that
i m developing website using asp.net with microsoft access 2003 i have product details along with the images now i want to add this images into database but how i add this pictures what code is use if there are 100 products with 100 images i want to show 10 records per page i need also code of that
I'm working in ASP.NET 4.0, and I've got a large web form which represents a single business entity. A user can upload multiple images associated with the entity. The entity is created and assigned a GUID upon submitting the form. The files will be stored to a file system.
The problem is that we have to name the files after the GUID that is assigned to the entity after it is inserted to the database. So before the submit button is clicked, we will have several image files floating around in limbo.
There are obvious answers to this question -- you save the images to the file system and then when the business entity is created, you rename those files. However, I believe that there must be very strong patterns and several key details that would make for a very robust system. What's best practice for this scenario?
I have one table "EmpDetails". Fields of the table are empid, empname and empimg. I have stored employee details in these three fields. Now i want to retrive empname and empimg field in my web form. To do this i have taken one data list control. I have wriiten all code to get desired data but i am only getting empname from data base, not getting his/her image from databse. let me tell you i have stored images in database as a binary data. so how to retrive this binary data in datalist as an image.Below is my datalist control.
My requirment is to display all videos by clicking that videos it want to play how to do this .how to add mediaplayer into list view and play the videos.i want to display in this format http://www.youtube.com/results?search_query=sports&aq=f
I have to find a design decision for the following task: I have a SQL Server database and it contains a table of orders. PDF documents will be uploaded by users through a simple file upload from a web page and assigned to an order. There is not more than one document per order (perhaps no document, never more than one). For this purpose a user opens a web page, enters an order number, gets the order displayed and clicks on an upload button. So I know to which order the uploaded document belongs to.
Now I am considering two options to store the documents on the web server:
1) Extend my table of orders by a varbinary(MAX) column and store the PDF document directly into that binary field.
2) Save the PDF file in a specific folder on disk and give it a unique name related to the order (for instance my order number which is a primary key in the database, or a GUID which I could store in an additional column of the order table). Perhaps I have to store the files in subfolders, one per month, and store the subfolder name into the order row in the database, to avoid getting too many thousand files in one folder.
After the PDF files are stored they can be downloaded and viewed via browser after entering the related order number.
I'm tending towards option (1) because the data management seems easier to me having all relevant data in one database. But I am a bit afraid that I could encounter performance issues over time since my database size will grow much faster than with solution (2). Around 90% or even 95% of the total database size would be made up only by those stored PDF files.
Here is some additional information:
The PDF files will have a size of around 100 Kilobyte each Around 1500 orders/PDF files per month Windows Server 2008 R2 / IIS 7.5 SQL Server 2008 SP1 Express Not quite sure about the hardware, I believe one QuadCore Proc. and 4 GB RAM Application is written in ASP.NET Webforms 3.5 SP1
(I am aware that I will reach the 4GB-limit of the SQL Server Express edition after around 2 years with the numbers above. But we can disregard this here, either removing old data from the database or upgrading to a full license will be a possible option.)
My question is: What are the Pro and Contras of the options and what would you recommend? Perhaps someone had a similar task and can report about his experience.
I am writing an application in which a remote url web site ( says url1 that is sender) sends xml data to another web site (says url2 that is receiver) by using .NET WebRequest. On the receiver url2 if I use .NET Page.Response and .NET Page.Request to store posted/received xml data into an external text file, then the data is stored. However, if I store the received data into database, I do not see the data is stored into the database.
trouble shoot the codes so I can store such remotely posted data into database on the receiver side url2.
I host both url1 site and url2 site in my computer using IIS like [URL]
1/ Receiver page's codes that store remotely posted xml data into database do not work:
protected void Page_Load(object sender, EventArgs e) { Page.Response.ContentType = "text/xml"; StreamReader reader = new StreamReader(Page.Request.InputStream); String xmlData= reader.ReadToEnd(); ProductNameSapce.ProductCollection.InsertReceivedProduct(xmlData).ToString(); // data is not stored ; the method is tested and works well with hard-coded data reader.Close(); Page.Response.End(); }
2/ The version of the receiver page at url2 that stores into an external text file works:
protected void Page_Load(object sender, EventArgs e) { Page.Response.ContentType = "text/xml"; StreamReader reader = new StreamReader ( Page.Request.InputStream ); String xmlData= reader.ReadToEnd (); StreamWriter s; s= File.CreateText ( Server.MapPath(".")+@""+ Guid.NewGuid () + ".txt" ); s.WriteLine ( xmlData); // data is stored in an external text file s.Close (); reader.Close(); Page.Response.End(); }
I want to shore youtube url in to database then want to show video in datalist or gridview by using the url. in datalist there will be video player show.
I have a coloumn in a database table in which i am storing the candidates photo in a binary format.
now i have to show these photo in a gridview according to the candidates rollno. i am trying to use the imagefield of a gridview control to display the photo but it is not displaying the photo in a grid view
if (Request.QueryString["vid"] != null) { frmViedo.DataSource = video.GetVideoById(Convert.ToInt32(Request.QueryString["vid"])); frmViedo.DataBind(); } public OleDbDataReader GetVideoById(int id) { string strSelect = "select * from Video where VID = @VID"; return ExecuteReader(CommandType.Text, strSelect, new OleDbParameter[]{ new OleDbParameter("@VID" , id), }); }
But it don't work and i get this error :
Adobe Flash is disabled for this page, click player area to enable. Why?
I am working on the application that allows user to upload a file (from their local machine) and store the uploaded file in database.Then,the content of the file (such as ContentType,FileSize etc)can be view in a DetailsView control.
How to create the popup Video player for local video . I just want to create the popupbox on that i just want to play a video what the local address ihas given.
for example: images/video.mp4 like that I don't want to pass the url.
I have an ASP.NET app that writes binary data to a SQL database. It worked fine using SQL Express, but does not ever write the data using SQL Server 2008 R2. SQL Profiler shows the binary data in the UPDATE query, but nothing happens... no errors, no data saved. Does anyone know what I'm missing? Other data types work fine.