ado.net to sql server store procedure
You can try something like this:
Dim cmd As New SqlClient.SqlCommand("SP_SaveSketchImage", connect)
initializes the stored procedure that you want.
Dim p As SqlClient.SqlParameter
initializes so you can pass over parameters
-=-=-
Imports System.Data
Imports System.Data.SqlClient
Imports System.IO
Public Sub SaveImageToDatabase(ByVal FileName As String)
' Database operation variables
Dim Blank As String = ""
Dim connect As New
SqlClient.SqlConnection("server=KNIGHT;database=RealEstate;trusted_connectio
n=yes")
Dim cmd As New SqlClient.SqlCommand("SP_SaveSketchImage", connect)
Dim p As SqlClient.SqlParameter
' File/data variables
Dim imageStream As New FileStream(FileName, IO.FileMode.Open)
Dim imageData(imageStream.Length) As Byte
' Read the image data and close the stream
imageStream.Read(imageData, 0, imageStream.Length)
imageStream.Close()
' Save the image
cmd.CommandType = CommandType.StoredProcedure
Blank = IO.Path.GetFileNameWithoutExtension(FileName)
p.Value = DP(Blank, "-", 1)
cmd.Parameters.Add(p)
p.Value = DP(Blank, "-", 2)
cmd.Parameters.Add(p)
p.Value = DP(Blank, "-", 3)
cmd.Parameters.Add(p)
p.Value = imageData
cmd.Parameters.Add(p)
connect.Open()
cmd.ExecuteNonQuery()
connect.Close()
cmd.Dispose()
connect.Dispose()
End Sub
-=-=-=-=
regards,
Chris
