I know this is a wrong place to ask this but i cant resist
I want users of my website to store article with Images..How a i able to store the content in SQL Server?
Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
View 1 RepliesI have read up on uploading multiple images and storing them to a file but so far i am only able to store one image into both file and into database. The problem i have is that i don't know how to create the table to store more than one image?
View 8 RepliesI need rft server control not HTML based server controls to display and store text as well as images, from which i can get rtf text and can save it as it is in DB.
View 1 RepliesI'm constructing a new cms with the option to create reviews and articles (blog items). Now if the user wants to write a review he/ she will want to add a lot of images in the text. Now my question to you is , what would be the best option to include those images (with keeping in mind that a CDN can be used later). I was thinking of the following methods:
Break an article in multiple blocks, each block can then include a picture and text. Just add the picture in the text via WYSIWYG editor (easiest option but not so versatile) Upload images separately and include them via tags in article text. Like Title{img_1}Content
I want to store image in sql server 2008(what is datatype for image??) where image uploaded by the user using asp fileupload text box and buttom control..and then i want to retrieve that image to show as profile information for users.
View 5 RepliesThe user can write articles and upload images related to that article. Let's say that there is a form that collect the article text and, under it, there is a FileUpload control for images. Here, I have a question. What if the user has uploaded some images and then he closed the browser, before submitting, cancelling the operation? the images have been uploaded to the server wasting space!
one solution I've figured out is to store "ImageInfo"s in a list, and store the list in the Session object. And when the user submit the article, the images in the list should be marked as "related" and then inserted. and in the Session_End event I should delete every image does not have the "related" mark.
I had a little problem with the value that one of my SPs returns. In my SP, I create some temporary tables to store certain data from multiple tables and contains some queries for an advanced calculationBut precisely yesterday, the value that the SP returns was incorrect. I tried to look at the SP and the data again and everything was OK, but not the result from the SP.And what the heck!!..today the value is totally right ...I truly have no idea what's wrong with the SP..Is there anyone knows what the root of cause is?
View 4 RepliesI 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 Replies1)How to convert 64base string to binary in asp.net and store into sql server.
2)when i convert 64 base string into binary & try to store it into database then it has taken so much tiime to insert. The size of 64base string is 1.5MB. and when i converted to binary then the size is 11MB.so the best way to insert the binary data into sql server. The data type of column is varbinary(MAX).
3)How can i insert the varbinary data into sql server uisng asp.net?
I am trying to build a small e-commerce website that will allow user to upload and store the image of their product in the database and also the user could upload the image of the product and compare it with all the similar product images that are already stored in the database. I am using MS ASP.Net using VB.Net as the front end.
if MS SQL server is the best option to carry out such task or should I consider some other database to do this in terms of complexity involved as well as the integration with MS .Net framework.
I am facing a problem with retrieving an image and showing it on asp.net grid. I migrated MS Access database to sql server. Image are visible in Crystal report when fetched from the same database (migrated sql server database). But same images are not visible in ASP.Net grid view or simple asp.net image control. Following is my code
SqlConnection oConn =
new
SqlConnection(ConfigurationManager.ConnectionStrings["csr"].ToString());
oConn.Open();
SqlCommand oraCmd = oConn.CreateCommand();
oraCmd.CommandText = "select top 1 photo from [test] where photo is not null";
SqlDataReader dr =
null;
dr = oraCmd .ExecuteReader ();
if(dr.Read ())
if (dr["photo"] !=
null)
{
Response.ContentType = "image/gif";
Response.BinaryWrite((byte[])dr["photo"]);
}
This function is getting called from another page . "hlopen" is hyper link in the grid. hlopen.NavigateUrl = "GetPhoto.aspx?id=1";
I have setup a job in SQL Server Agent which run a store procedure.
[Code]....
After the job excuted, the temp table have not been created.
If I type "exec data_syn_ClearAllEposData". The temp table has been created.
Global Temp table cannot create in SQL SERVER AGENT?
I want to write one program by visual studio 2008 (C# and ASP) that has web application and windows application.
I want to get clients images in web app(upload) and store them in DB (mysql) then send these images to windows app via web service (so i new web service, not web site). But i have 2 problems:
I have 2 ways to store images in mysql, first i should have BLOB field in DB -that it takes more space-, second i should save just name of each image in DB(so have image in one folder) -in this way i don't know how get image from clients and store them in that folder-. which one? Or what other? How (code) can i transfer image via web service(Byte[] or? ).
I have the following problem: I need to store in MS SQL Server 2005 a vary large text in to one field of type nvarchar(MAX), In spite of the configuration is apparently correct I keep receiving the following message in the exception: "string or binary data would be truncated".
View 1 RepliesHere is what I am basically trying to accomplish I want to upload images to the server separated into categories and save the file path into the database. I have found plenty of documentation on saving to a file and the file path to a database. But, I haven't found anything that will allow me to seperate the images into categoies.
I have made three tables in the database
[code]....
What I am trying to do is create a gallery for our clients to browse and download different vesions of posters and ad cards.
how to storethe image path in database and how to access image from database in asp web form
View 1 RepliesI would like to store images in database by converting them in to binary objects or i will store them in to a temp folder and will save the path in my database. But i am unable to do the programming so can any give me a sample code to save images in to sql database using Asp.net.
View 3 RepliesI'm trying to display an image from my database but when I try to extract the file it only contains 6 bytes of data which causes my program to throw an error. My instructor informed me that the file is too small for an image, leading me to believe that I'm not storing it properly. I would be most gracious if someone could identify any code that might cause this to happen.
Protected Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
Dim _image As Byte()
mage = FileUpload1.FileBytes
Dim conn As New SqlConnection
[code]...
1.store them in the file system of web server and put the url in the table?
2.store them as type "image"?
3.store them as varbinary(max) BLOB?
4.store them as filestream data?
I've a classified ads system on ASP.NET/c#/MS SQL, and I'm trying to figure out where to store the images that people upload when placing an ad. The ad itself is being stored in a SQL server database.
The images are now being stored in a subfolder of my webapp. It seems to work fine, however I only recently discovered a big problem. Everytime a user deletes an ad, the attached images are to be deleted as well including the folder they reside in. This leads to a restart of the asp.net application. I searched internet and found that restarting the web-app is actually intended behaviour when a subfolder is being deleted.
I can remove these images including the folders they are stored in?
I can acces them using a URL (the images need to be shown in the webpages) Without getting the web-app being restarted?
I am working on a project in which I have to store atleast 100000 images and rich media like virtual tour, promotional videos. I would like to know the best practice to store it in order to retrieve it in show it on website. What should I store it as: Store the url into the database and store the actual image on the physical server. Store the image itself as a binary into the sql server itself and then convert it to runtime and show on the website. I need to know which way is the best and suitable way to do this task.
View 6 RepliesI have a table which contain products, I want each record in the table to have an image. I've created the field with the datatype image. How to I manually add image to the table ?
What data type in SQL should i use to store an XML file? And how do i do it?
View 5 Repliesi have follwing column in databse Name,age,Education,Intrest,MyImage(optional field)
i want to store the follwing info in databse using linq to sql, i know how to store other type of data then image, how to store image with above information keep in mind that image is optional...