Linq To Sql, how to show picture from image field by drag - dropping

  • Hi, all:

    I used Ling To Sql, OR Designer to drag-drop Employees table from Northwind.mdf and showed all the fields on vb. winform but the photo from the image field. I wonder if it isn't the limitation of the method or what, and how?.

    Any comment on the matter would be appreciated.

    Regards

    Arayametee

  • arayametee (2/4/2014)


    Hi, all:

    I used Ling To Sql, OR Designer to drag-drop Employees table from Northwind.mdf and showed all the fields on vb. winform but the photo from the image field. I wonder if it isn't the limitation of the method or what, and how?.

    Any comment on the matter would be appreciated.

    Regards

    Arayametee

    Hi. You have posted a question about .NET coding (Winforms) in a forum designed to answer database questions.

    While it is off topic I can say that the problem you have results from a lack of understanding of how Winforms works, and the fact that you will have to set a PictureBox control on the form and then bind it to the column with the picture. There is much more than that, for example how to select image files to fill into the BLOB column. Again, this is a question best answered in numerous other places. It is not a database issue; it is how Visual Studio automates various accesses to a database.

    Thanks

    John.

  • arayametee (2/4/2014)


    Hi, all:

    I used Ling To Sql, OR Designer to drag-drop Employees table from Northwind.mdf and showed all the fields on vb. winform but not the photo/image showing[/url] from the image field[/url]. I wonder if it isn't the limitation of the method or what, and how?.

    Any comment on the matter would be appreciated.

    Regards

    Arayametee

    Maybe do some image conversion?:w00t:

    You can check this post for some information.

    http://stackoverflow.com/questions/11488191/picturebox-from-file-to-blob-to-sql-server-database-then-from-db-to-picturebox

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply