Store Image From Picture Box To SQL SERVER

-

My New Task

 Save Image from Picturebox to Sql Server Table.

Dim stream As New MemoryStream()
picEmp.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg)

 Dim oImgByteArray() As Byte
oImgByteArray()  = stream.ToArray
Dim SQLCmd As New SqlCommand
SQLCmd.Connection = cnSQL

 SQLCmd.Parameters.Add(New SqlParameter("@Img", SqlDbType.Image)).Value = oImgByteArray
SQLCmd.CommandText = "Insert Into CMS.mastImageStoreage (Img) Values (@Img)"
SQLCmd.ExecuteNonQuery()

 stream.close
SQLCmd.Dispose
Note : This is why love working on .net platform. If you were suppose perform same in VB 6.0. Physical file is need in path and than only you can save. Think  bring same from database. You have create physical file in drive and load it from there. 

Comments

Post a Comment

Popular posts from this blog

Shared / Static Class in vb.net/C#

-
Image
Shared / Static Class in vb.net/C# VB.net     : Shared C#            : Static You can’t create object of Shared Class Below Image show Properties and Method are not visible for Shared/Static Class Public Class Form1     Private Sub Button1_Click(sender As Object , e As EventArgs ) Handles Button1.Click         'Module is VB.net are Shared Type Class.         'Shared Class Example is ARC.Tools.GRIDManager         'When Class s Defined as Shared There no need to create object of Class.         'If you just want to create a class that you can't inherit, in C# you can use         ' Sealed, and in VB.Net use NotInheritable.         'The VB.Net equivalent of s...
Read more

Xamarin Forms - Change Colour of Navigation Bar (Page Title For Master-Detail Template)

-
Image
Change All Toolbar Bar Color (Toolbar is Actually Navigation Page) Navigation Page Title Colour can be Changed using Style Type in App.XAML Navigation Page Appears in case of Master-Details Template Type We need to create Global Style Type in APP.xaml Code :  <Style TargetType="NavigationPage">                           <Setter Property="BarBackgroundColor" Value="Color.LightGray"/> </Style>
Read more

How to Download File using HTTP - VB.net

-
How to Download File using HTTP - VB.net Private Sub DownloadFile()   Dim strURL As String = IO.Path.Combine(txtUpdateURL.Text, UpdateZipFileName).Replace("\", "/")                 strDownloadFilePath = IO.Path.Combine(txtUpdateDownloadPath.Text, UpdateZipFileName)                 If File.Exists(strDownloadFilePath) = True Then                     File.Delete(strDownloadFilePath)  ' ZIp File                                     System.Threading.Thread.Sleep(100)                 End If                 ServicePointManager.ServerCertificateValidationCallback = AddressOf AcceptAllCertifications                 ServicePointManager.SecurityProto...
Read more