SQLiteBlob myBlob = myReader.GetSQLiteBlob(myReader.GetOrdinal("Picture")); if(!myBlob.IsNull) { string FN = myReader.GetString(myReader.GetOrdinal("PicName")); FileStream fs = new FileStream("D:\\Tmp\\"+FN+".bmp", FileMode.Create); fs.Write(myBlob.Value,0,(int)myBlob.Length); fs.Close(); Console.WriteLine(FN+" downloaded."); }
Dim myBlob As SQLiteBlob = myReader.GetSQLiteBlob(myReader.GetOrdinal("Picture")) If Not myBlob.IsNull Then Dim FN As String = myReader.GetString(myReader.GetOrdinal("PicName")) Dim fs As FileStream = New FileStream("D:\Tmp\" + FN + ".bmp", FileMode.Create) fs.Write(myBlob.Value, 0, Convert.ToInt32(myBlob.Length)) fs.Close() Console.WriteLine(String.Concat(FN, " downloaded.")) End If