[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)
i am currently facing some problem retrieving image for display on a gridview control. the Image data type in the data table is "image". the data that is stored inside the database is in this format "<Binary data>". may i ask if it is possible tojust retrieve a image data of this format and display in the gridview? or do i need to store the image in a image folder for retrieval?
View 3 RepliesMy apps required me to store upload files into SQL binary fields. And then allow users to retrieve the files and either chose an apps to view them or save on disk. These files can be in diff formats, not just one type.
I have been reading about using the Response.ContentType method and Response.AddHeader method. The issue is the users can upload anykind of documents, ie: MS words, Xcel, JPEG,TIFF.... So at the time of downloading, I have no way of knowing that type it is to put in the Response.ContentType.
Can't I just stream it to the browser, let the download dialog box handle the type selection? as in when you download a file, the dialog box would ask if you want to select an app to open the file or save it on disk. How would I do so ?
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 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 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.
I am storing image (jpeg) files into SQL server 2005 using MS Access Forms. When I try to read and render it on a webpage using ASP.net and C# code behind, it could not read it.
But if I write the image to SQL server using ASP.NET C# and then read it back using ASP.NET C#, it render the image just fine in the browser.
Does anyone know if Access write the blob is difference than ASP.NET write the blob into SQL server? I am using the same varbinary as my column in the database.
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 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;
}
}
For all of my cases, I have binary data for pdf stored in my database. I have a stored proc that brings the binary for each case.How do I read this binary to store as pdf on a file server?How do merge these pdf files fo a set of cases and stored a merged file on the file server?
View 2 RepliesI am using a SQL stored procedure to insert client records into multiple tables.
this is my datasource markup:
[Code]....
I am using a multiview to step through the input pages then on the last view there is a submit button that fires this:
[Code]....
this is my stored procedure:
[Code]....
I get the Erorr: Input String was NOT a correct format.
The first three controlparameters are STRINGS and they work fine.
However the last two populate the controlparameter from text boxes that can only accept numbers and decimal point.
First the text boxes for {3} and {4} string parameters in the SQL filterexpression:
[Code]....
And then the SQLDatasource control parameters[Code]....
The last two control parameters are the ones is question as they feed {3} and {4} parameters in the filter expression, NOTICE how I set the type="double".The data input is expected to be like 152.25 or 3.6 or 4 etc,So why am I getting this error: [Code]....
I want to Export my gridview to Excel BIFF. Could any one suggest the approaches to do this.
View 2 Repliesi need a image control, who is able to convert the binary image data into image automatically, i find one which is paid control by telerik, but i need a freeware of it.
View 3 RepliesHow to Update Binary Image on Formview
[Code]....
i want to show binary image in griedview. which is store in database.i was trying but not get this.
View 3 RepliesI want to load an image file (Converted in bytestream) from Database to Piczard Control.How to do perform this operation ??
View 1 RepliesHow would I go about inserting an image that's in my images folder into a sql table column of datatype varbinary(MAX) ?
View 5 RepliesI am developing an application in which i have to store image in database SQL server2008. I want to use upload file control and only want to upload .jpg and JPEG file and view this image in image control . And when i want to update this record i can update that image too..
View 1 RepliesI've created 2 web user controls. A = User control that displays an image, and B is the user control that hosts A. I'm trying to stream an array of bytes to A, but it seems like the Response.BinaryWrite method completely overwrites any heirachial controls (I can't see any of B's other controls besides the image).
How do I get A to just display the image from the byte stream? It doesn't come from a database, it's an image I created on the fly.
A's code:
[Code]....
I have a objectdatasource control with a field of date and time and I was wanting to know how you format the date to uk format with the select statement through my objectdatasource. And what type of integer is bigint in SQL?
View 3 Repliesi 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'm having a hard time solving what should (I think) be an easy problem. I have a formview defaulting to Editmode. One of my data fields is a binary image. How can I change the editItem template to allow a user to upload a new image into the binary image field?
View 2 Repliesalong with a gridview update file that I store in my database
View 1 Replies[URL]
i am failing to get the Base64 string and show it as an image in the output pdf file.
I have a signautre canvas that saves the output directly into the sql database.
