Imports System.Data.SqlClient Imports System.IO Sub Command1_click ' salvataggio in campo BLOB o OLE Dim con As New SqlConnection _ ("Server=YourServer;uid=<username>;pwd=<strong password>;database=northwind") Dim da As New SqlDataAdapter _ ("Select * From MyImages", con) Dim MyCB As SqlCommandBuilder = New SqlCommandBuilder(da) Dim ds As New DataSet() da.MissingSchemaAction = MissingSchemaAction.AddWithKey Dim fs As New FileStream _ ("C:\winnt\Gone Fishing.BMP", FileMode.OpenOrCreate, _ FileAccess.Read) Dim MyData(fs.Length) As Byte fs.Read(MyData, 0, fs.Length) fs.Close() con.Open() da.Fill(ds, "MyImages") Dim myRow As DataRow myRow = ds.Tables("MyImages").NewRow() myRow("Description") = "This would be description text" myRow("imgField") = MyData ds.Tables("MyImages").Rows.Add(myRow) da.Update(ds, "MyImages") fs = Nothing MyCB = Nothing ds = Nothing da = Nothing con.Close() con = Nothing MsgBox ("Image saved to database") End Sub Sub Command2_Click Dim con As New SqlConnection _ ("Server=YourServer;uid=<username>;pwd=<strong password>;database=northwind") Dim da As New SqlDataAdapter _ ("Select * From MyImages", con) Dim MyCB As SqlCommandBuilder = New SqlCommandBuilder(da) Dim ds As New DataSet() con.Open() da.Fill(ds, "MyImages") Dim myRow As DataRow myRow = ds.Tables("MyImages").Rows(0) Dim MyData() As Byte MyData = myRow("imgField") Dim K As Long K = UBound(MyData) Dim fs As New FileStream _ ("C:\winnt\Gone Fishing2.BMP", FileMode.OpenOrCreate, _ FileAccess.Write) fs.Write(MyData, 0, K) fs.Close() fs = Nothing MyCB = Nothing ds = Nothing da = Nothing con.Close() con = Nothing MsgBox ("Image retrieved") End Sub |