I want to Save image into DB in Binary format without upload control i.e
I have avatar which i want to store by default with user creation.
i know all other steps except how to convert that particular image into binary against btn_CreateUser Click event
I have filed image type varbinary
I want upload image and show then with click button save
store in db
Actually I want to get a file and save its length, its MIME type, content into database in binary format.
It saved but not open in hander in correct format.
[code]....
1. I have a file upload tool to get any file okay..
2. I want to get binary format of any file that i browse through upload tool and
3. I want to save it in another file say any text file or database or any custom file type
4. Now that i've binary format of any file say a image file, how can i recreate the file from it's binary content... all i need is....FIle to Binary and then Binary to Original File.
i have a requirement where i need to save image to database. Iam in confusion whether to save the path of image in database by saving the image in folder or to save the binary data of image to database.
View 5 Replies[Code]....
I am using above mentioned code to insert image in binary format and display
Insertion code is working fine but image cannot be retrieved from DB
(Note: there is no syntex error in Code)
If any user gives the information of his photo in binary objects how can i search it and how can i display the corresponding image that was stored in the sql database
View 4 RepliesI am getting the error: String or binary data would be truncated. The statement has been terminated. when trying to upload an image. What would cause this? my code is:
protected void Button1_Click(object sender, EventArgs e)
{
if (IsPostBack)
{
HandleUploadedFile();
}
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
System.Data.SqlClient.SqlConnection sqlConnection1 =
new System.Data.SqlClient.SqlConnection(connectionString);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT INTO picstosort (imageurl, useraddy) VALUES (@imageurl, @useraddy)";
cmd.Parameters.AddWithValue("@imageurl", Label5.Text);
cmd.Parameters.AddWithValue("@useraddy", TextBox1.Text);
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
if (TextBox1.Text != null)
{
string strTo = TextBox1.Text;
string strFrom = "noreply@test.com";
string strSubject = "Picture Uploaded";
SmtpMail.Send(strFrom, strTo, strSubject,
"Thank you for uploading your picture! ");
}
}
private void HandleUploadedFile()
{
string root = Server.MapPath("~/");
if (!root.EndsWith(@""))
root +=@"";
string fileDirectory = root + @"Images";
string link = "<a href='Images/{0}' target='_blank'>{1}</a>{2}{3}";
for (int i = 0; i<Request.Files.Count; i++)
{
HttpPostedFile fi = Request.Files.Get(i);
byte[] fileBytes = new byte [fi.ContentLength];
using (System.IO.Stream stream = fi.InputStream)
{
stream.Read(fileBytes, 0, fi.ContentLength);
}
string fileName = Guid.NewGuid().ToString();
File.WriteAllBytes(fileDirectory + fileName + "_small.jpg",
ResizeImageFile(fileBytes, 10000));
litText.Text += string.Format(link, fileName + "_small.jpg",
fileName + " Small", "<br/>", "<br/>");
Label5.Text = fileDirectory + fileName + ".jpg";
litText.Visible = true;
fileBytes = null;
}}
private static byte[] ResizeImageFile(byte[] imageFile, int targetSize)
{
using (System.Drawing.Image oldImage = System.Drawing.Image.FromStream(new MemoryStream(imageFile)))
{
Size newSize = CalculateDimensions(oldImage.Size, targetSize);
using (Bitmap newImage = new Bitmap(newSize.Width, newSize.Height, PixelFormat.Format24bppRgb))
{
using(Graphics canvas = Graphics.FromImage(newImage))
{
canvas.SmoothingMode = SmoothingMode.AntiAlias;
canvas.InterpolationMode = InterpolationMode.HighQualityBicubic;
canvas.PixelOffsetMode = PixelOffsetMode.HighQuality;
canvas.DrawImage(oldImage,
new Rectangle(new Point(0, 0), newSize));
MemoryStream m = new MemoryStream();
newImage.Save(m, ImageFormat.Jpeg);
return m.GetBuffer();
}}}}
private static Size CalculateDimensions(Size oldSize, int targetSize)
{
Size newSize = new Size();
if (oldSize.Height > oldSize.Width)
{
newSize.Width = (int)(oldSize.Width * ((float)targetSize / (float)oldSize.Height));
newSize.Height = targetSize;
}
else{
newSize.Width = targetSize;
newSize.Height =
(int)(oldSize.Height * ((float)targetSize / (float)oldSize.Width));
}
return newSize;
}
}
I have a problem with deserializing in C#/ASP.NET, which gives the exact error:
The input stream is not a valid binary format. The starting contents (in bytes) are: 41-41-45-41-41-41-44-2F-2F-2F-2F-2F-41-51-41-41-41 ...
What I am trying to do
I have a structure with 3 classes. I have a class A which is a base class, and then class B and C which are derived from A.
I am trying to store random types of B and C in the database using LINQ to SQL, in a column with the type VARCHAR(MAX).
I cannot use BINARY as the length is around 15.000.
My code...
[code]...
So the error happends when the first Deserialize method is run, with the above error.
Is it possible to convert a datatable into binary data and save it into on a binary field on database?
View 2 RepliesHow to copy selected contents(it may be image or text) of pdf using asp.net, C#?
Is there any API which I can use for this?
I want to open pdf in which I can select particular portion of that pdf and need to save that portion in specific folder in image format.
I need to upload and save an image onto the server. I am using an XMLHttpRequest POST to send the image to the server and calling a class named imageSave.aspx.I am finding difficulty in "catching" the image from server side (imageSave.aspx) and saving it onto the server.
Does anyone please have some tips as to how this is done or maybe link to a good article or something?
Code used to perform the http POST....
xhr = new XMLHttpRequest();
// Update progress bar etc [code].....
how can we resize the image in ASP.net n save changes in database ??.
View 1 RepliesCurrently i have done upload image function and its saved the picture into folder in server . But if the picture has same name its unable to save the photo . How to rename the photo each time i save the photo into the server . Below is my coding .
<asp:FileUpload ID="FileUpload1" runat="server" />
<input type="button" id="btnUpload" runat="server" value="UploadPhoto" onserverclick="btnUpload_Click" />
protected void btnUpload_Click(object sender, EventArgs e)
[Code]....
I have stored image into database as a binary format .. but when i run my webside ... browser show only text data into gridview .. not showing image ... although image is already saved into database. How can i solve it..(any property of grid view which show image) ....
View 1 RepliesI want to load an image file (Converted in bytestream) from Database to Piczard Control.How to do perform this operation ??
View 1 RepliesI have written a website and let the user upload their photo. It also resizes the picture to 400 x 400 and crops automatically to the center part of the picture. All of this works good but each file is about 355K each for JPG and PNG file formats. I just tried GIF and it is 49K but the picture is grainy when saved this way. Is there any way I can get the picture to a smaller file size with keeping it at 400 x 400? I really thought PNG would be the way to go and was surprised by it being the same as jpg. I don't want to lower the quality either for JPG files.
View 1 RepliesI am writing code for upload image file and save it into disc ,,, during this and before save it to disc I want to resize the image into specified width and Heigh. i am trying to use this code
[Code]....
but I dont have Neodynamic.WebControls.ImageDraw.dll?
i wan code for profile image setting. user can able to resize image by selecting size in the dropbox. and image cand drag specific location,(canvas image-->image can bigger then canvas and he can drag image withini the canvas,image shoud save--withini the canvas width and height)
Rquirements
1)user upload the image and will save that image and will disply the image at left side show in the figure.
2) user can select the size of the image from dropbox. the image size will be alter depend upon the selected size.
3)user can drag the image in the specific location. i mean selecting image with mouse can drag, shoud be dragable.
4)same as profile image setting of gmail,facebook and skype.
i have dataset containing multiple images in binary format,how i can use handler to display those images from dataset which i am having,without needing to pass id in query string to handler each time?
View 4 RepliesI use these code to dispalying image from database. [URL]... I use these code for my data list
<asp:DataList ID="DataList1" runat="server" RepeatColumns="4"
RepeatDirection="Horizontal">
<ItemTemplate>
<table class="DDLh">
[code]....
For displaying image we should write this code
<asp:image ToolTip = "ASP Image Control" ID="Image13" runat="server" ImageUrl ="~/imageH.aspx?ImageID=48" Height="156px" Width="174px"></asp:image>
now here in my data list what should i write instead of this code?untill it show my image from database?
<asp:image ID="img1" runat="server" CssClass="TPH" ImageUrl='<%#Eval("image","image/house/{0}")%>' BorderStyle="Solid" BorderWidth="1px" BorderColor="#c9c9c7" />
I have another problem is that I have Placed a file upload control in Empty template of Gridview to have multiple record insert. I have used viewstate to save multiple record into database. But problem is that I am able to find the control but it not giving any value.I have following code.
[Code]....
in above code
[Code]....
i want show an image in image control as user select an image file through fileupload control. and i not want saving image on the my server
View 2 RepliesWe have a scenario where we would like to allow our users to upload images to the site. We are running on ASP.Net. A quick search did not result in anything good. It would be great if the control is free/open source but we do not mind paying a little bit.
View 1 Repliesi'm a new in web page application
can any one tll me how to upload in image in the web page and dispay it in an image control then save the path to the database?