Reading and writing BLOB in ADO.NET

Sign in to leave a comment.

• PS

  pavan soni17y agoPosted Mar 17, 2009, 11:53 PM

  df
  • 

    Mahesh Chand17y agoPosted Apr 2, 2009, 1:35 PM

    Please do not post unnecessary comments.
• SY

  simon yong18y agoPosted Sep 18, 2008, 3:04 AM

  Sir, Can you tell me what is the function of this: adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
  • 

    Mahesh Chand17y agoPosted Apr 2, 2009, 1:35 PM

    Read here: http://msdn.microsoft.com/en-us/library/49z48hxc(VS.71).aspx
• BA

  Boris Aro19y agoeditedPosted Feb 7, 2007, 3:45 AMEdited Feb 12, 2007, 7:34 AM

  Hello! I work with VS2005. I have an Access Table, that has OLE Object as a field. The object may be a pointer to jpg, doc or xml file. Just in case jpg file I need to show it, in other case open it. I did next (not full code): Dim ms AsNew MemoryStream() Dim reader As OleDbDataReader = cmd.ExecuteReader(CommandBehavior.SequentialAccess ) reader.Read() retval = reader.GetBytes(0, 0, outbyte, 0, bufferSize) ms.Write(outbyte, 0, retval) ms.Seek(0, SeekOrigin.Begin) curImage = Image.FromStream(ms,False)----> error "Parameter is not valid." I do not see the fault. Please help
  • BA

    Boris Aro19y agoPosted Feb 12, 2007, 7:36 AM

    Thank You so much for Your response. I find ab error in SQL, but I have a problem: "Parameter is not valid." Please try to help. I may see gotten data. I have an OLE Object in my table, that may be jpg, doc, xml file. In case of jpg I'd like to show it (VS2005 Visual basic). I did next (not full code): Dim ms AsNew MemoryStream() Dim reader As OleDbDataReader = cmd.ExecuteReader(CommandBehavior.SequentialAccess ) reader.Read() retval = reader.GetBytes(0, 0, outbyte, 0, bufferSize) ms.Write(outbyte, 0, retval) ms.Seek(0, SeekOrigin.Begin) curImage = Image.FromStream(ms,False)----> error "Parameter is not valid." I do not see the fault. Please help
  • 

    Mahesh Chand19y agoPosted Feb 7, 2007, 11:02 AM

    Are you getting any data back? You will get this error if there is no data returned. I would say Debug your code and see if data is coming back.
  • 

    Mahesh Chand19y agoeditedPosted Feb 12, 2007, 9:24 AMEdited Feb 12, 2007, 9:25 AM

    Is your ms object "Nothing"? Debug it and check it. What version of .NET are you using? It is possible in .NET 2.0, method is changed a little. You will have to see MSDN documentation. I believe this article was written using .NET 1.0.