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.
View 6 Replies
Similar Messages:
Oct 27, 2010
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.
View 2 Replies
Mar 11, 2013
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.
View 1 Replies
Dec 22, 2010
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.
View 5 Replies
Jan 28, 2011
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.
View 2 Replies
Sep 20, 2010
Is it possible to convert a datatable into binary data and save it into on a binary field on database?
View 2 Replies
Aug 12, 2010
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
View 3 Replies
Aug 12, 2010
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
View 17 Replies
Mar 21, 2011
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?
View 3 Replies
Jan 29, 2011
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.
<asp:DataList id="ItemsList"
BorderColor="black"
CellPadding="5"
CellSpacing="5"
[Code]....
View 2 Replies
Feb 3, 2011
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
View 3 Replies
Feb 27, 2010
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.
View 5 Replies
Dec 2, 2011
I want to save binary information like images, files ,etc to SQL server database.
View 1 Replies
Aug 8, 2012
How i can download image from sql server and store in a folder?
View 1 Replies
May 7, 2015
how to upload videos and after uploaded the videos then play it..using flash player......
View 1 Replies
Oct 29, 2010
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();
}
View 10 Replies
Jan 27, 2010
I want to store Date as well as time in a label. The code that i am writing is Label1.Text = Datetime.Now.ToString();
I want to save this value in to the database. This is what i am writing
com.Parameters.Add ("@Dt ", SqlDbType.datetime).Value = label1.Text; // this is the problem.
View 6 Replies
May 7, 2015
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.
View 1 Replies
Oct 25, 2010
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
View 3 Replies
Mar 8, 2014
I want use flowplayer to play my flv video file. I have a datalist like below :
<asp:DataList ID="frmViedo" runat="server">
<ItemTemplate>
<div class="flowplayer"> <video>
<source type="video/flv" src='<%# Eval("Vurl" , "~/Videos/Video/{0}") %>'>
</video></div>
</ItemTemplate></asp:DataList>
In code behind :
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?
View 1 Replies
May 21, 2012
how to store video file in database and which control to display the video..
View 1 Replies
Mar 25, 2013
i am already uploading some videos from sql server database.
Now, i want to display these videos from gridview using like query..
when i clicking the view button the videos are visible to gridview based on select query...
View 1 Replies
Dec 15, 2010
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.
View 1 Replies
Jul 29, 2013
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.
View 1 Replies
Sep 24, 2010
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.
My data type is VarBinary(MAX)...
View 7 Replies