How to Put the image from SQL to page in c#

up vote
1
down vote

favorite

I use this at my class

  public byte Picture { get; set; }

And this to my view but

  @foreach (var item in Model.EmployeeCollection)

    {

        <div class="row">

            <div class="col-sm-1">

                <span alt="image" class="img-lg" >@item.Picture</span>

                <div class="col-sm-4">

             </div>

         </div>

     }

but to the image section in the web it doesn't show the image but it only show this

System.Byte

How can i fix this ?

i even try this but its the same

  @foreach (var item in Model.EmployeeCollection)

    {

        <div class="row">

            <div class="col-sm-1">

                <img alt="image" class="img-lg" src="@item.Picture">

                <div class="col-sm-4">

             </div>

         </div>

     }

edited Nov 8 at 13:33

D-Shih

23.9k61331

asked Nov 8 at 13:21

E.Lahu

135

1

Did you see this?
– Peter Schneider
Nov 8 at 13:25

add a comment |

up vote
1
down vote

favorite

I use this at my class

  public byte Picture { get; set; }

And this to my view but

  @foreach (var item in Model.EmployeeCollection)

    {

        <div class="row">

            <div class="col-sm-1">

                <span alt="image" class="img-lg" >@item.Picture</span>

                <div class="col-sm-4">

             </div>

         </div>

     }

but to the image section in the web it doesn't show the image but it only show this

System.Byte

How can i fix this ?

i even try this but its the same

  @foreach (var item in Model.EmployeeCollection)

    {

        <div class="row">

            <div class="col-sm-1">

                <img alt="image" class="img-lg" src="@item.Picture">

                <div class="col-sm-4">

             </div>

         </div>

     }

edited Nov 8 at 13:33

D-Shih

23.9k61331

asked Nov 8 at 13:21

E.Lahu

135

1

Did you see this?
– Peter Schneider
Nov 8 at 13:25

add a comment |

up vote
1
down vote

favorite

I use this at my class

  public byte Picture { get; set; }

And this to my view but

  @foreach (var item in Model.EmployeeCollection)

    {

        <div class="row">

            <div class="col-sm-1">

                <span alt="image" class="img-lg" >@item.Picture</span>

                <div class="col-sm-4">

             </div>

         </div>

     }

but to the image section in the web it doesn't show the image but it only show this

System.Byte

How can i fix this ?

i even try this but its the same

  @foreach (var item in Model.EmployeeCollection)

    {

        <div class="row">

            <div class="col-sm-1">

                <img alt="image" class="img-lg" src="@item.Picture">

                <div class="col-sm-4">

             </div>

         </div>

     }

edited Nov 8 at 13:33

D-Shih

23.9k61331

asked Nov 8 at 13:21

E.Lahu

135

I use this at my class

  public byte Picture { get; set; }

And this to my view but

  @foreach (var item in Model.EmployeeCollection)

    {

        <div class="row">

            <div class="col-sm-1">

                <span alt="image" class="img-lg" >@item.Picture</span>

                <div class="col-sm-4">

             </div>

         </div>

     }

but to the image section in the web it doesn't show the image but it only show this

System.Byte

How can i fix this ?

i even try this but its the same

  @foreach (var item in Model.EmployeeCollection)

    {

        <div class="row">

            <div class="col-sm-1">

                <img alt="image" class="img-lg" src="@item.Picture">

                <div class="col-sm-4">

             </div>

         </div>

     }

edited Nov 8 at 13:33

D-Shih

23.9k61331

asked Nov 8 at 13:21

E.Lahu

135

edited Nov 8 at 13:33

D-Shih

23.9k61331

asked Nov 8 at 13:21

E.Lahu

135

edited Nov 8 at 13:33

D-Shih

23.9k61331

edited Nov 8 at 13:33

D-Shih

23.9k61331

edited Nov 8 at 13:33

D-Shih

23.9k61331

asked Nov 8 at 13:21

E.Lahu

135

asked Nov 8 at 13:21

E.Lahu

135

asked Nov 8 at 13:21

E.Lahu

135

1

Did you see this?
– Peter Schneider
Nov 8 at 13:25

add a comment |

1

Did you see this?
– Peter Schneider
Nov 8 at 13:25

Did you see this?
– Peter Schneider
Nov 8 at 13:25

add a comment |

1 Answer
1

active

oldest

votes

up vote
2
down vote

accepted

This can be done easily with Convert.ToBase64String()

string Image = "data:Image/png;base64," + Convert.ToBase64String(bytes);

Then used like this

<img scr="@Image">

answered Nov 8 at 13:27

Patte

548218

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53208619%2fhow-to-put-the-image-from-sql-to-page-in-c-sharp%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
2
down vote

accepted

This can be done easily with Convert.ToBase64String()

string Image = "data:Image/png;base64," + Convert.ToBase64String(bytes);

Then used like this

<img scr="@Image">

answered Nov 8 at 13:27

Patte

548218

add a comment |

up vote
2
down vote

accepted

This can be done easily with Convert.ToBase64String()

string Image = "data:Image/png;base64," + Convert.ToBase64String(bytes);

Then used like this

<img scr="@Image">

answered Nov 8 at 13:27

Patte

548218

add a comment |

up vote
2
down vote

accepted

This can be done easily with Convert.ToBase64String()

string Image = "data:Image/png;base64," + Convert.ToBase64String(bytes);

Then used like this

<img scr="@Image">

answered Nov 8 at 13:27

Patte

548218

This can be done easily with Convert.ToBase64String()

string Image = "data:Image/png;base64," + Convert.ToBase64String(bytes);

Then used like this

<img scr="@Image">

answered Nov 8 at 13:27

Patte

548218

answered Nov 8 at 13:27

Patte

548218

answered Nov 8 at 13:27

Patte

548218

answered Nov 8 at 13:27

Patte

548218

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Agfdhyk