binding image in sql

Question

1.00/5 (1 vote)

See more:

I want to binding image in sql, I need get and set property value of image

for ex:

C#

private string _Username;

public string Username
{
get {return _username;}
set{_username=value;}

I want syntax for image.

Posted 26-Mar-15 22:55pm

Gokulprasad05

Updated 26-Mar-15 23:09pm

Afzaal Ahmad Zeeshan

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2015-03-26T23:22:00

Just the way you're giving string type for your username member, you will be giving a specific data type to your Image member.

It depends on your framework of application, to choose which object type for your data. Bitmap[^], Image[^], byte[][^] and all other such data types can fulfill your need of defining an Image object. You can then -- when required -- convert them into graphics object to represent your data.

In SQL, image field is also a field that contains arrays of byte. Which is given the value of byte arrays of the image (actually a file) and then can be retrieved as byte arrays and converted to files and so on.

I would also tip you, to not create another member while using getters and setters. Use it like,

C#

public string Username { get; set; }

This would have the same functionality of retrieving the Username and setting the Username and so on.

Naz_Firdouse · Answer 2 · 2015-03-27T01:00:00

Refer the below link...
Here the image is converted to byte array and saved in DB and retrieving those byte array.

http://www.c-sharpcorner.com/UploadFile/0f100d/storing-and-retrieving-image-from-sql-server-database-in-wpf/[^]

you can have a property like this
public BitmapImage bitmapImageSource { get; set; }

binding image in sql

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0