can some one help me. im using visual studio.net 2005. its a web application.
i have a database with attribute name logo. so i want to upload an image and save it into the database and than display it into the image box to preview how the image looks like.
can some one please help me as i am very new in using C# codes and visual studio.net 2005
Hi Group,
What SQL Datatype would I use to hold a JPEG file?
Kind Regards
Using: Compact Framework 1.0 and SQL Server CE 2.0
i want to save an image to my sql server ce 2.0 database on the device.
In the Compact Framework 1.0 the Image class does not have .FromStream method, and the PictureBox class does not .Save method.
Has anyone done this before in SQL CE 2.0 and CF1.0
Thanks
I want to add a product photo in jpeg format to a products table. I'm storing the image of the product in separate jpeg files located in a folder on the same server that houses SQL Server. I don't want to store the photo directly in the table. I just want to reference the file location of the jpeg photo in a record.
Can someone provide me with code I need to add to the photo column for each record in the products table in order to reference the location of the jpeg photo associated with that record?
Subsequently, I want the photo to pop up in SQL Server Reporting Services product report.
Thank you.
David
When i click upload image button when my database table has no any row, the selected image is saved(one row saved in table). If i continue and select a different image, i get no error sa if the image has been saved but when i view the images i have been saving, its strange even if i saved 10 records they all contain the first image that i saved. In short only the first image is saved the rest of the rows are just duplicates of the first row. so it basically becomes a table of ten rows but with same data rows(same image). Code is below.
Protected Sub btnupload_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim intLength As Integer
Dim arrContent As Byte()
If FileUpload.PostedFile Is Nothing Then
Lblstatus.Text = "No file specified."
Exit Sub
Else
Dim fileName As String = FileUpload.PostedFile.FileName
Dim ext As String = fileName.Substring(fileName.LastIndexOf("."))
ext = ext.ToLower
Dim imgType = FileUpload.PostedFile.ContentType
If ext = ".jpg" Then
ElseIf ext = ".bmp" Then
ElseIf ext = ".gif" Then
ElseIf ext = "jpg" Then
ElseIf ext = "bmp" Then
ElseIf ext = "gif" Then
Else
Lblstatus.Text = "Only gif, bmp, or jpg format files supported."
Exit Sub
End If
intLength = Convert.ToInt32(FileUpload.PostedFile.InputStream.Length)
ReDim arrContent(intLength)
FileUpload.PostedFile.InputStream.Read(arrContent, 0, intLength)
If Doc2SQLServer(txtTitle.Text.Trim, arrContent, intLength, imgType) = True Then
Lblstatus.Text = "Image uploaded successfully."
Else
Lblstatus.Text = "An error occured while uploading Image... Please try again."
End If
End If
End Sub
Protected Function Doc2SQLServer(ByVal title As String, ByVal Content As Byte(), ByVal Length As Integer, ByVal strType As String) As Boolean
Try
Dim cnn As Data.SqlClient.SqlConnection
Dim cmd As Data.SqlClient.SqlCommand
Dim param As Data.SqlClient.SqlParameter
Dim strSQL As String
strSQL = "Insert Into Images(imgData,imgTitle,imgType,imgLength,incident_id) Values(@content,@title,@type,@length,@incident_id)"
Dim connString As String = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|safetydata.mdf;Integrated Security=True;User Instance=True"
cnn = New Data.SqlClient.SqlConnection(connString)
cmd = New Data.SqlClient.SqlCommand(strSQL, cnn)
param = New Data.SqlClient.SqlParameter("@content", Data.SqlDbType.Image)
param.Value = Content
'cmd.Parameters.AddWithValue(param)
cmd.Parameters.AddWithValue("@content", Content)
param = New Data.SqlClient.SqlParameter("@title", Data.SqlDbType.VarChar)
param.Value = title
cmd.Parameters.Add(param)
param = New Data.SqlClient.SqlParameter("@type", Data.SqlDbType.VarChar)
param.Value = strType
cmd.Parameters.Add(param)
param = New Data.SqlClient.SqlParameter("@length", Data.SqlDbType.BigInt)
param.Value = Length
cmd.Parameters.Add(param)
cmd.Parameters.AddWithValue("@incident_id", id.Text)
cnn.Open()
cmd.ExecuteNonQuery()
cnn.Close()
Return True
Catch ex As Exception
Return False
End Try
End Function
How to display an database image in the Report page header of sql server reporting service?
View 3 Replies View RelatedHi
i am using textcopy to store image (named as mypic.jpg) in image column.
But i am getting error :
text or image pointer and timestamp retrieval failed
I guess this is bacause of image size ...
The default image column length is 16. I tried changing it but it's not changing and Books Online shows that the image column can store max upto 2 GB.
I just want to know also how to change that size to say 100kb?????
thanx in advance
San
I am able to write an image to a SQL table. The problem I am having is understanding how to retrieve the image from the table AND display it on a page along with the other page content.
Does anyone have an example or an article to help me with this procedure? I have searched the discussion and read a few articles but they all talk about reading an image into a datagrid which isn't what I want.
Dazed & confused!!!
I'm trying to retrieve an image that I have stored in a SQL Server db, and display it in an .aspx page. It's supposed to retrieve just one image, according to a unique key that's passed. However, when I view the page, nothing appears... just the Internet Explorer missing image placeholder.
I've tried code from several diff tutorials, and can't seem to get it to work.
I'm aware that some people think it's not a good idea to store images in a db, but I have to in this case, since the requirements for this project are that the images are stored in the database. I already know how to store references to file paths of images located in a server folder. I've just never done it this way... storing the whole images in the database. The table has 3 columns, one for the id, "FileType" stores the image type, and the "ImageBinary" is the image itself.
If anyone can shine some light on why my code doesn't display anything, I'd greatly appreciated your help.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
Response.Write("Page Loaded") 'This is just for testing to see if the page loads at all
Dim myCommand As New SqlCommand("Select * from UserImages WHERE id=1234", myConnection)
Try
myConnection.Open()
Dim DR As SqlDataReader
DR = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
If DR.Read() Then
Response.ContentType = DR.Item("FileType")
Response.BinaryWrite(DR("ImageBinary"))
Else
Response.Write("no image found")
End If
myConnection.Close()
Response.Write("<br>Image successfully retrieved!")
Catch SQLexc As SqlException
Response.Write("Read Failed : " & SQLexc.ToString())
End Try
End Sub
Hello Guys, I am trying to display image on a report. The image field is stored as a binary data in the database. I am using webservice to access the database and return datasets through which data on the report can be accessed. I saw that the xml returns binarystring value from the database. but when i try to display the image it does not show me anything except blank page. I checked the value of the binary data and it does not proceed with ox and tried appending 0x value but no luck. Guys please help me.
View 2 Replies View Relatedwell, i'm using vs2005 and sql server 2000.i've got this snippet for uploading an image and creating itz thumbnail and also saving the thumbnail and the original image in a folder.but i also want the path of the image and the thumbnail to be stored in sql 2000 database, instead of saving the images in sql.can some one plz provide me the way.thanx in advance.-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click' Initialize variablesDim sSavePath As StringDim sThumbExtension As StringDim intThumbWidth As IntegerDim intThumbHeight As Integer' Set constant valuessSavePath = ".Image"sThumbExtension = "_thumb"intThumbWidth = 160intThumbHeight = 120' If file field isn’t emptyIf Not fileUpEx.PostedFile Is Nothing Then' Check file size (mustn’t be 0)Dim myFile As HttpPostedFile = fileUpEx.PostedFileDim nFileLen As Integer = myFile.ContentLengthIf nFileLen = 0 ThenlblStatus.Text = "No file was uploaded."ReturnEnd If' Check file extension (It must be .JPG)If System.IO.Path.GetExtension(myFile.FileName).ToLower() = ".jpg" Then' Read file into a data streamDim myData() As Byte = New Byte(nFileLen) {}myFile.InputStream.Read(myData, 0, nFileLen)' Make sure a duplicate file doesn’t exist. If it does, keep on appending an ' incremental numeric until it is uniqueDim sFilename As String = System.IO.Path.GetFileName(myFile.FileName)Dim file_append As Integer = 0While System.IO.File.Exists(Server.MapPath(sSavePath + sFilename))file_append = file_append + 1sFilename = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName) + file_append.ToString() + ".jpg"End While' Save the stream to diskDim NewFile As System.IO.FileStream = New System.IO.FileStream(Server.MapPath(sSavePath + sFilename), System.IO.FileMode.Create)NewFile.Write(myData, 0, myData.Length)NewFile.Close()' Check whether the file is really a JPEG by opening itDim myCallBack As System.Drawing.Image.GetThumbnailImageAbort = New System.Drawing.Image.GetThumbnailImageAbort(AddressOf ThumbnailCallback)Dim myBitmap As Drawing.BitmapTrymyBitmap = New Drawing.Bitmap(Server.MapPath(sSavePath + sFilename))' If jpg file is a jpeg, create a thumbnail filename that is unique.file_append = 0Dim sThumbFile As String = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName) + sThumbExtension + ".jpg"While System.IO.File.Exists(Server.MapPath(sSavePath + sThumbFile))file_append = file_append + 1sThumbFile = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName) + file_append.ToString + sThumbExtension + ".jpg"End While' Save thumbnail and output it onto the webpageDim myThumbnail As System.Drawing.Image = myBitmap.GetThumbnailImage(intThumbWidth, intThumbHeight, myCallBack, IntPtr.Zero)myThumbnail.Save(Server.MapPath(sSavePath + sThumbFile))imgPicture.ImageUrl = sSavePath + sThumbFile' Displaying success informationlblStatus.Text = "Image uploaded successfully!"' Destroy objectsmyThumbnail.Dispose()myBitmap.Dispose()Catch errArgument As ArgumentExceptionSystem.IO.File.Delete(Server.MapPath(sSavePath + sFilename))End TryElselblStatus.Text = "The file must have an extension of JPG or GIF"ReturnEnd If End SubPublic Function ThumbnailCallback() As BooleanReturn FalseEnd Function
View 2 Replies View RelatedI am trying to store about millions of pictures in Web server with lots of traffic. some poeple told me. SQL server cannot handle it and may freeze quickly. can anybody tell me which way is better and more efficent? store image in SQL server image field or store in server's harddrive?
View 13 Replies View RelatedHi folks,
I am really hoping there is someone out there with the answer to my problems??
I need to save customer signatures to our SQL DB and then display them on a Crystal Report. The problem is that the client uses Crystal v6. I am saving the image to an Image field using an ADO rs on a VB6 application. It saves fine and will read back fine. Crystal however has a problem and throws an error "Not Supported".(Later versions of Crystal erad the images fine)
Northwind Database has a Table 'Categories' which as images that crystal v6 is able to display. As of yet I have been unable to save images in this format. I have tried .bmp,.jpg ...... I have also tried appendChunk..
All the images on Northwind start with '0x151C2...'
My bmp start with '0xFFD8....'
Any suggestions would be greatly appreciated.
Hello,I'm having problems saving and then displaying binary data in sql server.I have a form that takes a file specified by the user and inserts this into sql server:protected void btnUploadFile_Click(object sender, EventArgs e) { if (theFile.PostedFile != null) { if (theFile.PostedFile.ContentLength > 0) { byte[] docBuffer = new byte[theFile.PostedFile.ContentLength]; Response.Write(theFile.PostedFile.ContentType.ToString()); if (docBuffer.Length > 0) { // save to db DbAccess dbAccess = new DbAccess(); // my helper function for all db access etc try { dbAccess.BuildCommand("Incentives_SaveDocument"); dbAccess.Parameters.Add("@docImage", SqlDbType.Image).Value = docBuffer; dbAccess.ExecuteNonQuery(); } catch (Exception ex) { Response.Write(ex.ToString()); } } } } }Stored proc:ALTER PROCEDURE Incentives_SaveDocument @docImage imageASSET NOCOUNT ONINSERT INTO Table1 (theData) VALUES (@docImage) RETURNThis appears to work fine. I store the binary data in a image column and if I query the db it shows the row as <Binary>.The problem I have is with retrieving the data and saving it to a file. The file saves OK but when I open it is contains lots of "squares" that I suppose are the binary - it doesn't show the text.The code for retrieving/displaying the doc is:protected void btnView_Click(object sender, EventArgs e) { DbAccess dbAccess = new DbAccess(); byte[] byteArray = null; try { dbAccess.BuildCommand("Incentives_RetrieveDocument"); dbAccess.Parameters.Add("@id", SqlDbType.Int).Value = 6; // id for the doc to return SqlDataReader reader1 = dbAccess.ReturnDataReader(); while (reader1.Read()) { if (reader1.HasRows) { byteArray = (byte[])reader1["theData"]; } } reader1.Close(); FileStream fs = new FileStream("file1", FileMode.CreateNew, FileAccess.Write); fs.Write(byteArray, 0, byteArray.Length); fs.Flush(); fs.Close(); FileInfo fileInfo = new FileInfo("file1"); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileInfo.Name); HttpContext.Current.Response.AddHeader("Content-Length", fileInfo.Length.ToString()); HttpContext.Current.Response.ContentType = "application/msword"; HttpContext.Current.Response.WriteFile(fileInfo.FullName); HttpContext.Current.Response.End(); } catch (Exception ex) { Response.Write(ex.ToString()); } finally { dbAccess.CloseDbConnection(); }The stored proc:ALTER PROCEDURE Incentives_RetrieveDocument @id intASSET NOCOUNT ONSELECT * FROM Table1 WHERE id = @id RETURNI would be grateful for any advice on this - its the first time I've worked with BLOB data.ThanksSi
View 2 Replies View RelatedVb stores an image (bitmap/jpg) in a SQL2000 image field. For somereason it doubles the size by adding 00 for each byte. But sometimes itdoesn't add 00 (0000.0000) but 01 or 20 or ?? and also the byte thatshould be transferd is changed...So SQLImageData = Imagebyte + 00and sometimesSQLImageData = CHANGEDImagebyte + xx.Some example data: (hex notation):A1 => A1 0003 => 03 00-----------91 => 18 2083 => 92 018C => 52 01Could anybody give me an explanation, because I need to know what ishappening, so I can remove te extra bytes added......I have already a image when I remove the extra bytes, but with somewrong data (on the place where things like 8C => 52 01 happen)....Thx,Geronimo
View 2 Replies View Relatedhi friends, i need a code for storing and receiving an image to/fro SQL SERVER 2000 (in C#). i had searched some sites, all are in VB for windows forms not for website. finally i got a code from some site. it is working for storing purpose. not working for receiving purpose. the code for receiving and displaying purpose is (in a fresh page) private void Page_Load(object sender, System.EventArgs e){ // Put user code to initialize the page here MemoryStream stream = new MemoryStream (); SqlConnection connection = new SqlConnection (@"server=INDIAINDIA;database=iSense;uid=sa;pwd=india"); try { connection.Open (); SqlCommand command = new SqlCommand ("select Picture from Image", connection); byte[] image = (byte[]) command.ExecuteScalar (); stream.Write (image, 0, image.Length); Bitmap bitmap = new Bitmap (stream); Response.ContentType = "image/gif"; bitmap.Save (Response.OutputStream, ImageFormat.Gif); } finally { connection.Close (); stream.Close (); }}what s the problem is.........i'm getting an exception at Bitmap instantiation.(i.e Bitmap bitmap = new Bitmap (stream);)exception is "Parameter is not valid" what is the problem with that coding? was it correct? do u have any code for this in C#? if so, pls provide that......help me........pls.............
View 2 Replies View Related
Hi,
I have a website and i am uploading the gif image to the database. i have used varchar(500) as the datatype and i am saving the file in the webserver so the path to it c:intepub....a.gif
my upload table has the folliwing feilds
UploadId Int Identity, Description, FileName, DiskPath varchar(500), weblocation varchar(500). I have a main sproc for the report where i am doing a inner join with other table to get the path of the gif..
So my question is how can i get a picture to show up on the report. .
What kinda datatype the gif file should be stored in the database? If it is stored as a varchar how can i access it and what is best way to reference that particular.
any help will appreciated....
Regards
Karen
Need advise on how to save objects like this in a sql2005 database, so they can be rendered to users thru a gridview control. Heard of saving a reference to location, but wondering if the entire object can be saved and served up with it's related data.
Thanks for your time.
Hello friends,
Can anybody pls explain me how I can store GIF,BMP,JPEG files in SQLServer
using Image data type or anything else .Thanks in advance.
Rajesh George.
Hello all,
I am making a query which will select those records from table where a column data ends with a particular extension,i.e.
I want the query to fetch the rocords where FileName(column name) ends with .JPEG or .GIF or .BMP.
I have five records in table and FileName(columns name) contains three .JPEG ,one .GIF & one .BMP files name.
How can i get for a particular extension?
Thanks in advance
I am trying to get JPG to show up in the Export list I have added another instance of the image renderer with a default to jpg. I also have added the following code to rsreportserver.config under Configuration/Extensions/Render:
<Extension Name="JPG" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-us">JPG</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>JPEG</OutputFormat>
</DeviceInfo>
</Configuration>
</Extension>
I have restarted the service and tried everything else I can thing of with no luck, it's just not showing up. Does anyone have suggestions?
Here is the version of my server. 9.00.3161.00 SP2 Standard Edition (64-bit)
Thanks
-JW
Hi Guys,
I am trying to automate a basic task using SQL Server 2005 Express.
Currently I have a query script that I run and then save the results as a CSV file. I need to do this on a daily basis and so I am looking to find out how best to go about this. There are a multitude of third party tools that claim to be able to do this - can anyone recommend this or enlighten me of the best way to set up this automation.
All ideas gratefully received!
Hey Guys need your help please!
we are now on our second week back log...
database file is not full and not limited to growth. As a matter of fact batch transactions are done but our proble is very slow. 28 records has been successfully save after 45 mins. Before it's just 5 minutes. Then some other process are not working. Is there anything that I must do? We have 460 tables in our software using SQL server 2000 and our application is using VB 6.0
Hello,I use SQL Server 2005 Express and I would liketo save on db of mine...Have I only to save the .mdf and .ldf data fileor I need to stop some service or other programs?Can I use some utility to schedule this?ThanksM.
View 4 Replies View RelatedMy install of SQL Server 2005 runs like a dog. The SQL Management Studio splash screen lasts for 10 minutes, then when the Studio window appears it takes another 5 minutes to initialize.
I have SQL server installed on a Germane Server running Windows Server 2K, SP4. It has quad Xeon 2.8 GHz processors with 2GB RAM. 4 300GB drives in a RAID 5 configuration.
I have created 2 databases which I would like to save, uninstall SQL, then reinstall it. (I didn't install it the first time.)
Then load the 2 databases into the new install.
How do I do this?
Hi.
I am new to SQL Server management.
I created a new database and also a table names customer. Saved my works.
Want ot know where the SQL database file has been saved because i cant find in the the sql server management folder located in my documents.
Also i tried to connect to that database from vb 2008 but in vain. i just cant see the database.
I'm a complete newbie. Need to insert a Company logo into a databasecolumn to use later on in a check printing application. Read how toinsert the pointer instead of the object into the column. Below iswhat I did:SET QUOTED_IDENTIFIER OFFGOINSERT INTO BankInfo(CoLogo) VALUES(0xFFFFFFFF)***Then I did this****DECLARE @Pointer_Value varbinary(16)Select @Pointer_Value = TEXTPTR(CoLogo)FROM BankInfoWHERE CMCo = '91'WRITETEXT BankInfo.CoLogo @Pointer_Value"\192.31.82.77DataCheckImagesWyattLogo.jpg"****This was straight out of a book and it seemed to work it gave me amessage that it was successful and when I view the data in the columnI can see the pointer0x453A5C436865636B496D616765735C57796174744C6F676F 2E6A7067*****But when I try to use the column in either Crytal Report or an AccessReport the Bank Logo does not show up. I also placed the logo on my Cdrive and tried pointing to it there with "C:WyattLogo.jpg" with nosuccess.It can't be this difficult to get a Company logo into a column. Idesperately need assistance. Remember I am the ultimate newbie. Ilooked at my first sql database last week. Thanks in advance for anyhelp, it is appreciated.
View 1 Replies View RelatedHi friends
plese help me for my little things.
I m student and develop a website. i want to know how images /pics and video and audio files are store in Sql server2005 database. and ya i want to store whole file not just its address.
i using asp page like uploadImage.aspx in that i put UploadFiles control now i m confuesd to storing Images so plese help me and give code or some good easy trick at my level
And once store image or video and audio file in sql database then after how i used in my asp.net page. which control i wish to used for this files so plese this also slove it. give also code or any easy trick for fullfil my task..
i hope u all help me
Thanx in advance to u all friends
I have 3 strings delimitted by a * character that I would like to save to a database. Each string will always have the same number of elements.
strUserID = "1*2*3"
strCompanyID="12931*12937*12945"
strCompanyName="International Business Machines, Inc*Ford Motor Company*Delta Airlines"
What I need to do is to save each record like this
INSERT INTO tableA (UserID, CompanyID, CompanyName) VALUES (1, 12931, 'International Business Machines, Inc')
INSERT INTO tableA (UserID, CompanyID, CompanyName) VALUES (2, 12937, 'Ford Motor Company')
INSERT INTO tableA (UserID, CompanyID, CompanyName) VALUES (3, 12945, 'Delta Airlines')
I've done something like this before with a single string, but don't know how to handle 3 of them.
Dim strAlerts As String() = NothingstrAlerts = values.Split(",")Dim s As String For Each s In strAlerts SqlText = "INSERT INTO tableA (UserID, CompanyID, CompanyName) VALUES (" & lblUserID.Text & ", '" & lblCompanyID.Text & "','" & s & "')" cmd = New SqlCommand(SqlText, strSQLConn) cmd.ExecuteNonQuery() Next s
Thanks for any help
has anyone got any opinions on the pros/cons of storing mp3 files in the database instead of the file system ?
How could this be done ? Would it be a binary data type ?
Im using MS visual web developer. I have created a website and used the database they set up by using admin tools. One page requires the take the users comment and to save it into the database. I've tried a formview and connected it to the database which worked. the problem is i cannot save whatever the user types into the textbox. {insert query didnt work with this set up }INSERT INTO aspnet_Membership(Comment) VALUES ('CommentTextBox.Text') Error: cannot set userId or to null. and if i make it allow nulls its going to move on to the next column. I would appreciate some help please. Thank you in advance.
View 4 Replies View Relatedhi
I have two questions:
1. I want a code to save data typed in a textbox during runtime using SQL server database. The database has a table with several colums where i have to reference the necessary column.
2. Can i use a Gridview to enter data during runtime and save the same data to the database? that is, INSERTING data to the database.
I'm looking for information that could tell me how to saving picture in a SQL database. The site is build on asp.net 2.0 and c#, and I'm using Visual Web Developer 2005 Express Edition. I would be thankful for some help.
View 1 Replies View Related