We are developing applications using VB .NET as front end and SQL Server as back end. We want to store and retrieve pictures in a database. We do not want to store the pictures directly into the database but rather the path of the pcitures so that through the same paths we can retrieve them.
View 14 Replies
I have a problem with my code. My code is using the fileupload control to browse for a filename when you add a filename it processes it and the code runs fine on when it lives on local host, but when I put the code on our prodution server it cannot find the filenames listed by user.
For example if I use the upload control to browse to B:MISCH IntiveRPTTOFL_3.csv and the code lives on my localhost which know what that file path means it works, but if the code is moved to a production server it may or maynot know what B:/ is or B:/ maybe mapped to something else. Even if I am browsing to a file on my C drive it will work on if the code is on the machine that the C drive is on, but it will not work if the code is on another machine because obviously that file wouldnt be on that C drive.
[Code]...
I work at a school that utilizes several servers in our network. I wrote a program for a class I was teaching and then they changed the servers so there is a new path to the different components. When I test each component it works correctly but when I try to utilize the menu it utilizes the old path and the programs wont operateSteve.
View 3 Repliesthe pic above is the location of my pictures for example :C:Documents and SettingsJennieDesktopCWK 1PicturesXbox 360 will also have another 4 folders for the categories with the images in, i.e
/racing
/action
/sports
[Code].....
I current just call the image directory from row in my database, but when I move computer I have to change all the paths in "picture" to get them to show. What is wrong with the code I put in bold, am I doing something wrong
This code shows me the preview of a webcam in a picture box. I want to know how to save a frame as a picture file.The code I'm currently using to save it (in the timer tick event) gives me the "Object reference not set to an instance of an object." error..Then I used a debug assert line and it gave me an error that basically says that there is no image in the picture box, while I can clearly see a picture in the picture box. Can anyone please help me write/edit the code to save it?
[Code]...
I want to do that when i load form that saved picture is there. I tryed to make code but its dont work , dont show errors too. Mabye its not possible to do that.
Private Sub ToolStripLabel1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripLabel1.Click
Try
Dim dataloader As New System.IO.StreamReader("c:data/Picture.bmp")
PictureBox1.Text = dataloader.ReadToEnd
[code]....
I was wondering why my code doesn't work I want to save a picture from a picture box showing a webcam preview.
Code: picturebox1.Image.Save("C:UsersMyUserNameDesktopa.jpg") I think I need to use the "New" keyword to do something - but how?
i'm trying to save a picturebox but it gives me an error,
pictureBox.Image.Save(sDialog.FileName, System.Drawing.Imaging.ImageFormat.Jpeg)in runtime it gives me this error
"ExternalException is not handled "Generic error in GDI+ "
what's wrong?? to add changes on picturebox i do this pictureBox.CreateGraphics
I was wondering why my code doesn't work - I want to save a picture from a picture box showing a webcam preview.[code]
View 4 Repliesi have this code in saving a picture.
vb.net
empno = txtEmpNo.Text
Dim myFile As System.IO.FileInfo = New System.IO.FileInfo(imagelink)
'' Create a new stream to load this photo into
Dim myStream As FileStream = New FileStream(imagelink.ToString, FileMode.Open, FileAccess.Read)
'' Create a buffer to hold the stream of bytes
[Code]...
but when retrieving, i got an error on this part "Dim FinalImage As Bitmap = New Bitmap(myStream)". The error message goes like "System.ArgumentException: Parameter is not valid. at System.Drawing.Bitmap..ctor(Stream stream). maybe someone would like to help me, on where is the origin of this error.
I tried this but does not work..
dsNewRow.Item("picture") = PIS.PictureBox3.Image
Private Sub PictureBox2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PictureBox2.Click
openimage.Filter = "All Files|*.*|Image Files (*)|*.bmp;*.gif;*.jpg;*.png"
[code]....
I need to save pictures in my database, my database is MSSQL as of now, my code for getting the picture is this:
Private Sub browsepic_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles browsepic.Click
With dialogpic 'Open File Dialog sa toolbox
.InitialDirectory = "C:UsersCAMILLEPictures"
[code]....
how to save the picture and how to retrieve it?
A picture is displayed from a webcam into a picturebox. That picture must be saved to a specific folder.
View 6 RepliesI'm creating an application that works like a recipe box. it has a picture box that is in the design of an index card, and it has 3 text boxes. I am having extreme difficulty saving the text boxes with the picture. i am using a database so that the info can be filtered, by recipe name, course description (appetizer, side dish...etc).
[Code]...
I have some pictureboxes on this form set up to allow me to browse for images, then select one and show it in the box. How can I save the picture I pick so it updates a database and will show that picture when I cycle through the data in the program? It would be an SQL database and it already has columns for the picture. I don't know if I should store the path to the image or the image itself.
View 1 RepliesI've made a code which updates my database using a dataset and data binding source. I can retrieve all fields in the database including the �Picture� field which is set to �OLE Object� however I cannot update this. The Picture field in the dataset is set to type System,.Byte. I�ve search these forums and found how to do it manually which I can do and works but when it comes to the BindingSource.EndEdit section it still tries to update my �Picture� field and fails due to a type failure.
It was �System.InvalidCastException: Failed to convert parameter value from a Byte[] to a String. --->� What can I do to correct this? Below is my code. Note the image saves under the hard coding but not in the second part of the code.
Dim connection As New OleDb.OleDbConnection(My.Settings.AirportsConnectionString)
Dim command As New OleDb.OleDbCommand("UPDATE Airports SET Picture = @Picture WHERE ID = " & TextBox10.Text, connection)
'Create an Image object.
[code]....
When I try to save the picture and the picture is already existed it show an error
Me.Location = New System.Drawing.Point(50, 50) Create a new Bitmap object with the screen bounds Dim both As Bitmap = New Bitmap(166, 261, Imaging.PixelFormat.Format32bppArgb) Create a Graphics object that will process the screen shot front and back Dim bothgraph As Graphics = Graphics.FromImage(both) Copy the screen contents bothgraph.CopyFromScreen(0, 0, -506, -279, Screen.PrimaryScreen.Bounds.Size,opyPixelOperation.SourceCopy)' Save the resulting graphics
[Code]...
I'm making a screen capturing program, and I am trying to save the image. I can do it as a 'save as' like this
save as
savefiledialog1.Title = "Save File"
savefiledialog1.FileName = "Capture"
savefiledialog1.Filter = "JPEG (*.jpg;*.jpeg;*.jpe;*.jfif)|*.jpg;*.jpeg;*.jpe;*.jfif|PNG (*.png)|*.png"
[code]....
How could I do a quick save option so that it auto saves to a certain location that the user doesn't have to choose and as a .jpg?
I have a window form with a parent shown as detail items and two child as datagridsviews. They work perfect when saving and uploading data. The problem arises when I up load a picture to a picturebox and I go to save. I receive error dialog "System data invalid constraint exception: FK WineList_WinePurchase requires the child key values(1) to exist in the parent table. Not sure what happening when I add the picture.
Private
Sub WineList_Load(ByVal sender
As System.Object, ByVal e
As System.EventArgs) Handles
[code].....
Im wanting to load a picture into a picturebox before i start with saving the image. but im stuck i cant figure out how to make the code wait.
cover.ImageLocation = file
cover.Image.Save(path.Text & "mymovies-front.jpg", System.Drawing.Imaging.ImageFormat.Jpeg)
When i use the code above and chack the picture after save it shows me the "x" picture just before the picture is loaded i have had a look at picture.waitonload
I've written a simple application to encrypt an image (jpeg file) based on a password as a challenge to a mate of mine who reckons he's an ace hacker.I can encrypt the image no problem but when I try to save it using
[Code]...
I get "a generic error occurred in GDI+" raised. Googling reveals a few hits for this problem but seemingly mostly related to using databases rather than the file system.
Has anyone come across this? I don't want to paste all my code here in case my nemesis is watching, however basically I'm getting a reference to the PictureBox's Image property and manipulating the pixels using GetPixel and SetPixel, and then setting the picturebox's image property = my modified bitmap.
I understand that the error is generally related to the bitmap not being ready to be saved - is there anything specific I need to do to "close" the bitmap so it can be saved?The strange thing is that I'm sure this was working earlier today and now seems to have arbitrarily stopped working.
So here is the error...
An error occurred while saving the Panel. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.ThrowHelper.ThrowArgumentOutOfRangeException() at System.Collections.Generic.List`1.get_Item(Int32 index) at PanelController.Save(Int32 ID, FormCollection FormValues)
During debugging, I checked the parameter it was adding to the save stored proc, and the ID it was adding was 0. Then, when it used this
oDal.Execute("Lending.uspPanelSave")
Item.PanelId = oDal.Parameters("@PanelId").Value
To retrieve the ID to return it, it set it as 1000? Anyone know what the problem is?
my code doesn't show anything when ever I start on my button "start recording" it starts to record every keystroke on the and show it in a textbox and after that i am trying to get that data into text of a sql 2005 database with vb vs2008 but when ever I click on the button to show me the saved data , retrieve from database, it doesn't show anything, why?
and I also want to create new row everytime the new object is created...thnx
Databse Class
[code]
Imports System.Data.SqlClient
Public Class DataSaver
Private sqlConnection1 As SqlConnection
[Code].....
How to store the pictures and Movies in sql-server 2008 database
I want to make a database with pictures and front view as vb.net using Website.
I have been working on a project. In this project I wish to be able to create electronic signatures. I have perfected the signing routine and also creating the memory astream and saving and retrieving an image. The problem comes in when I retrieve the image from the database. The image being saved does not capture the signature (the changes I've made to the picturebox)
1. I load a small bmp as the template on where to sign with by setting the picturebox.imagelocation to a network share
2. Using mousemove and mouseclick, and draw events I draw a signature on top of the picture box
3. I picturebox.image.save(memorystream) the picture box to a sql server from a button click event.
4. When I retrieve the saved image there are no edits (No signature) only the original image. I am sure that the original image is going in and that it is coming out every time.
My question is thus: How can I capture the signature that I have edited into the picture box. I have tried picturebox.save like I mentioned above and I have tried picturebox.update() but without success. Does anyone know what I missing I think that the answer lies in refreshing or updating the picturebox, but I'm not sure how.
I'm working on a project, where I need to save data along with the image in Sql server, using Vb 2005. i just need the code for the above one.
View 11 RepliesI have binded a textbox to a column in a SQL Server 2005 Database, when i fill the dataset it displays the data, but when i click the save button it doesn not save the changes to the database. I used this same code to do a Datagridview and it worked fine. [code]
View 2 Repliesi am trying to save data from vb.net form in sql server 2008 below is the code which i am using but the only problem is . i am not getting any error instead the data which is being saved in sql server in my First Name , Last Name and Address fields is not the one i insert into textboxes, when i check the backend it shows me my field values as first name , last name and address.
Dim FirstName As String
Dim LastName As String
Dim Address As String
[Code].....
i want to save a finger print file to a sql server table and then i also wanted to read it when you tap the finger print reader and it will input a time in :)
View 6 RepliesI have a table in SQL Server with a field defined as Varbinary (MAX). In VB I am trying to save an image to the table. The file I'm using is 139kB in size and I get no errors but when I look at the record, the Attachment column where my image stream should be is empty. The rest of the information is saved. I checked the buffer and it grabs the correct size of the file (141475) so I'm very sure it's found and loaded the image.
Could the parameter from the SQL not be passing the binary value to the parameter properly?
[Code]...
