Storing Images in SQL using VB.net
Asked By
300 points
N/A
Posted on - 04/28/2011
How to store images in SQl server database using vb.net.I am develop a software that store photo shop images.help me how to do this.
Best Answer
Best Answer
Storing Images in SQL using VB.net
Hi,
You can store and retrieve images in sql database using vb.net in form of binary.
Here is the code; I hope it will help you:
Private Sub UploadedFiles_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles UploadedFiles.DoubleClick
'
Dim drv As DataRowView = CType(UploadedFiles.SelectedItem, DataRowView)
Dim selectedText As String = drv.Row("Name").ToString()
Dim id As Long=-1
'
' the id is stored in text. The structure is: id – FileName.
'
id = Long.Parse(selectedText.Substring(0,selectedText.IndexOf(" – ",0)).Trim())
Dim filename As String=Nothing
Dim up As TransferPictures = New TransferPictures()
Dim result As Byte() = up.DownloadFile(id,filename)
up = Nothing
Try:
Dim ms As MemoryStream = New MemoryStream(result, 0, result.Length)
Dim im As Image = Image.FromStream(ms)
Picture.Image = im
Catch ee As Exception
MessageBox.Show("An error has occured.n" + ee.Message)
End Try
End Sub
End Class
End Namespace
Storing Images in SQL using VB.net
I have created a form where I want to store all types of images like BMP, .Jpg etc; tell me how to do this.
Storing Images in SQL using VB.net
Hi guys,
Here is the code to store images of all kind; Just create the object of images type like this PNG:
Dim storeImage As Bitmap = New Bitmap(100, 100)
Dim imgStream As New System.IO.MemoryStream
Dim ImgBytes As Byte()
storeImage.Save(imgStream, Imaging.ImageFormat.Png)
ImgBytes = imgStream.ToArray
Just change the format where it is PNG to store other types of images.
Storing Images in SQL using VB.net
Yeah, it's good code for you to try this. Remember one thing: first of all, you have to import this file into your program "Imports System.IO"
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cmbDrives.Items.Clear()
For Each objDrive As DriveInfo In My.Computer.FileSystem.Drives
If objDrive.IsReady Then
cmbDrives.Items.Add(objDrive.Name)
End If
Next
End Sub
Storing Images in SQL using VB.net
Thanks guys for help
Storing Images in SQL using VB.net
Welcome Mr. It's my pleasure
Latest Articles
GeniusTutor Review: AI Tutor Transformation In Education
In the contemporary educational landscape, where technology plays a pivotal role in shaping learning experiences, GeniusTutor has emerged as a beacon of innovation for students grappling with the complexities of mathematics.
This comprehensive review delves...
Krikya Bangladesh Review: A Comprehensive Guide To Its Betting Services
Discover the ins and outs of Krikya Bangladesh, a prominent bookmaker in the online betting scene. This detailed review covers everything from the diversity of sports betting options and casino games to user experience, security measures, and customer support efficiency. Whether you're a seasoned bettor or new to the online gambling world,
find out how Krikya stands out in the competitive market of Bangladesh.
Top Construction Management Apps
Construction management is essential to ensure project completion in a timely and cost-effective manner. Construction management software support businesses to operate efficiently. The software is available for all types of construction projects, including residential...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
